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

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` ;

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

A. CLASS

B. GROUP

C. SUMBY

D. VAR

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

What is the default sort order of PROC SORT?

A. Internal

B. Ascending

C. Formatted

D. Descending

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 data sets AMERICIAN NATIONAL and results in the data set BASEBALL shown below: AMERICAN

NATIONAL

BASEBALL

Which DATA step correctly creates the BASEBALL data set?

A. data baseball; set american (rename=(Team=TeamName)) national; run;

B. data baseball; set american national; run;

C. data baseball; set American (rename=(TeamName=Team)) national; run;

D. data baseball; set national American; run;

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 PROC PRINT report of the INVEST data set shown below:

How many observations are in the FORCAST data set after this program executes?

A. 30

B. 10

C. 0

D. 20