File Info
| Exam | SAS Advanced Programming Exam for SAS 9 |
| Number | A00-212 |
| File Name | SASInstitute.A00-212.CertDumps.2018-01-03.184q.tqb |
| Size | 11 MB |
| Posted | Jan 03, 2018 |
| Download | SASInstitute.A00-212.CertDumps.2018-01-03.184q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 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?
- The index on STATE is deleted and an index on ST is created
- The index on STATE is recreated as an index on ST
- The index on STATE is deleted
- The index on STATE is updated as an index on ST
Correct answer: C
Question 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?
- A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro
- A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro
- A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table
- A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table
Correct answer: C
Question 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?
- OBS=pointobs
- POINT=pointobs
- KEY=pointobs
- NOBS=pointobs
Correct answer: B
