SAS Institute A00-212 Exam (page: 1)
SAS Institute SAS Advanced Programming Exam for SAS 9
Updated on: 28-Jul-2025

Viewing Page 1 of 38

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?

  1. The index on STATE is deleted and an index on ST is created
  2. The index on STATE is recreated as an index on ST
  3. The index on STATE is deleted
  4. The index on STATE is updated as an index on ST

Answer(s): C



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?

  1. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro
  2. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro
  3. A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table
  4. A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table

Answer(s): C



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

  1. OBS=pointobs
  2. POINT=pointobs
  3. KEY=pointobs
  4. NOBS=pointobs

Answer(s): B



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

  1. A variable that represents the total number of observation in the output data set(s)
  2. A variable that represents a flag indicating the end of the file
  3. A variable that represents the total number of observations in the input data set(s)
  4. A variable that represents the current observation number

Answer(s): C



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?

  1. result is
  2. result is 10
  3. result is 10.5
  4. result is 10+0.5

Answer(s): C



Viewing Page 1 of 38



Share your comments for SAS Institute A00-212 exam with other users:

Shikha Bakra 9/10/2023 5:16:00 PM

awesome job in getting these questions
AUSTRALIA


Kevin 10/20/2023 2:01:00 AM

i cant find aws certified practitioner clf-c01 exam in aws website but i found aws certified practitioner clf-c02 exam. can everyone please verify the difference between the two clf-c01 and clf-c02? thank you
UNITED STATES


D Mario 6/19/2023 10:38:00 PM

grazie mille. i got a satisfactory mark in my exam test today because of this exam dumps. sorry for my english.
ITALY


Bharat Kumar Saraf 10/31/2023 4:36:00 AM

some of the answers are incorrect. need to be reviewed.
HONG KONG


JP 7/13/2023 12:21:00 PM

so far so good
Anonymous


Kiky V 8/8/2023 6:32:00 PM

i am really liking it
Anonymous


trying 7/28/2023 12:37:00 PM

thanks good stuff
UNITED STATES


exampei 10/4/2023 2:40:00 PM

need dump c_tadm_23
Anonymous


Eman Sawalha 6/10/2023 6:18:00 AM

next time i will write a full review
GREECE


johnpaul 11/15/2023 7:55:00 AM

first time using this site
ROMANIA


omiornil@gmail.com 7/25/2023 9:36:00 AM

please sent me oracle 1z0-1105-22 pdf
BANGLADESH


John 8/29/2023 8:59:00 PM

very helpful
Anonymous


Kvana 9/28/2023 12:08:00 PM

good info about oml
UNITED STATES


Checo Lee 7/3/2023 5:45:00 PM

very useful to practice
UNITED STATES


dixitdnoh@gmail.com 8/27/2023 2:58:00 PM

this website is very helpful.
UNITED STATES


Sanjay 8/14/2023 8:07:00 AM

good content
INDIA


Blessious Phiri 8/12/2023 2:19:00 PM

so challenging
Anonymous


PAYAL 10/17/2023 7:14:00 AM

17 should be d ,for morequery its scale out
Anonymous


Karthik 10/12/2023 10:51:00 AM

nice question
Anonymous


Godmode 5/7/2023 10:52:00 AM

yes.
NETHERLANDS


Bhuddhiman 7/30/2023 1:18:00 AM

good mateial
Anonymous


KJ 11/17/2023 3:50:00 PM

good practice exam
Anonymous


sowm 10/29/2023 2:44:00 PM

impressivre qustion
Anonymous


CW 7/6/2023 7:06:00 PM

questions seem helpful
Anonymous


luke 9/26/2023 10:52:00 AM

good content
Anonymous


zazza 6/16/2023 9:08:00 AM

question 21 answer is alerts
ITALY


Abwoch Peter 7/4/2023 3:08:00 AM

am preparing for exam
Anonymous


mohamed 9/12/2023 5:26:00 AM

good one thanks
EGYPT


Mfc 10/23/2023 3:35:00 PM

only got thru 5 questions, need more to evaluate
Anonymous


Whizzle 7/24/2023 6:19:00 AM

q26 should be b
Anonymous


sarra 1/17/2024 3:44:00 AM

the aaa triad in information security is authentication, accounting and authorisation so the answer should be d 1, 3 and 5.
UNITED KINGDOM


DBS 5/14/2023 12:56:00 PM

need to attend this
UNITED STATES


Da_costa 8/1/2023 5:28:00 PM

these are free brain dumps i understand, how can one get free pdf
Anonymous


vikas 10/28/2023 6:57:00 AM

provide access
EUROPEAN UNION