Question: How would I do this or rather what sas code would I type in to get the answers? STAT 511 SAS Programming 1 I 1.

How would I do this or rather what sas code would I type in to get the answers? How would I do this or rather what sas code would I

STAT 511 SAS Programming 1 I 1. You are given the following two data sets: MASTER and TRANS "Master IDRIX Iwi Sw3434 22222 Sw3333 Suboth mTrans ID SOLD 1 323 2 343 3 23 6 55 (a) Write a SAS program to stack MASTER and TRANS vertically and output it to a new data set STACK (b) Merge MASTER and TRANS horizontally by ID and save it into a new data set MERGE1. (Hint: PROC SORT two data sets first) (c) Merge MASTER and TRANS horizontally by ID, drop observations whose DD's belong to and only belong to TRANS, and save it to a new data set MERGE2. (Hint: use IN=options) (d) Merge MASTER and TRANS horizontally by ID and keep observations whose ID's belong to both MASTER and TRANS. Update the new QTY, which is equal to QTY- SOLD. Save the data to a new data set MERGE3. 2. Use the Merging examples, to COMPLETE the t-test on the CPT) data, examining for differences in QOLI and GAF across TX. STAT 511 SAS Programming 1 I 1. You are given the following two data sets: MASTER and TRANS "Master IDRIX Iwi Sw3434 22222 Sw3333 Suboth mTrans ID SOLD 1 323 2 343 3 23 6 55 (a) Write a SAS program to stack MASTER and TRANS vertically and output it to a new data set STACK (b) Merge MASTER and TRANS horizontally by ID and save it into a new data set MERGE1. (Hint: PROC SORT two data sets first) (c) Merge MASTER and TRANS horizontally by ID, drop observations whose DD's belong to and only belong to TRANS, and save it to a new data set MERGE2. (Hint: use IN=options) (d) Merge MASTER and TRANS horizontally by ID and keep observations whose ID's belong to both MASTER and TRANS. Update the new QTY, which is equal to QTY- SOLD. Save the data to a new data set MERGE3. 2. Use the Merging examples, to COMPLETE the t-test on the CPT) data, examining for differences in QOLI and GAF across TX

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!