A00-215 Online Practice Questions and Answers

Which statement is true regarding the XLSX engine in the LIBNAME statement?

A. The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.

B. The XLSX engine can road and write data in Microsoft Excel workbooks.

C. The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions

D. The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement

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 LABEL statement has correct syncytax?

A. Label1 FName=' First Name' ; LName =; Last Name` ;

B. Label1 FName=' First Name' LName =' Last Name` ;

C. Label1 FName=' First Name' and LName =' Last Name` ;

D. Label1 FName=' First Name' , LName =; Last Name` ;

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

Given the input data set INVENTORY as shown below:

Two output data sets are desired, CHIPS and OTHERSNACKS.

*

The CHIPS data set should only include QtySold, Price, and Product.

*

The OTHERSNACKS data set should include QtySold, Price, product, and Type. Which Data step creates the two desired output data sets

A.

data chips othersnacks; set: inventory; if Type="chips" then do; keep QtySold Price Product; output chips; end; else output othersnacks; run;

B.

data chips ( keep=QtySold Price Product) othersnacks; set inventory; if Type="chipa" then output chips; else output otharsnacks; run;

C.

data chips otharsnacks; set inventory; if Type="chips" then output chips else output otharsnacks; keep QtySold Price Product; run;

D.

data chips othersnack" set inventory (keep=QtySold Price Product); if Typo~"chips" then output chips; else output othersnacks; run;

Given the PATIENT and VISIT data sets and the DATA step shown below: PATIENT

VISIT

How many observations are created in the ALLVISITS data set?

A. 5

B. 12

C. 7

D. 0

Given the SAS data set WORK PRODUCTS:

The following SAS program is submitted:

How many variables does the WORK REVENUE data set contains?

A. 4

B. 5

C. 2

D. 3

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 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 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.