Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. SAS Institute
  5. A00-212

SAS Institute A00-212 Exam
SAS Advanced Programming Exam for SAS 9 (Page 6 )

Updated On: 26-Jan-2026
Page 6 of 38
PDF with 184 Questions

The following SAS program is submitted:

proc datasets lib = testdata;
modify one;
label num = 'Number';
format num 4.;
quit;

Which one of the following SQL programs produces the same results as the above DATASETS procedure?

  1. proc sql;
    modify table testdata.one
    num format = 4.
    label = 'Number';
    quit;
  2. proc sql;
    alter table testdata.one
    modify num format = 4.
    label = 'Number';
    quit;
  3. proc sql;
    modify table testdata.one
    alter num format = 4.
    label = 'Number';
    quit;
  4. proc sql;
    alter table testdata.one
    modify num (format = 4.
    label = 'Number');
    quit;

Answer(s): B



This question will ask you to provide a segment of missing code.
Given data sets ONE and TWO with the same variables, the following SAS program is submitted:


In the text below, complete the following program so that it will produce the same results as the above program:


Case is ignored and standard SAS syntax rules apply.

  1. CORR
  2. JOIN

Answer(s): A


Reference:

http://www.koerup.dk/Cert/0104/010405/010405.html



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?

  1. default
  2. keyword
  3. positional
  4. command

Answer(s): C



The following SAS program is submitted:

%let first = yourname;
%let last = first;
%put &&&last;

Which one of the following is the result in the log of the %PUT statement?

  1. first
  2. &first
  3. yourname
  4. &yourname

Answer(s): C



Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

  1. %let start = today(),weekdate.;
  2. %let start = today(),format=weekdate.;
  3. %let start = %sysfunc(today(),weekdate.);
  4. %let start = %sysfunc(%today(),weekdate.);

Answer(s): C



Viewing page 6 of 38
Viewing questions 26 - 30 out of 184 questions



Post your Comments and Discuss SAS Institute A00-212 exam prep with other Community members:

Join the A00-212 Discussion