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

  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;                       

hihi

Download Sample Now

Earn back money you have spent on downloaded sample



Upload Document Document Unser Evaluion Get Money Into Your Wallet



Cite This work.

To export a reference to this article please select a referencing stye below.

Assignment Hippo (2021) . Retrive from http://www.assignmenthippo.com/sample-assignment/ba05-base-sas-programming-assessment-1

"." Assignment Hippo ,2021, http://www.assignmenthippo.com/sample-assignment/ba05-base-sas-programming-assessment-1

Assignment Hippo (2021) . Available from: http://www.assignmenthippo.com/sample-assignment/ba05-base-sas-programming-assessment-1

[Accessed 11/04/2021].

Assignment Hippo . ''(Assignment Hippo,2021) http://www.assignmenthippo.com/sample-assignment/ba05-base-sas-programming-assessment-1 accessed 11/04/2021.


Want latest solution of this assignment

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.


+ Submit Your Assignment Here

Captcha Image

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo

FREE SAMPLE FILE

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help