A00-215 Online Practice Questions and Answers

Which step temporarily assign a format to the sales variable?

A. Proc format; Formatsales comma12.; Run;

B. Data sasuer. Shoes Set sashelp,sheoes; Format sales comma12.;

C. Proc contents data=sashelp.shoes; Format Sales comma12.; Run;

D. Proc print data= sashelp. Shoes Format sales comma12.; 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 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;

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;

How many statements are in the following PROC PRINT step?

A. 5

B. 3

C. 4

D. 1

What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

A. Syntax error

B. Logic error

C. Special error

D. Data error

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

What step has correct syntax for the CONTENTS procedure?

A. Proc contents file=sashelp .shoes; Run;

B. Proc contents lib=sashelp data=shoes; Run;

C. Proc contents data=sashelp.shoes; Run;

D. Proc contents sashelp. Shoes; run;

Given the following assignment statement:

BirthDate = 15DEC2005'd;

Which statement is true?

A. 15DEC2005 'd is a character constant

B. BirthDate is a numeric variable.

C. The byte size of BirthDate is 9.

D. The assignment statement contains a syntax error.