SAS Certified Adv Programmer 50 Questions (11)
The following SAS program is submitted: %let lib=SASUSER; %let dsn=CLASS; proc sql; select name from dictionary.columns where libname=”&lib” and <insert code here> quit; Which one of the following conditions completes the WHERE clause to create a subset from the data set Dictionary.Columns about Sasuser.Class? a. table=”&dsn” b. name=”&dsn” c. member=”&dsn” d. memname=”&dsn”
SAS Certified Adv Programmer 50 Questions (10)
The following SAS program is submitted: proc sql noprint; select name into : info separated by ‘ ‘ from dictionary.columns where libname=”SASHELP” and memname=”CLASS”; quit; Given that a SAS data set Sashelp.Class exists, which one of the following is generated by the above program? a. a list of names b. a syntax error in the […]
SAS Certified Adv Programmer 50 Questions (9)
Table One has five million observations. Table Two has one thousand observations. These tables have identical column attributes. Concatenating tables One and Two should result in 5,001,000 observations. Which one of the following SAS techniques uses the least CPU time and I/O operations to process? a. the APPEND procedure b. the SET statement in the […]
SAS Certified Adv Programmer 50 Questions (8)
Given the following SAS data sets One and Two: One Num Char1 1 A 2 B 4 D Two Num Char2 2 X 3 Y 5 V The following SAS program is submitted creating the output table Three: data three; merge one (in=in1) two (in=in2); by num; if in2; run; Three Num Char1 Char2 2 […]
SAS Certified Adv Programmer 50 Questions (7)
How many columns can an SQL procedure subquery within a WHERE or HAVING clause return to the outer query? a. 0 b. 1 c. 2 d. the same number of columns that are in the table