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 following SAS program:

What footnotes appear for the second PROC PRINY report?

A. Created by HR

B. Created by HR

C. Draft - Do Not Distribute Create by HR

D. Draft - Do NOT Distribute

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;

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

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 statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

A. data sashalp.shoes; out work.total;

B. data sashelp.shoes; output work.total;

C. data work.total; set sashelp.shoes;

D. data out=work.total; input sasholp.shoes

Which PROC PRINT step correctly displays only the first 10 observations in the data set?

A. proc print data=sashelp.class(obs=l10); run;

B. proc print data=sashelp.class; obs=10; run;

C. proc print data=sashelp.class obs=10; run;

D. proc print data=sashelp.class (oba?10' ) ; run;

Which statement is true regarding a variable?

A. A character variable can contain alphabetic characters, numeric digits, and other special characters.

B. A numeric value must be specified in single or double quotes.

C. A character value cannot exceed 200 bytes.

D. A numeric variable can contain digits, decimal point, minus sign, currency symbol, and E for scientific notation.

Given the following code:

Which variables are created with the BY statement?

A. State. First and State. Last

B. First. State and Last. State

C. First_State and Last_State

D. First. and Last.

The sashelp. class data set has 19 observations. Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?

A. preteen will have 7 observations and teen will have 19 observations

B. preteen will have 7 observations and teen will have 12 observations

C. preteen will have 26 observations and teen will have 31 observations

D. preteen will have 10 observations and teen will have 9 observations