URX Pharmaceutical, Inc. conducted a clinical study. A portion of the data recorded the inclusion-exclusion criteria outcomes. These information for the 9 sites, coded as numeric (0 to 8) of various number of subjects each were recorded in inclexcl.csv. Subjects were labelled as numeric (1, 2, ...) These information are read into SAS data set ie.
A subject is included in the study if he/she meets all inclusion criteria ("Yes" in all incl1, incl2, incl3, incl4, incl5, incl6). In addition, a subject is excluded in the study if he/she does not meet one or more exclusion criteria (a "Yes" or more in excl1, excl2, excl3, excl4, excl5). In two data steps (my_ie and inclexcl_? where ? = one of 0 to 8), you are to create a final data set (example data view inclexcl_0.png) containing 4 variables:
Your WIN will set a random seed so that you will be working on a randomly selected site (from sites 1 to 8) to produce a data set. For example, if you are assigned to site 5, you will need to come up with SAS data set inclexcl_5.
You are provided a SAS Codes (FinalExam.sas) in which many coding errors occur. These errors could be
After correcting your SAS codes, comment the line
%let _site = 0;to
%*let _site = 0;and rerun your entire SAS codes to get the right data set. Name your corrected SAS codes as yourLastName_Final.sas. Clearly mark all errors in the provided SAS codes. You can place the buggy code chunks (i.e., a code chunk=a data step or a procedure step or a standalone statement) in a SAS comments and identify errors in it.