The following SAS program is submitted let libupcasesauser proc sql A00 212

The following sas program is submitted let

This preview shows page 9 - 13 out of 73 pages.

QUESTION 21 The following SAS program is submitted: %let lib=%upcase(sauser); proc sql;
Image of page 9
A00-212Actualtests.com - The Power of Knowingselect nvar form dictionary.tables where libname='&lib"; quit; Several SAS data sets exist in the SAUSER library. What is generated as output? A. A report showing the names of the columns in each table in SASUSER B. A report showing the number of columns in each table in SASUSER C. A report showing the numeric columns in each table in SASUSER D. A report showing the number of numeric columns in each table in SASUSER Answer: B QUESTION 22 The following SAS program is submitted: %macro loop; data one; %do I=1 %to 3; var&I=&I;% end run; %mend; %loop After this program executes; the following is written to the SAS log: (LOOP): Beginning execution (LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1 (LOOP): %DO loop index variable l is now 2; loop will iterate again (LOOP): %DO loop index variable l is no 3; loop will iterate again (LOOP): %DO loop index variable l is no 4; loop will iterate again (LOOP): Ending execution Which SAS system option displays the notes in the SAS log? QUESTION 23 Given the SAS data sets ONE and TWO:
Image of page 10
A00-212 Actualtests.com - The Power of Knowing 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. proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit C. proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit D. proc sql; Create table combine as Select coalesce (one id, two id) as id, Name,salary from one full join two on one.id=two.id; Quit; QUESTION 24 The following SAS program is submitted: %let first=yourname; %lest last=first %put &&last; What is written to the SAS log? QUESTION 25 The following SAS program is submitted: proc contents data = testdata.one;
Image of page 11
A00-212Actualtests.com - The Power of Knowingrun; 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; Contents testdata.one; Quit; Answer: B
Image of page 12
Image of page 13

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture