Sure Pass Exam A00-212 PDF

A data set stored on a network drive has the following characteristics:

• 14 Million observations
• 400 numeric variables
• 0 character variables of length 20
• Binary compression

A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?

The following SAS program is submitted:

%macro test(var);

proc print data = sasuser.class;

where age > &var;

run;

%mend;

Which type of parameter is the macro variable VAR?

Which one of the following techniques concatenates data in SAS?

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?