The following SAS program is submitted:
proc datasets lib = testdata; modify one; label num = 'Number'; format num 4.;
quit;
Which one of the following SQL programs produces the same results as the above DATASETS procedure?

• A. proc sql;
  alter table testdata.one
  modify num format = 4.
  label = 'Number';
  quit;
• B. proc sql;
  alter table testdata.one
  modify num (format = 4.
  label = 'Number');
  quit;
• C. proc sql;
  modify table testdata.one
  num format = 4.
  label = 'Number';
  quit;
• D. proc sql;
  modify table testdata.one
  alter num format = 4.
  label = 'Number';
  quit;

The variable attributes of SAS data sets ONE and TWO are shown below:
ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three; merge one two; by year;
run;
Which one of the following is the result of the program execution?

• A. No messages are written to the SAS log.
• B. Data set THREE is created with three variables and 100 observations.
• C. Data set THREE is created with two variables and 50 observations.
• D. ERROR and WARNING messages are written to the SAS log.

The following SAS program is submitted:
<insert statement here>; %let development = ontime; proc print data = sasuser.highway;
title "For &dept"; title2 "This project was completed &development"; run;
Which one of the following statements completes the above and resolves title1 to "For research&development"?

• A. %let dept = %nrstr(research&development);
• B. %let dept = %str(research%&development);
• C. %let dept = %str(research&development);
• D. %let dept = %nrstr(research%&development);

Which one of the following SAS programs uses the most amount of memory resources for output buffers?

• A. data new(bufsize = 4000 bufno = 1);
  set temp;
  run;
• B. data new(bufsize = 1000 bufno = 5);
  set temp;
  run;
• C. data new(bufsize = 1000 bufno = 2);
  set temp;
  run;
• D. data new(bufsize = 2000 bufno = 3);
  set temp;
  run;

The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

• A. any integer between 1 and 2,500,000
• B. any real number between 0 and 1
• C. any integer between 1 and 10
• D. any real number between 1 and 2,500,000