Free A00-211 sample questions

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

The following SAS program is submitted: The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. Which statement is true?

• The BY statement in the DATA step causes a syntax error.
• The statement payroll + wagerate; in the DATA step causes a syntax error.
• The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
• The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.

The following SAS program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Product Code descending Date Cost; run; Which of the following is true concerning the submitted program?

• The descending option applies only to the Date variable.
• The descending option applies to the Date and Cost variables.
• The descending option applies to the Product and Code variables.
• The descending option applies only to the Code variable.