A00-211 Exam Dumps - SAS Base Programming for SAS (r) 9

Which one of the following SAS statements renames two variables?

The following SAS program is submitted:

data work.test;

Author = 'Agatha Christie';

First = substr(scan(author,1,' ,'),1,1);

run;

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

The contents of the raw data file EMPLOYEE are listed below:

--------10-------20-------30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted:

data test;

infile 'employee';

input employee_name $ 1-4;

if employee_name = 'Sue' then input age 7-8;

else input idnum 10-11;

run;

Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?

The following SAS program is submitted:

If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

The contents of the SAS data set PERM.JAN_SALES are listed below:

VARIABLE NAME TYPE

idnum character variable

sales_date numeric date value

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?

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?

Which is a valid LIBNAME statement?

The value 110700 is stored in a numeric variable named SALARY.

Which FORMAT statement displays the value as $110,700.00 in a report?