SASInstitute A00-201 dumps - 100% Pass Guarantee!

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.

The following SAS program is submitted:

proc sort data = work.test out = work.testsorted;

by name;

run;

Which one of the following is the result of the SAS program?

A. The data set WORKTEST is stored in ascending order by values of the NAME variable.

B. The data set WORKTEST is stored in descending order by values of the NAME variable.

C. The data set WORKTESTSORTED is stored in ascending order by values of the NAME variable.

D. The data set WORKTESTSORTED is stored in descending order by values of the NAME variable.

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

Iibname sasdata `SAS-data-Iibrary';

options obs = 500;

proc print data = sasdata.prdsales (firstobs = 100); run;

options obs = max;

proc means data = sasdata.prdsales (firstobs = 500); run;

How many observations are processed by each procedure?

A. 400 for PROC PRINT 4500 for PROC MEANS

B. 401 for PROC PRINT 4501 for PROC MEANS

C. 401 for PROC PRINT 4500 for PROC MEANS

D. 500 for PROC PRINT 5000 for PROC MEANS

The following SAS DATA step is submitted:

data work.accounting; set work.department; length jobcode $ 12; run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOSCODE with a length of 5.

Which one of the following is the length of the variable JOSCODE in the output data set?

A. 5

B. 8

C. 12

D. The length can not be determined as the program fails to execute due to errors.

The following SAS program is submitted:

data work.total;

set work.salary(keep = department wagerate);

by department;

if first.department then payroll = 0;

payroll + wagerate;

if last.department;

run;

The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.

Which one of the following is true regarding the program above?

A. The BY statement in the DATA step causes a syntax error.

B. FIRST.DEPARTMENT and LAST DEPARTMENT are variables in the WORK.TOTAL data set.

C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.

Click the Exhibit button to view two reports.

Assume permanent variable labels have been assigned. The following SAS program is submitted and produces the first report:

proc report data = sasuser.shoes nowd; column region subsidiary sales; define subsidiary / display; define region / group; define sales / sum;

Which one of the following corrects the program above to produce the second report shown in the exhibit?

A. Define the variable SUBSIDIARY with a SUM usage.

B. Define the variable SUBSIDIARY with a GROUP usage.

C. Define the variable SUBSIDIARY with an ORDER usage.

D. Define the variable SUBSIDIARY with an ACROSS usage.