A00-212 Actual Exam Questions

Last updated on Dec. 5, 2024.
Vendor:SAS Institute
Exam Code:A00-212
Exam Name:SAS Advanced Programming for SAS 9
Exam Questions:184
 

Topic 1 - Single Topic

Question #1 Topic 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?

  • A. The index on STATE is deleted and an index on ST is created
  • B. The index on STATE is recreated as an index on ST
  • C. The index on STATE is deleted
  • D. The index on STATE is updated as an index on ST
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #2 Topic 1

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?

  • A. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro
  • B. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro
  • C. A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table
  • D. A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #3 Topic 1

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

  • A. OBS=pointobs
  • B. POINT=pointobs
  • C. KEY=pointobs
  • D. NOBS=pointobs
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #4 Topic 1

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

  • A. A variable that represents the total number of observation in the output data set(s)
  • B. A variable that represents a flag indicating the end of the file
  • C. A variable that represents the total number of observations in the input data set(s)
  • D. A variable that represents the current observation number
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

file Viewing page 1 out of 46 pages.
Viewing questions 1-4 out of 184 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago