SAS Certified Adv Programmer 50 Questions (31)
Which one of the following statements is true regarding the TRANSPOSE procedure?
a. The TRANSPOSE procedure produces printed output by default.
b. The TRANSPOSE procedure rearranges all variables by default.
c. The TRANSPOSE procedure does not create an output data set by default.
d. The TRANSPOSE procedure creates one observation for each restructured variable for each BY group.
SAS Certified Adv Programmer 50 Questions (30)
When using the KEY= option in the SET statement in the DATA step, which one of the following is the purpose of the automatic variable _IORC_?
a. to determine the amount of I/O usage
b. to determine the success of the I/O operation
c. to determine the length of the master observation
d. to determine the location of the master observation
SAS Certified Adv Programmer 50 Questions (29)
Given the following SAS log:
55 %let lib = sasuser.; 56 %let dsn = class; 57 %put dsn is &dsn, and lib is &lib; dsn is class, and lib is sasuser. 58 <insert statement here> 59 %put dsn is &dsn, and lib is &lib; WARNING: Apparent symbolic reference DSN not resolved. dsn is &dsn, and lib is sasuser. |
Which one of the following was used in the code shown above to remove the macro variable dsn from the symbol table?
a. %SYMDEL dsn;
b. %REMOVE dsn;
c. %DELETE dsn;
d. %MACDEL dsn;
SAS Certified Adv Programmer 50 Questions (28)
Which one of the following statements displays all user-defined macro variables in the SAS log?
a. %put user=;
b. %put user;
c. %put _user_;
d. options mprint
SAS Certified Adv Programmer 50 Questions (27)
Given the following partial SAS log:
11 %macro a(location);
12 %if &location = FL %then
13 libname &location 'c:\state';
14 %mend;
15 %a(FL)
NOTE: SCL source line.
16 libname mylib 'c:\mydata';
-------
22
ERROR: Libname FL is not assigned.
ERROR: Error in the LIBNAME statement.
ERROR 22-7: Invalid option name LIBNAME.
|
Which of the following SAS system options can be used to display the results of resolving the macro variable reference &location?
a. MPRINT only
b. MLOGIC only
c. SYMBOLGEN only
d. MPRINT and MLOGIC