Test Online Free SAS Institute A00-231 Exam Questions and Answers
Practice a live sample before buying full access. This page keeps the free A00-231 question set organized by page so visitors and search engines can reach the canonical -questions.html URL directly.
The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
Answer:
Question 2Selectable Answer
The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?
Answer:
Question 3Selectable Answer
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
Answer:
Question 4Selectable Answer
Which is a valid LIBNAME statement?
Answer:
Question 5Selectable Answer
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
Answer:
Question 6Selectable Answer
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS
NAME AGE
Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm ‘SAS data library’;
data students;
set perm. Students;
file ‘file specification’;
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
Answer:
Question 7Selectable Answer
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
Answer:
Question 8Selectable Answer
The following SAS program is submitted:
data one;
date = ‘04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?
Answer:
Question 9Selectable Answer
The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:
WORK.ONE
Num Char
------ ------
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num='1';
run;
What is output?
Answer:
Question 10Selectable Answer
00100.00
Total10100.00
Which option correctly completes the program and creates the report?
Answer:
Question 11Selectable Answer
The following SAS program is submitted:
The program fails execution due to syntax errors.
What is the cause of the syntax error?
Answer:
Question 12Selectable Answer
Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile ‘employee’;
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?
Answer:
Question 13Selectable Answer
What is the purpose or the MISSOVER option on the INFILE statement?
Answer:
Question 14Selectable Answer
The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?
Answer:
Question 15Selectable Answer
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?
