A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?

• A.A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
• B.A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
• C.The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
• D.The program will produce an error message indicating that the exceldata.xlsx workbook already exists.

Comment: *

Name: *

Email: *

Verification: *

Given the SAS data set PRICES:
Prodid price producttype sales returns
K125 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
data hware inter cheap;
set prices(keep = productype price);
if producttype = 'HARDWARE' then output hware; else if producttype = 'NETWORK' then output inter; if price le 5.00;
run;
if producttype = 'HARDWARE' then output hware; else if producttype = 'NETWORK' then output inter; if price le 5.00;
run;
How many observations does the HWARE data set contain?

• A.0
• B.2
• C.3
• D.4

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. dsd = ',';
  run;
• B.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification';
  put idnum sales_date : mmddyy10. dlm = ',';
  run;
• C.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification' dlm = ',';
  put idnum sales_date : mmddyy10.;
  run;
• D.libname perm 'SAS-data-library';
  data _null_;
  set perm.jan_sales;
  file 'file-specification' dsd = ',';
  put idnum sales_date : mmddyy10.;
  run;

Comment: *

Name: *

Email: *

Verification: *

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

• A.non-missing character variables and non-missing numeric variable values only
• B.missing numeric variable values and non-missing numeric variable values only
• C.non-missing numeric variable values only
• D.missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values

Comment: *

Name: *

Email: *

Verification: *

Given the contents of the raw data file TYPECOLOR.DAT:

The following SAS program is submitted:

What are the values of the variables Type and Color?

• A.Type=daisy, Color=
• B.Type=daisy, Color=w
• C.Type=daisy, Color=daisyyellow
• D.Type=daisy, Color=yellow

Comment: *

Name: *

Email: *

Verification: *