BA05 Base SAS Programming Assessment 1

WARNING - Clicking on the "SUBMIT ASSIGNMENT" button will submit the

Assignment. Be sure that you have reviewed your answers before clicking it.

Subject Code: BA05

Subject Name: BASE SAS PROGRAMMING

Component name:

ASSIGNMENT1

Question 1:- We have submitted the following PROC SORT step, which generates an output data set: Proc Sort data = AV.employee out= employee; By Designation; Run; In which library is the output data set stored? a) Work

b) AV

c) SASHELP

d) SASUSER

Question 2:- The following SAS program is submitted: data test; set Sasuser.Employees; if years_service ge 2 and years_service le 10 then amount = 1000; else if years_service gt 10 then amount = 2000; else amount = 0; amount_per_year = years_service / amount; run; Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year? a) 0

b) 1000

c) 2000

d) missing numeric value

Question 3:- The following SAS DATA step is submitted: data sasdata.allahabad sasdata.bhilai work.portblair work.pune; set company.prdsales; if region = `NE` then output bhilai; else if region = `SE` then output Allahabad; else if region = `SW` then output pune; else if region = `NW` then output portblair; run; Which one of the following is true regarding the output data sets?

a) No library references are required

b) The data sets listed on all the IF statements require a library reference

c) The data sets listed in the last two IF statements require a library reference

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

None of the above

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

Yes

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;

hihi

Want to order fresh copy of the Sample Template Answers? online or do you need the old solutions for Sample Template, contact our customer support or talk to us to get the answers of it.

Not the Exact Question you were looking for? Post your question for instant answers.