Practice Free A00-215 Exam Online Questions
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;
How many statements are in the following PROC PRINT step?
- A . 5
- B . 3
- C . 4
- D . 1
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.
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.
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;
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
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 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 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 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;