BA05 Base SAS Programming Assessment 2

Question 1:- Which of the clauses below correctly sorts rows by the values of the columns Price and SqFeet ? a) order price, sqfeet

b) order by price, sqfeet

c) sort by price sqfeet

d) sort price sqfeet

Question 2:- In SAS date is ___ variable:

a) numeric

b) string

c) both numeric and string

d) none of the above

Question 3:- Which of the following is the pre-requisite of merge

a) sorted data

b) sorted data by ID variable

c) data with no missing values

d) none of the above

Question 4:- Find out the wrong statement in the syntax:

a) data class01.class2;

b) set class01.class;

c) where name = Alfred;

d) run;

Question 5:- The data set Survey, Health includes the following variables. Which is a poor candidate for PROC MEANS analysis?

a) IDnum

b) Age

c) Height

d) Weight

Question 6:- noobs` option is consistent with:

a) proc sql

b) proc ttest

c) proc univariate

d) proc print

/

Question 14:- Which procedure can be used to view the permanent labels and formats stored in a data set? a) PROC PRINT

b) PROC FORMAT

c) PROC CONTENTS

d) PROC UNIVARIATE

Question 15:- Which DATA step ensures that all observations are assigned a non-missing value for Bonus

a) data work.bonus;set orion.sales;if Country=`US` then Bonus=500;else if Country=`AU` thenBonus=300;run:

b) data work.bonus;set orion.sales;if Country=`US` then Bonus=500;else Bonus=300;run:

Question 16:- Which of the following programs concatenates the data sets sales and products, in that order a) date newsales;set products sales;run;

b) date newsales;set sales products;run;

c) date newsales;set sales;set products;run;

Question 17:- If you run this DATA step, what observations does the dataset bonuses contain? data bonuses; merge managers (in=M) staff (in=S); by EmpID; if M=0 and S=1; run;

a) Only the observations from staff that have no match in managers.

b) Only the observations from managers that have no match in staff

c) All observations from both managers and staff, whether or not they match d) No observations

Question 18:- Which of the following is a valid name for a character format? a) Country

b) $ctry

c) @country

d) _country

Question 19:- You have executed following SAS DATA step as on Monday, April 01, 2000. data joiners; set joinee; join_date = today(); run;

a) This will be a character string with the value `04/01/2000`

b) This will be a character string with the value `Monday, April 01, 2000`

c) This will be a numeric value 14701, representing the SAS date for April 01, 2000

d) This will be a numeric value 04252000, representing the SAS date for April 01, 2000

Question 20:- The following SAS program is submitted: data test; infile `file specification`; input name $ amount@@; run; Which of the following is true?

a) Two @@ together are the same as one c

b) Two @@ hold the data records until the bottom of the DATA step.

c) Two @@ hold the raw data record across iterations of the DATA step.

d) Two @@ are invalid syntax and will cause the program to fail to execute.