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 WORK.TESTSORTED is stored in descending order by values of the NAME variable.
• B.The data set WORK.TEST is stored in descending order by values of the NAME variable.
• C.The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
• D.The data set WORK.TEST is stored in ascending order by values of the NAME variable.

Comment: *

Name: *

Email: *

Verification: *

This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:

The following program is submitted:

Which statement should be inserted to produce the following output?

• A.Qtr1 = sum(of month {3});
• B.Qtr1 = month{1} + month{2} + month {3};
• C.Qtr1 = sum(of month {*});
• D.Qtr1 = sum(of month{_ALL_});

Comment: *

Name: *

Email: *

Verification: *

Scenario:
This project will use data set cert.input27. At any time, you may
save your program as program27 in cert\programs. You will use
this program in the next project.
Write a SAS program that will:
* Create output data set results.output27a as a subset
of cert.input27 where the country variable's value is
"US" (any variation of case, such as US or us).
* Sort results.output27a:
" first by the variable state in ascending order
" then by Postal_Code in descending order
" and finally by employee_ID in ascending order.
Run the program and use the results to answer the question below.
What is the value of Employee_ID for observation 100 in results.output27a?

Comment: *

Name: *

Email: *

Verification: *

The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification:

Which statement below was modified or added to generate the results above:

• A.proc means data=SASHELP.CLASS maxdec=1 ;
• B.proc means data=SASHELP.CLASS min max mean maxdec=1;
• C.var Height / nobs min max mean maxdec=1;
• D.output nobs min max mean maxdec=1;

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?

• A.the character value "01011960"
• B.a missing value due to syntax errors
• C.the step will not compile because of the character argument in the mdy function.
• D.the numeric value 0

Comment: *

Name: *

Email: *

Verification: *