A00-212

Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT absent no 0-29 serious 31 absent no 0-29 not 1419 absent no 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216 The following SAS program is submitted: %macro highway; proc sql noprint; select...

The SAS data set TEMP has the following distribution of values for variable A: A Frequency 1 500,000 2 500,000 6 7,000,000 8 3,000 Which one of the following SAS programs requires the least CPU time to be processed?A . data new; set temp; if a = 8 then b...

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 1 A 2 X 2 B 3 Y 4 D 5 V The following SAS program is submitted creating the output table THREE: data three; set one two; run; THREE NUM CHAR1 CHAR2 1 A...

Following SAS program is submitted: data temp(<insert option here>); infile 'rawdata'; input x $ y z; run; RAWDATA is a file reference to an external file that is ordered by the variable X. Which option specifies how the data in the SAS data set TEMP will be sorted?A . ORDEREDBY=XB...

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...

Given the SAS data sets ONE and TWO: The following SAS program is submitted: Data combine; Merge one two; By id; Run; Which SQL procedure program procedures the same results?A . proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;B...

Given has SAS dataset ONE: The following SAS program is submitted: Proc sql; <insert SQL clause here> from one; quit; The following output is desired: Which SQL procedure clause completes the program and generates the desired output?A . Select salary, salary*.10 var=BONUSB . Select salary, salary*.10 label='BONUS'C . Select salary,...

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?A . NODUPB . UNIQUEC . DISTINCTD . NODUPKEYView AnswerAnswer: A

Given the following SAS data set ONE: ONE GROUP SUM A 765 B 123 C 564 The following SAS program is submitted: data _null_; set one; call symput(group,sum); run; Which one of the following is the result when the program finishes execution?A . Macro variable C has a value of...

Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?A . DATASETSB . MODIFYC . FORMATD . REGISTRYView AnswerAnswer: A