A00-215 Online Practice Questions and Answers

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

Which PROC SORT option allows you to create an output data set of the sorted data?

A. Data=

B. SORTOUT=

C. OUTPUT=

D. OUT=

Given the data set NAMES:

Which PROC SORT program creates the NAMES data set shown below?

A. proc sort data=Names; orderby Age

B. proc sort data=Names; by Age

C. proc sort data=Names; by Age Name

D. proc sort data=Names; orderby Name; run;

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

The data set Snacks contains three variables (productName, Flavor, and Price). Given the program shown below:

What is the type and length of SnackType?

A. Numeric, 8

B. Character, 7

C. Character, 8

D. Character, 5

Given the program below:

Why does the program fail?

A. You must use two different DATA statements for HEIGHT1 and HEIGHT2

B. You cannot output to different data sets

C. You must include the data set height2 in the DATA statement

D. You cannot use numbers in data set names.

Which option renames the variable Name to StudentName when reading the ClassRoster data set?

A. set ClassRoster (rename (StudentName=Name ) ) ;

B. set ClassRoster (rename (NamestudentName) ) ;

C. set ClassRoster (renaiae=(Name=studentName) ) ;

D. set ClassRoster (^name=(StudentName=Name));

Which code uses the correct syntax to conditionally create the two variables age-Cat and account?

A. if age<13 do than; age_Cat= ' Pre-teen '; ,-account='No Social Media;' and;

B. if age<13 then do; age_cat=' Pre-teen' account='No social Media' Allowed;' and;

C. if age<13 then age_Cat=;Pre-teen' account='No Social Media Allowed';

D. if aga<13 do; age_Cat-'Pre-teen'; account='No Social Media Allowed end;