SAS Certified Adv Programmer 50 Questions (16)
Given the following SAS data set Mylib.Mydata: Mylib.Mydata Name Animal Age Max Cat 9 Brown Dog 22 Large Pig 1 The following SAS program is submitted: data _null_; set mylib.mydata; call symput(‘animal’ || left(_n_), name); run; %let i=2; title “The value is &&animal&i”; Which one of the following does the TITLE statement resolve to? a. […]
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.