A00-215 Online Practice Questions and Answers

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;

Given the partial shown below:

Which step will produce this report?

A. proc freq data=sashelp. shoes data=sashelp.shoes; region product / list run;

B. proc freq data=sashelp.shoes; tables region*producc / cross run;

C. proc freq data= sashelp, shoes order=freq; table region product / crosalist run;

D. proc freq data=sashelp. shoes order=freq; tables region*product / list; run;

Which PROC PRINT option displays variable labels in the report?

A. SHOWLABELS

B. COLS

C. LABELS=

D. LABEL

Given the display of the CITIES data set:

Which program creates the PROC PRINT report below?

A. proc print data=cities showlabelse; label Name= ' Employee Name City =Birth City

B. proc print data-cities label noobs; label Name='Employee Name' City=' Birth City' ; run;

C. proc print data=cities ; Name=' Employee Name' ; City='Birth City'; run;

D. options noobs labels; proc print data=cities; display Name=' Employee Name* city='Birth City', run;

Which PROC MEANS statements specifies variables to group the data before calculating statistics?

A. CLASS

B. GROUP

C. SUMBY

D. VAR

Which PROC SORT option allows you to create an output data set of the sorted data?

A. Data=

B. SORTOUT=

C. OUTPUT=

D. OUT=

Given the input data set WORK. GR_ANS with two character variables:

The following SAS program is submitted:

Which report is created?

A. Option A

B. Option B

C. Option C

D. Option D

You submit a program and the SAS log is shown below: Which statement is true regarding the submitted program?

A. The error in the PROC SORT step caused the program to stop processing

B. All three steps ran successfully

C. The DATA step and PROC PRINT steps ran without errors.

D. The PROC SORT and PROC PRINT steps failed.

Which statement is true when creating two SAS data sets with a DATA step?

A. Name both data sets in the DATA statement

B. Use an OUT= option in the WHERE statement to output the observations to the appropriate data sets.

C. Use a PUT statement to output the observations to the appropriate data sets.

D. Use a separate SET statement for each data set.

Which statement is true regarding variable names?

A. Variable names are case sensitive.

B. Variable names are from 1 to 32 characters in length.

C. Variable names are optional when you create a data set

D. Variable names can start with a number or an underscore

Which two data sets are permanent?

A. New

B. Mylib.new

C. Work.new

D. Temp.new

Which iterative DO statement is invalid?

A. Do 100 to 1200 by 100;

B. Do num = 1.1 to 1.9 by 0.1;

C. Do year = 2000 to 2016 by 2;

D. Do reverse = 10 to 1 by -1;

Which code uses the correct syntax to conditionally create the two variables age-Cat and account?

A. if age<13 do than; age_Cat= ' Pre-teen '; ,-account='No Social Media;' and;

B. if age<13 then do; age_cat=' Pre-teen' account='No social Media' Allowed;' and;

C. if age<13 then age_Cat=;Pre-teen' account='No Social Media Allowed';

D. if aga<13 do; age_Cat-'Pre-teen'; account='No Social Media Allowed end;

Given the program shown below:

Given the partial PROC PRINT report below:

Why are the labels for msbp, MPG_city, and MPG_Highway NOT displaying in the PROC PRINT report^

A. You must use the LABEL option on the PROC PRINT statement

B. You must put the LABEL statement in the PROC PRINT step

C. You must put the LABEL statement after the KEEP statement In the DATA stop

D. You must use a single LABEL statement for each variable.

Given the code shown below:

What will be the format for MSRP in the RPOC PRINT output?

A. There is a syntax error in the FORMAT statement in the PROC PRINT step.

B. Comma12. 2

C. Dollar10.

D. Dollar12.