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 4 )

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

Which one of the following statements about compressed SAS data sets is always true?

  1. Each observation is treated as a single string of bytes.
  2. Each observation occupies the same number of bytes.
  3. An updated observation is stored in its original location.
  4. New observations are added to the end of the SAS data set.

Answer(s): A



Given the following SAS data set ONE:

ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
data _null_;
set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;

Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

  1. null
  2. 1234
  3. 3654
  4. 5678

Answer(s): D



The following SAS program is submitted:

proc contents data = testdata.one; run;

Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

  1. proc sql;
    show testdata.one;
    quit;
  2. proc sql;
    describe testdata.one;
    quit;
  3. proc sql;
    show table testdata.one;
    quit;
  4. proc sql;
    describe table testdata.one;
    quit;

Answer(s): D



Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

  1. proc datasets lib = sasuser.all;
    quit;
  2. proc datasets lib = sasuser._all_;
    quit;
  3. proc datasets lib = sasuser;
    contents data = all;
    quit;
  4. proc datasets lib = sasuser;
    contents data = _all_;
    quit;

Answer(s): D



The following SAS program is submitted:
%let name = Patel's Restaurant;

Which one of the following statements avoids problems associated with the unbalanced quotation mark?

  1. %let name = Patel%'s Restaurant;
  2. %let name = %str(Patel's Restaurant);
  3. %let name = Patel%str(')s Restaurant;
  4. %let name = %str(Patel%'s Restaurant);

Answer(s): D



Viewing page 4 of 38
Viewing questions 16 - 20 out of 184 questions



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

Join the A00-212 Discussion