Free A00-211 sample questions

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?

• if end = 0;
• if eof =0;
• if end = 1;
• if eof = 1;

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?

• 2
• 3
• 6
• 9

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

• 6
• 7
• 17
• 25

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

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

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?

• The by statement in the DATA step causes a syntax error.
• The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
• The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
• The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

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.

• 2

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?

• 1
• 2
• 3
• 5

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?

Which one of the following SAS system options prevents the page number from appearing on a report?

• NONUM
• NOPAGE
• NONUMBER
• NOPAGENUM

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?

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