The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

• A.Senior Pilot
• B.Unknown
• C.' ' (missing character value)
• D.SENIOR PILOT

Comment: *

Name: *

Email: *

Verification: *

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?

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

Comment: *

Name: *

Email: *

Verification: *

Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS NAME AGE --------------- Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm 'SAS data library'; data students; set perm.students;
file 'file specification';
put name $15. @5 age 2.;
run;
What is written to the output raw data file?

• A.----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
• B.----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
• C.----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
• D.----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:

What is produced as output?

• A.A file named test.cvs that can only be opened by SAS.
• B.A text file named test.cvs that can only be opened in a text editor.
• C.A file named test.cvs that can only be opened in Excel.
• D.A text file named test.cvs that can be opened in Excel or in any text editor.

Comment: *

Name: *

Email: *

Verification: *

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 data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;
  by Lname and Fname;
  run;
• B.proc sort data=SASUSER.EMPLOYEES out=EMPSORT;
  by Lname Fname;
  run;
• C.proc sort out=EMPLOYEES data=EMPSORT;
  by Lname and Fname;
  run;
• D.proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;
  by Lname Fname;
  run;

Comment: *

Name: *

Email: *

Verification: *