Online Access Free A00-202 Practice Test

The following SAS program is submitted:
%macro execute; <insert statement here> proc print data = sasuser.houses; run; %end;
%mend;
Which of the following completes the above program so that it executes on Tuesday?

• A.%if "&sysday" = Tuesday %then %do;
• B.%if &sysday = 'Tuesday' %then %do;
• C.%if &sysday = Tuesday %then %do;
• D.%if '&sysday' = 'Tuesday' %then %do;

Given the following SAS data set ONE:
ONE DIVISION SALES
A 1234 A 3654 B 5678
The following SAS program is submitted:
data _null_; set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

• A.null
• B.1234
• C.5678
• D.3654

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 two variables and 50 observations.
• C.ERROR and WARNING messages are written to the SAS log.
• D.Data set THREE is created with three variables and 100 observations.

The following SAS program is submitted:
%let name = Patel's Restaurant;
Which one of the following statements avoids problems associated with the unbalanced quotation mark?

• A.%let name = %str(Patel's Restaurant);
• B.%let name = %str(Patel%'s Restaurant);
• C.%let name = Patel%str(')s Restaurant;
• D.%let name = Patel%'s Restaurant;

The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "&sub";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?

• A.WORK.HOUSES
• B.work.houses
• C.work.ranch
• D.WORK.RANCH