Online Access Free A00-201 Exam Questions

The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?

• A.WORK
• B.SASUSER
• C.HOUSES
• D.REPORT

The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1; end;
run;
Which one of the following is the value of the variable N in the output data set?

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

The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?

• A.2000
• B.' ' (missing character value)
• C.'2000'
• D.. (missing numeric value)

CORRECT TEXT
The SAS data set QTR1_REVENUE is listed below:

The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue;
run;
Which one of the following represents the first observation in the output data set?

The following SAS program is submitted:
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?

• A.FA 1
• B.' ' (missing character value)
• C.FA
• D.FA1