BA05 Base SAS Programming Assessment 1

d) The data sets listed in the first two IF statements require a library reference

Question 4:- Which one of the following SAS DATA steps saves the temporary data set named HADOOPDATA as a permanent data set?

a) libname sasdata `SAS-data-library`; data sasdathadoopdata; copy hadoopdata; run;

b) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; keep hadoopdata; run;

c) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; save hadoopdata; run;

d) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; set hadoopdata; run;

Question 5:- You have submitted the SAS DATA step as below: libname temp `SAS-data-library`; data temp.employee; set sasuser.employer; totalsal = price * 1.04; run; Which one of the following statements is true regarding the program above?

a) The program is reading from a temporary data set and writing to a temporary data set.

b) The program is reading from a temporary data set and writing to a permanent data set.

c) The program is reading from a permanent data set and writing to a temporary data set.

d) The program is reading from a permanent data set and writing to a permanent data set. _/

Question 6:- How can you limit the variables written to output dataset in DATA STEP?

DROP keep

Var

Both A or B

Question 7:- Which of the following statements are used to read delimited raw data file and create an SAS data set?

DATA and SET

DATA, SET and INFILE

DATA, SET and INPUT

DATA, INFILE and INPUT

Question 8:- Suppose, the variable “Avg” is in character format. Which of the following statement will help to convert “Avg” to numeric format?

Input(Avg, 5.2)

PUT(Avg,5.2)

INT(Avg,5.2)

Both A and C

Question 9:- Which of the following command will find the number of missing marks in all variables of table “Class”

proc means data=class N; run ; proc means data=class N NMISS ; run;

proc means data=class SUM N;run;

Both B and C

Question 10:- Which of the following command will help to impute the missing value of a column “Hindi” with average marks of “Hindi”?

Proc SQL; Create table temp as Select *, mean(Hindi) as avg_score from Class; quit; Data class; Set temp; If

Hindi=. Then Hindi_2=avg_score; Else Hindi_2=Hindi;run;

Proc SQL; Create table temp as Select *, mean(Hindi) as avg_score from Class; quit; Data class; Set class; If

Hindi=. Then Hindi_2=avg_score; Else Hindi_2=Hindi;run;

Both A and B

None of the above

Question 11:- Categorical column may contain more than two distinct values. For example, “Married” has two values, “Yes” and “No”. How will you find all the distinct values present in the column “Education”?

proc freq data=Table5;tables Education; run; proc means data=Table5;var Education; run;

Both A and B

None of the above

Question 12:- Which of the following SAS program will help you understand the relationship between two variables “Education” and “Loan_Status”?

Proc Freq data=table5;tables Education*Loan_Status; run;

Proc Freq data=table5;tables Education Loan_Status; run;

Proc Univariate data =table5;var Education Loan_Status; run;

Proc Univariate data = table5;var Education*Loan_Status; run;

Question 13:- Which of the following statement can be used to accumulate the value of the variable in a Data Step?

SET

RETAIN

UPDATE

SUM

Question 14:- How many of the following statistics that PROC MEANS computes as default statistics? Standard deviation Range Count Minimum value Variance Mode

2

3

4

None of the above

Question 15:- Can PROC MEANS analyze ONLY the numeric variables?

Yes

No

Question 16:- Import the dataset “data_1”. Suppose the variable `Unit_Cost_Price` (numeric) contains both missing and non missing values. What would the following code return? proc sort data=data_1; by Unit_Cost_Price;

A new dataset work.price list is created with Unit_Cost_Price sorted in ascending order with missing values at the bottom of the dataset

The dataset data_1 is sorted with Unit_Cost_Price sorted in descending order with missing values at the bottom of the dataset

A new dataset work.price_list is created with Unit_Cost_Price sorted in descending order with missing values at the top of the dataset

The dataset data_1 is sorted with Unit_Cost_Price sorted in ascending order with missing values at the top of

the dataset

Question 17:- How to determine if there is a significant relationship between two categorical variables?

PROC FREQ DATA = Hello;TABLE Gender*Valid_customer / NOPERCENT NOROW NOCOL

CHISQ;RUN;

PROC FREQ DATA = Hello;TABLE Gender*Valid_customer / NOPERCENT NOROW NOCOL

Ttest;RUN;

PROC FREQ DATA = Hello;TABLE Gender*Valid_customer / CHISQ;RUN;

A and C

Question 18:- To find the effects of a medicine in a before-after fashion, the following code can be used:

PROC TTEST DATA = medicine H0 = 50 sides=2 alpha=0.05;VAR med_before; Class

med_after;RUN;

PROC TTEST DATA = medicine;PAIRED med_before * med_after;RUN;

Only A

Both A and B

Question 19:- Which of the following programs contain a syntax error

a) proc sort data=sasuser.mysales;by region;run;

b) dat sasuser.mysales;set mydata.sales99;run;

c) proc print data=sasuser.mysales label;label region=`Sales Region`;run; d) none of the above.

Question 20:- Which statement will limit a PROC MEANS analysis to the variables Boarded, Transfer, and Deplane? a) by boarded transfer deplane;

b) class boarded transfer deplane;

c) output boarded transfer deplane;

d) var boarded transfer deplane;