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

A00-212 exam is a hot SAS Certification exam.Candidates who earn this credential must have a SAS Certified Base Programmer for SAS®9 credential and then take and pass the SAS Advanced Programming for SAS®9 exam.You can practice in the following A00-212 free questions collected from Passquestion,if you study A00-212 full version, you will surely pass your SAS Advanced Programming Exam for SAS 9 exam easily.

This exam is administered by SAS and Pearson VUE.
60-65 multiple-choice and short-answer questions.
(Must achieve score of 65 percent correct to pass).
Two hours to complete exam.
Use exam ID A00-212; required when registering with Pearson VUE.
This exam is based on SAS 9.4.
Exam fee: $180 USD in the U.S. and most other countries.

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?

 
 
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *