The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

• A.LocalFee has format of 9. and CountryFee has a format of percent7.2
• B.LocalFee has format of 9. and CountryFee has a format of 7.
• C.The data step fails execution; there is no format for LocalFee.
• D.Both LocalFee and CountryFee have a format of percent7.2

Comment: *

Name: *

Email: *

Verification: *

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?

• A.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification';
  put idnum sales_date : mmddyy10. dlm = ',';
  run;
• B.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification';
  put idnum sales_date : mmddyy10. dsd = ',';
  run;
• C.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification' dsd = ',';
  put idnum sales_date : mmddyy10.;
  run;
• D.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification' dlm = ',';
  put idnum sales_date : mmddyy10.;
  run;

Comment: *

Name: *

Email: *

Verification: *

The following SAS DATA step is submitted:
libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?

• A.The program is reading from a temporary data set and writing to a temporary data set.
• B.The program is reading from a temporary data set and writing to a permanent data set.
• C.The program is reading from a permanent data set and writing to a temporary data set.
• D.The program is reading from a permanent data set and writing to a permanent data set.

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?

• A.The merged data sets are not permanent SAS data sets.
• B.The data sets were not merged in the order by which they were sorted.
• C.The SORT procedures contain invalid syntax.
• D.The RUN statement was omitted alter each or the SORT procedures.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true concerning the SAS automatic variable _ERROR_?

• A.It cannot be used in an if/then condition.
• B.It cannot be used in an assignment statement.
• C.It can be put into a keep statement or keep= option.
• D.It is automatically dropped.

Comment: *

Name: *

Email: *

Verification: *