Question No : 1
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?

• A.2 temporary and 1 permanent SAS data sets are created
• B.3 temporary and 2 permanent SAS data sets are created
• C.2 temporary and 2 permanent SAS data sets are created
• D.there is an error and no new data sets are created

Show Answers

Answer:

Question No : 2
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?

• A.The SORT procedures contain invalid syntax.
• B.The merged data sets are not permanent SAS data sets.
• C.The RUN statement was omitted alter each or the SORT procedures.
• D.The data sets were not merged in the order by which they were sorted.

Show Answers

Answer:

Question No : 3
Which statement describes a characteristic of the SAS automatic variable _ERROR_?

• A.The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
• B.The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
• C.The _ERROR_ variable can be used in expressions in the DATA step.
• D.The _ERROR_ variable contains the number of the observation that caused the data error.

Show Answers

Answer:

Question No : 4
Which is a valid LIBNAME statement?

• A.libname "_SAS_data_library_location_";
• B.sasdata libname "_SAS_data_library_location_";
• C.libname sasdata "_SAS_data_library_location_";
• D.libname sasdata sas "_SAS_data_library_location_";

Show Answers

Answer:

Question No : 5
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?

• A.ods html = ‘sales.html’; ods html close;
• B.ods file = ‘sales.html’; ods file close;
• C.ods file html = ‘sales.html’; ods file close;
• D.ods html file = ‘sales.html’; ods html close;

Show Answers

Answer:

Question No : 6
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?

• A.----I----10---I----20---I---- 30 Alfred 14 Alice 13 Barbara 13 Carol 14
• B.---- I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
• C.----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
• D.----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14

Show Answers

Answer:

Question No : 7
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?

• A.The program executes successfully and a temporary SAS data set is created.
• B.The program executes successfully and a permanent SAS data set is created.
• C.The program fails execution because the same SAS data set is referenced for both read and write operations.
• D.The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

Show Answers

Answer:

Question No : 8
The following SAS program is submitted:
data one;
date = ‘04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?

• A.Obs date 1 Monday, July 4, 2005
• B.Obs date 1 July4, 2005
• C.Obs date 1 04Jul2005
• D.Obs date 1 Monday, 07/04/2005

Show Answers

Answer:

Question No : 9
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?

• A.Num Char--- ---- 1 23
• B.Num Char--- ---- 1 231 77
• C.Num Char--- ---- 1 233 231 77
• D.No output is generated.

Show Answers

Answer:

Question No : 10
00100.00
Total10100.00
Which option correctly completes the program and creates the report?

• A.LIST
• B.NOCOLS
• C.CROSSLIST
• D.NOCROSSTAB

Show Answers

Answer: