A00-215 Practice Exam Questions and Answers

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;

A.  

New

B.  

Mylib.new

C.  

Work.new

D.  

Temp.new

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

A.  

SHOWLABELS

B.  

COLS

C.  

LABELS=

D.  

LABEL

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;

A.  

proc means data=sashelp.class nodec;

class Age; run;

B.  

proc means data=sashelp. class;

group Age;

run;

C.  

proc means data=sashelp. class;

by Age;

run;

D.  

proc means data=sashelp. class maxdec=0;

var Age;

run;

A.  

Internal

B.  

Ascending

C.  

Formatted

D.  

Descending

A.  

set ClassRoster (rename (StudentName=Name ) ) ;

B set ClassRoster (rename (NamestudentName) ) ;

B.  

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

C.  

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

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;