A00-212 Free Questions – SAS Advanced Programming Exam for SAS 9

1. The following SAS program is submitted:

Data sasuser.history;

Set sasuser.history(keep=state x y

Rename = (state=ST));

Total=sum(x, y);

Run;

The SAS data set SASUSER.HISTORY has an index on the variable STATE.

Which describes the result of submitting the SAS program?

2. The following SAS program is submitted:

%macro one (input);

%two;

%put the value is &date;

%mend;

%macro two;

data _null_;

call symput(‘date’,’12SEP2008′);

run;

%mend;

%let date=31DEC2006;

%one(&date)

What is the result when the %PUT statement executes?

3. Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

4. When reading a SAS data file, what does the NOBS=option on the SET statement represent?

5. CORRECT TEXT

The following SAS program is submitted:

%macro check(num=4);

%let result=%sysevalf(&num+0.5);

%put result is &result;

%mend;

%check(num=10)

What is the written to the SAS log?

6. The following SAS program is submitted:

%micro test(var);

%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;

%let type=%index(&jobs, &var);

%put type = &type;

%mend;

%test(SMITH)

What is the value of the macro variable TYPE when the %PUT statement executes?

7. The following SAS program is submitted:

%macro check(num=4);

%let result=%eval(&nm gt 5);

%put result is &result;

%mend;

%check (num=10)

What is written to the SAS log?

8. The following SAS program is submitted:

data temp;

length 1 b 3 x;

infile ‘file reference’;

input a b x;

run;

What is the result?

9. The following SAS program is submitted:

%let dept=prod;

%let prod=merchandise;

The following message is written to the SAS log:

The value is “merchandise”

Which SAS System option writes this message to the SAS log?

10. The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations.

The following SAS program is submitted:

Proc format cntlin=wor.tempdata;

Run;

What is the result of submitting the FORMAT procedure step?