SAS Certified Adv Programmer 50 Questions (15)
A batch (non -interactive) job is submitted on Wednesday, 20 January 1999 (SAS date 14264). The program completes the following day. The following code is the last step in the SAS program: data _null_; call symput(‘mdate’, input(“&sysdate”, date7.)); run; Which of the following is the value of the macro variable mdate? a. 14264 b. 14265 […]
SAS Certified Adv Programmer 50 Questions (14)
Which one of the following SAS programs removes the index Jobcode from the table Staff? a. proc sql; drop index jobcode from work.staff; quit; b. proc sql; delete index jobcode from work.staff; quit; c. proc sql; drop index from work.staff; quit; d. proc sql; delete index from work.staff; quit;
SAS Certified Adv Programmer 50 Questions (13)
The following SAS program is submitted: proc sql noprint; select name into : name1 -: name19 from one; quit; Given that table One has 19 observations and 5 variables, how many macro variables are created by the above program? a. 5 b. 6 c. 19 d. 20
SAS Certified Adv Programmer 50 Questions (12)
Which one of the following statements is true about an SQL procedure view? a. It stores large amounts of data. b. It updates data from multiple database tables. c. It contains both the data and the descriptor portions. d. It accesses the most current data in changing tables.
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”