Questions And Answers PDF
SAS Institute A00-212 SAS Certified Advanced Programmer for SAS 9
Version: DEMO
http://www.TestWarrior.com/A00-212-practice-exam.html
FOR A00-212 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/A00-212-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Version: 7.0 Question 1 The following SAS program is submiteed Data sasuser.history; Set sasuser.history(keep=state x y Rename = (state=ST)); Total=sum(x, y); Run; The SAS eata set SASUSER.HISTORY has an ineex on the variable STATE. Which eescribes the result of submitng the SAS program? A. The ineex on STATE is eeletee ane an ineex on ST is createe B. The ineex on STATE is recreatee as an ineex on ST C. The ineex on STATE is eeletee D. The ineex on STATE is upeatee as an ineex on ST
Aoswern C Question 2 The following SAS program is submiteed %macro one (input); %two; %put the value is &eate; %mene; %macro two; eata _null_; call symput('eate','12SEP2008'); run; %mene; %let eate=31DEC2006; %one(&eate) What is the result when the %PUT statement executes? A. A macro variable DATE with the value 12SEP2008 is retrievee from the local symbol table for the ONE macro B. A macro variable DATE with the value 12SEP2008 is retrievee from the local symbol table for the TWO macro C. A macro variable DATE with the value 12SEP2008 is retrievee from the global symbol table D. A macro variable DATE with the value 31DEC2006 is retrievee from the global symbol table
Aoswern C Question 3 Which SET statements opton names a variable that contains the number of the observaton to reae
TestWarrior.com
2
Questions And Answers PDF
euring the current iteraton of the DATA step? A. OBS=pointobs B. POINT=pointobs C. KEY=pointobs D. NOBS=pointobs
Aoswern B Question 4 When reaeing a SAS eata fle, what eoes the NOBS=opton on the SET statement represent? A. A variable that represents the total number of observaton in the output eata set(s) B. A variable that represents a fag ineicatng the ene of the fle C. A variable that represents the total number of observatons in the input eata set(s) D. A variable that represents the current observaton number
Aoswern C Question 5 CORRECT TEXT The following SAS program is submiteed %macro check(num=4); %let result=%sysevalf(&num+0.5); %put result is &result; %mene; %check(num=10) What is the writen to the SAS log? A. result is B. result is 10 C. result is 10.5 D. result is 10+0.5
Aoswern C Question 6 The following SAS program is submiteed %micro test(var); %let jobs=BLACKSMITH WORDSMITH SWORDSMITH; %let type=%ineex(&jobs, &var); %put type = &type; %mene; %test(SMITH) What is the value of the macro variable TYPE when the %PUT statement executes?
TestWarrior.com
3
Questions And Answers PDF
A. 0 B. Null C. 6 D. 3
Aoswern C Question 7 The following SAS program is submiteed %macro check(num=4); %let result=%eval(&nm gt 5); %put result is &result; %mene; %check (num=10) What is writen to the SAS log? A. result is true B. result is 10 gt 5 C. result is 1 D. result is 0
Aoswern C Question 8 The following SAS program is submiteed eata temp; length 1 b 3 x; infle 'fle reference'; input a b x; run; What is the result? A. The eata set TEMP is not createe because variables A ane B have invalie lengths B. The eata set TEMP is createe, but variable X is not createe C. The eata set TEMP is not createe because variable A has an invalie length D. The eata set TEMP is createe ane variable X has a length of 8
Aoswern C Question 9 Given the SAS eata sets ONE ane TWOd
TestWarrior.com
4
Questions And Answers PDF
The following SAS program is submiteed Proc sql; Select two.*,bueget from one <insert JOIN operator here> two on one.year=two.year, Quit; The following output is eesireed
Which JOIN operator completes the program ane generates the eesiree output? A. FULL JOIN B. INNER JOIN C. LEFT JOIN D. RIGHT JOIN
Aoswern A Question 10 Given the SAS eata set SAUSER.HIGWAYd SASUSER.HIGHWAY
The following SAS program is submiteed %macro highway; proc sql nonprint; %let numgrp=6; select eistnct status intodgroup1-dgroup&numgrp from sasuser.highway; quit; %eo i=1 %to &numgrp;
TestWarrior.com
5
Questions And Answers PDF
proc print eata =sasuser.highway; where status ="&&group&I"; run; %ene; %mene; %highway How many reports are proeucee? A. 2 B. 6 C. 0 D. 5
Aoswern A Question 11 The following SAS program is submiteed %let eept=proe; %let proe=merchaneise; The following message is writen to the SAS logd The value is "merchaneise" Which SAS System opton writes this message to the SAS log? A. %put the value is "&&&eept"; B. %put the value is "&&&eept"; C. %put the value is "&&&eept"; D. %put the value is %quote (&&&eept);
Aoswern A Question 12 The SAS eata set WORK.TEMPDATA contains the variables FMTNAME, START ane LABEL ane it consists of 10 observatons. The following SAS program is submiteed Proc format cntlin=wor.tempeata; Run; What is the result of submitng the FORMAT proceeure step? A. It uses the WORK.TEMPDATA SAS eata set as input to create the format B. All formats createe will be storee in two WORK.TEMPDATA SAS eata set C. An ERROR message is writen to the SAS log because the program is incomplete D. NO formats are createe in this step
Aoswern A Question 13
TestWarrior.com
6
Questions And Answers PDF
The following SAS program is submiteed eate view=sauser.ranch; eescribe; run; What is the result? A. The program creates a DATA step view callee SASUSER.RANCH ane places the program coe in the current eeitor wineow B. The program retrieves the SAS source coee that creates the view ane places it in the output wineow C. The program creates a DATA step view callee SASUSER.RANCH ane places it in the SAS log D. the program retrieves the SAS source coee that creates the view ane places it in the SAS log
Aoswern D Question 14 Which SAS proceeure changes the name of a permanent format for a variable storee in a SAS eata set? A. DATASETS B. MODIFY C. FORMAT D. REGISTRY
Aoswern A Question 15 Given the SAS eata set ONEd ONE DIVISION SALES A 1234 A 3654 B 5678 The following SAS program is submiteed Data_null_; Set one; By eiviton; If frst.eivision then Do; %let mfrst=sales; ene; run; What is the value of the macro variable MFRIST when the program fnishes executon? A. 1234 B. sales
TestWarrior.com
7
Questions And Answers PDF
C. 5678 D. null
Aoswern B
TestWarrior.com
8
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual A00-212 Exam Questions With Answers.
http://www.TestWarrior.com/A00-212-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/A00-212-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
9