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.
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
Get step-by-step solutions from verified subject matter experts
