Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?
A. Ods excel=' c : \report. xlsx' style=analysis;
B. Ods excel workbook=' report. xles' analysis;
C. Ods excel=' c : \report. xlsx' / analysis;
D. Ods excel file ='c \report.xlsx' styleanalysis;
Which PROC MEANS program creates the report below?
A. proc means data-sashelp. shoes sum mean; var Sales; Class Product;
run;
B. proc means data=sashelp. 'shoes var Sale; group Product; run/
C. Pror moans data-uashelp . shoes sum mean nobe; by sales; class product
D. proc means data-esea= ashelp. shoes. sum Salad; mean Sales; by product; run."
Which PROC PRINT option displays variable labels in the report?
A. SHOWLABELS
B. COLS
C. LABELS=
D. LABEL
Given the report shown below:
Which PROC PREQ step creates the frequency report?
A. proc freq data= cars;
tables make drivetrain;
run;
B. proc freq data= cars; tables make *drivetrain; run;
C. proc freq data- cars; tables drivetrain make; run;
D. proc freq data- cars; tables drivetrain* make; run;
The following program is summited:
The following report is created:
However, the desired report is shown below:
What change is needed to display the desired formatted values for the Answer varia
A. Change the unformatted values on the VALUE statement to upper case letters
B. Remove the comma located on the VALUE statement
C. Add a period to the end of the format name on the VALUE statement.
D. Remove the dollar sign located at the front of the format name
Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below: EMPLOYERS
DONATIONS
NODONATIONS
A. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=0 and inD-0; run;
B. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; run;
C. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-0;
run;
D. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-1; run;
Which variable in the Program Data Vector represents the number of times the Data step has iterated?
A. N
B. _N_
C. _Obs_
D. Obs
Which statement is true about the SUM statement?
A. The SUM statement includes an equal sign.
B. Multiple accumulating variables can be created with one SUM statement.
C. The SUM statement ignores missing values.
D. By default, the accumulating variable is initialized to 1.
The SAS log of a submitted DATA step is shown below:
Which action resolve the error messages?
A. Remove the period after the value of Inc.
B. Enclose the value of ABC Inc . in quotation marks.
C. Add a LENGTH statement to declare the company variable as character
D. Enclose the value of ABC Inc. in parentheses.
Given the input data set WORK.RUN:
Given the following DATA step:
What is the correct output data set WORK.RUN2?
A. Option A
B. Option B
C. Option C
D. Option D
