1.A.Run this code and describe the structure  in not more than 3 sentences.  1.B

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

1.A.Run this code and describe the structure  in not more than 3 sentences. 

1.B.How would you determine whether  CAT_Score and  Starting Salary are associated? Write the code. [2+3=5]

 

2. Write a flexible code which count and displays the number and the percent of complete cases  (no missing values)  for the numerical variables in the dataset created in question 1.

Hint ( You may either Use  a DATA _NULL_ step or you may use proc MI )

 

3. Write a  macro (%select) which will  sort and print the  students  data, using two parameters to create two macro variables named &GENDER  and &SORTVAR such that if one invokes it  as %select (category=M, Sortvar= start_Sal) the following output is generated

 

 

Consider the following codes

data student;

input Student_id $13. Gender $ M_10 M_12 M_15 CAT_Score START_SAL ;

cards;

17FMUHH010001 M 85 83 69 85 12.7

17FMUHH010002 M 85 93 79 .  10.9

17FMUHH010003 M 81 82 85 91 11.1

17FMUHH010004 F .  89 89 75 07.8

17FMUHH010005 M 98 94 85 89 16.5

17FMUHH010006 M 86 81 77 95 15.1

17FMUHH010007 M 85 83 79 85 12.3

17FMUHH010008 M 80 .  75 90 09.4

17FMUHH010009 F 89 88 79 91 17.6

17FMUHH010010 M 86 83 67 95 19.2

17FMUHH010011 M 81 83 79 85 10.4

17FMUHH010012 M 75 93 69 88 11.9

17FMUHH010013 F 85 .  79 79 11.3

17FMUHH010014 F 79 83 69 85 12.5

17FMUHH010015 M 85 83 70 87 13.5

17FMUHH010016 M 81 87 .  85 18.4

17FMUHH010017 M 85 83 69 85 10.9

17FMUHH010018 F 85 83 69 85 14.9

;

run;

 

DATA student; Set student;

LABEL M_10='Marks in 10th Std exam' M_12='Marks in 12th Std exam' M_15='Marks in Graduation'

CAT_Score = 'CAT SCORE (percentile)' START_SAL='Starting Salary per Year (in Lakhs)';

run;         

Proc print data=student; run;

 

1.A.Run this code and describe the structure  in not more than 3 sentences. 

1.B.How would you determine whether  CAT_Score and  Starting Salary are associated? Write the code. [2+3=5]

 

2. Write a flexible code which count and displays the number and the percent of complete cases  (no missing values)  for the numerical variables in the dataset created in question 1.

Hint ( You may either Use  a DATA _NULL_ step or you may use proc MI )

 

3. Write a  macro (%select) which will  sort and print the  students  data, using two parameters to create two macro variables named &GENDER  and &SORTVAR such that if one invokes it  as %select (category=M, Sortvar= start_Sal) the following output is generated:

 

Attachments:

Expert's Answer

1000 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme