A00-215 Online Practice Questions and Answers

Which PROC IMPORT step correctly creates the MYDATA,SALES data set from the SALES.SCV file?

A. proc import data="mydata. sales" dbms=csv out="mydata.sales; nun

B. proc import datafile="sales.csv" dbms=csv out-mydata. sales;

C. proc import data=mydata.sales dbms=csv out=mydata.gales; run,

D. proc import datafile=sales.csv dbms=csv out--"mydata,sales"; 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;

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

How many statements are in the following PROC PRINT step?

A. 5

B. 3

C. 4

D. 1

Which statement is true regarding the DATA step?

A. The DATA step can only read raw data files.

B. The DATA step reads, processes and creates date

C. The DATA step can output only one data set.

D. The DATA step must be the first step in a program.

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

How does SAS display missing values?

A. a period for missing numeric and a blank for missing character

B. an N for missing numeric and C for missing character

C. a blank for Doth numeric and character missing

D. a blank for missing numeric and a $ for missing character

Which two data sets are permanent?

A. New

B. Mylib.new

C. Work.new

D. Temp.new

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;

When the following code is submitted, execution fails.

Why does the execution fail?

A. Multiple executable statements are not allowed in the DO block.

B. The OUTPUT statement is not allowed in the DO block.

C. There are two unclosed DO block.

D. The conditional logic expressions fail for the DO block

The SAS log of a submitted DATA step is shown below:

Which action resolve the error messages?

A. Remove the period after the value of Inc.

B. Enclose the value of ABC Inc . in quotation marks.

C. Add a LENGTH statement to declare the company variable as character

D. Enclose the value of ABC Inc. in parentheses.

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.