A00-212

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

Given the non-indexed SAS data set TEMP: TEMP X Y P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp; <insert By statement here? Run; Which by statement completes the program, create a listing report that is...

The following SAS program is submitted: proc contents data = testdata.one; run; Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE? A. proc sql; Contents table testdata.one; Quit; B. proc sql; Describe table testdata.one; Quit; C. proc sql; describe testdata.one; Quit; D. proc sql;...

The following SAS program is submitted: %micro cols1; name age; %mend; %macro cols2; height weight %mend proc print data=sashelp.class; <insert VAR statement here> Run Which VAR statement successfully completes the program and produces a report?A . var heigh %cols1;B . var %cols1 %cols2 height;C . var %cols1 height;D . var...

Given the SAS date sets CLASS1 and CLASS2 CLASS1 CLASS2 NAME COURSE NAME COURSE Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2 Chang MATH3 Hiller MATH2 The following SAS program is submitted: Proc sql; Select name from CLASS1 <insert SQL set operator here> select name from...

Given the non-indexed SAS data set TEMP: TEMP X Y - - P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp; <insert BY statement here> run; Which BY statement completes the program, creates a listing report...

Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?A . MODIFY and CHANGE statementsB . RENAME statement onlyC . CHANGE statement onlyD . MODIFY and RENAME statementsView AnswerAnswer: C

The following SAS program is submitted: data one; do i = 1 to 10; ptobs = ceil(ranuni(0) * totobs); set temp point = ptobs nobs = totobs; output; end; stop; run; The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?A...

The following SAS program is submitted: %let value = 9; %let value2 = 5; %let newval = %eval(&value / &value2); Which one of the following is the resulting value of the macro variable NEWVAL?A . 1B . 2C . 1.8D . nullView AnswerAnswer: A

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?A . data two; set three; set...