← Back to exam page

Free A00-212 – SAS Advanced Programming for SAS 9 Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 6 questions

Question 4

Which one of the following should be avoided when creating and using an SQL procedure view?

Select an option, then click Submit answer.

  • ○

    using a HAVING clause

  • ○

    using summary functions

  • ○

    referencing a view multiple times in the same program

  • ○

    creating views on tables whose structures remain constant

Question 5

Which one of the following options controls the pagesize of a SAS data set?

Select an option, then click Submit answer.

  • ○

    SIZE=

  • ○

    BUFNO=

  • ○

    BUFSIZE=

  • ○

    PAGESIZE=

Question 6

Given a SAS data set with the following characteristics:

✑ 200 million observations

✑ 300 variables

✑ Compressed

✑ Resides on a network location

A SAS DATA Step program is written that will retrieve 20% of the data using a search based on a range of a character variable.

Which type of statement is the best choice to minimize computer resource utilization when subsetting this data?

Select an option, then click Submit answer.

  • ○

    KEEP/DROP

  • ○

    WHERE

  • ○

    CASE

  • ○

    IF/THEN/ELSE