Online Access Free A00-202 Practice Test

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

• A.NODUPKEY
• B.DISTINCT
• C.NODUP
• D.UNIQUE

The following SAS program is submitted:
options yearcutoff = 1950;
%macro y2kopt(date);
%if &date >= 14610 %then %do;
options yearcutoff = 2000;
%end;
%else %do;
options yearcutoff = 1900;
%end; %mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
%y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

• A.1950
• B.2000
• C.1900
• D.1920

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

Given the following SAS data set ONE:
ONE CATEGORY AGE SALARY BONUS
M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50
The following SQL program is submitted:
proc sql; create table two as select distinct age from one where age < 33;
quit;
How many rows are written to the SAS data set TWO?

• A.4
• B.6
• C.5
• D.3

The following SAS program is submitted: %let lib = %upcase(sasuser);
proc sql; select nvar from dictionary.tables where libname = "&lib";
quit;
Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

• A.no result set
• B.a report showing the names of each table in SASUSER
• C.a syntax error in the log
• D.a report showing the number of columns in each table in SASUSER