Free SASInstitute A00-211 Exam Dumps Questions & Answers

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?

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

The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

• A.format salary dollar11.2;
• B.format salary dollar8.2;
• C.format salary comma11.2;
• D.format salary comma8.2 dollar8.2;

The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?

• A.id style;var style bedrooms baths price;
• B.id style;by style;var style bedrooms baths price;
• C.id style;
• D.id style;by style;var bedrooms baths price;

There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

What will be the value of NewVar when SAS writes the last observation?

• A.. (a missing value)
• B.0
• C.1
• D.451

Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

• A.proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;
• B.proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;
• C.proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;
• D.proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;