Question 1
The following SAS program is submitted and reads 100 records from a raw data file:
Which one of the following IF statements writes the last observation to the output data set?

Answer and explanation
Correct answer: D
D
20 free sample questions270 in the full practice test
The following SAS program is submitted and reads 100 records from a raw data file:
Which one of the following IF statements writes the last observation to the output data set?

Correct answer: D
D
The following SAS program is submitted:
The SAS data set WORK.SALESJNFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.
How many of the original twelve observations in WORK.SALESJNFO are written to the WORK.REPORT data set?

Correct answer: C
C
The following SAS program is submitted:
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

Correct answer: D
D
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?

Correct answer: C
C
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:
Which statement is true?

Correct answer: C
C
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
Enter your numeric answer in the space below.

Correct answer: A
A
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?

Correct answer: B
B
The contents of the SAS data set PERM.JAN_SALES are listed below:
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

Correct answer: B
B
Which one of the following SAS system options prevents the page number from appearing on a report?
Correct answer: C
C
Which SAS program correctly combines the data?
Given the SAS data set WORK.P2000:
and the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?

Correct answer: C
C
Register free to unlock 10 more sample questions