1.
The following SAS program is submitted:
What new variables are created?
2.
Given the raw data record in the file phone.txt:
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
3.
The following SAS program is submitted:
data WORK.ONE;
Text='Australia, US, Denmark';
Pos=find(Text,'US','i',5);
run;
What value will SAS assign to Pos?
4.
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
5.
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?
6.
The following output is created by the FREQUENCY procedure:
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;
7.
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
8.
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
9.
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
10.
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH

The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?