SASInstitute A00-212 (SAS Advanced Programming Exam for SAS 9) 시험을 패스하는게 힘들다고 생각하시는 분들이 많습니다.도전해보지도 않고 어렵다고 생각하는 부정적 마인드는 버려야 합니다. 꼭 패스해야 되는 시험이라면 내가 무조건 해낼수 있다 라고 굳게 믿어야 합니다.목표가 있으면 방법을 찾기 마련입니다.꼭 패스하리라고 굳게 다짐하면 여기저기 시험에 대해 알아보려고 검색하고 그러다 보면 좋은 시험대비자료를 찾게 되고 그러다보면 pass4test와 인연이 생기고 SASInstitute A00-212 (SAS Advanced Programming Exam for SAS 9) 덤프로 목표를 이루게 되고 그런것이 아니겠습니까? 어떤 일에서나 긍정적 마인드를 가지면 꿈을 이룰수 있습니다.
NO.1 The following SAS program is submitted:
%let dept=prod;
%let prod=merchandise;
The following message is written to the SAS log:
The value is "merchandise"
Which SAS System option writes this message to the SAS log? A. %put the value is "&&&dept";
B. %put the value is "&&&dept";
C. %put the value is "&&&dept";
D. %put the value is %quote(&&&dept);
Answer: A
NO.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. 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
Answer: C
NO.3 Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data
set?
A. DATASETS
B. MODIFY
C. FORMAT
D. REGISTRY
Answer: A
NO.4 Given the SAS data sets ONE and TWO:
The following SAS program is submitted:
Proc sql;
Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year,
Quit;
The following output is desired:
Which JOIN operator completes the program and generates the desired output? A. FULL JOIN
B. INNER JOIN
C. LEFT JOIN
D. RIGHT JOIN
Answer: A
NO.5 Which SQL procedure program deletes rows from the data set CLASS? A. proc sql;
Select * from class
Where age<(select stop_age from threshold);
Quit;
B. proc sql;
Modify table class
Delete where age<(select stop_age from threshold);
Quit
C. proc sql;
Delete from class
Where age<(select stop_age from threshold);
Quit;
D. proc sql;
Alter from class
Delete where age<(select stop_age from threshold);
Quit;
Answer: C
NO.6 The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
A. It uses the WORK.TEMPDATA SAS data set as input to create the format
B. All formats created will be stored in two WORK.TEMPDATA SAS data set
C. An ERROR message is written to the SAS log because the program is incomplete
D. NO formats are created in this step
Answer: A
NO.7 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?
A. result is
B. result is 10.5
C. result is 10+0.5
D. result is 10
Answer: B
NO.8 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
Answer: C