Free SASInstitute A00-231 Exam Dumps Questions & Answers

Which of the following programs correctly invokes the DATA Step Debugger?

• A.Option B
• B.Option C
• C.Option A
• D.Option D

The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?

• A.'' (missing character value)
• B.Senior Chemist
• C.chem3
• D.Unknown

The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005.
What output is produced if April 15, 2005 falls on a Friday?

• A.Obs newdate mdate ddate104/15/2005 APR 7
• B.Obsnewdate mdate ddate104/15/2005 APR 6
• C.Obs newdate mdate ddate104/15/2005 4 6
• D.Obs newdate mdate ddate104/15/2005 4 7

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?

• A.No output is generated

The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?

• A.The descending option applies to the Product and Code variables.
• B.The descending option applies only to the Date variable.
• C.The descending option applies to the Date and Cost variables.
• D.The descending option applies only to the Code variable.