Question

Problem 1 The following data are from a research project on the effectiveness of a drug in reducing LDL cholesterol levels. While some patients in the study are assigned to the drug, others were given a placebo. Because the information about who is receiving the actual drug is kept confidential from those taking LDL measurements, that information is kept in a separate data set. Given below in Data Set A are the initial LDL cholesterol level of each individual before receiving the drug or the placebo and the LDL reading 3 months after being placed on the drug/placebo. The patients are identified by a three digit code. After the patient code the LDL level of the patient is given, followed by a code that identifies if the LDL reading is the pre- drug/placebo reading (PRE) at zero months or the reading taken 3 months later (POST). Please note that two of the patients did not show up for the post drug/placebo testing. DATA SETA 101 130 PRE 101 125 POST 102 180 PRE 102 120 POST 103 165 PRE 103 115 POST 104 145 PRE 104 150 POST 105 190 PRE 105 180 POST 106 125 PRE 106 70 POST 107 155 PRE 107 145 POST 108 175 PRE 108 110 POST 109 145 PRE 109 90 POST 110 120 PRE 110 125 POST 111 155 PRE 112 165 PRE Below you will find the information giving whether the patient receive the drug (D) or the Placebo (P) DATA SET B 101 P 102 D 103 D 104 P 105 P 106 D 107 P 108 D 109 D 110 P 112 D Your homework Proble that does all of the following and e-mail that program as an attachment to your instructor with your name included in a title is to write a single SAS progranm (a) Create a SAS data set that contains the data in the Set A and another SAS data set that contains the information in Set B Make sure you do not modify or reformat the Data Sets A and B and make sure you read the data in stream (i.e. data follows the DATALINES statement). Include SAS commands to print out these two data sets (b) Using only the SAS data sets you created in Part (a), create a data set that contains individual ID, before and after LDL levels, percentage reduction in the LDL level, and the whether or not each individual belongs to the Drug group or the Placebo group Include SAS commands to print out this data set. No variables other than ID, Drug/placebo status, LDL level at zero months (PRE level), LDL level at 3 months (POST level), and Percentage Reduction should be included in the data set. (c) Using only the data set you created in Part (b), create a data set that contains data for only those who were given the drug. It should have the ID, the pre-drug LDL level, the post-drug LDL level the and the percentage of LDL reduction. Include SAS commands to print out this data set (d) Using the Means procedure in SAS, compute the mean percentage of LDL reduction for each of the drug and the placebo groups.

Answer 1

Open fst ob,et fie while Cmohe object files) while (mahe machoe Code) of cade heam fyom object file memohy Pointe lob o exten-wy.te (oryole A 26 Section- hardle d b o Selection. teut Pysh duwond -) Call -wn、te Gngole A@ZO