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”
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 […]