• Using the data sets Demodemo.sas 7bdat and Visitdemo.sas 7bdat, we want to make a cohort of patients whose minimum CD4 measurement within 90 days prior to ARV start and 14 days post is below 150 and compare the proportion of deceased men to women in this cohort.
• Inputs: Visitdemo.sas7bdat - patient identifier (patient_ id), CD4 measurements (CD4), visit date (apptdate) Demogdemo.sas7bdat - patient identifier (patient _id), sex (male), deceased (death), date of ARV start (arvstart)
• Outputs: a. SAS dataset containing cohort of patients whose minimum CD4 measurement within 90 days prior to ARV start and 14 days post is below 150. Include the following variables: patient _id, death, sex, and minimum CD4.

b. proportion of deceased women and deceased men in cohort - number and percent via report (html)

• Assumptions: o Window of observation for looking for minimum CD4 is 90 days prior or 14 days post ARV start (i.e. between 90 days prior and 14 days post). o Exclude persons with no ARV start date
• The definition of men and women includes children; we can ignore age.
• Formats:

proc format;

value pillfmt 1='none' 2='very few'

3='about half' 4='most' 5='all';

value enctfmt 1='adult initial' 2='adult return' 3='peds initial'

4='peds return';

value civstfmt 1='Never Married and Not

Living w/Partner'

2='Legally Married' 3='Living w/Partner' 4='Separated' 5='Divorced'

6='Widowed';

value clinfmt 1='MTRH Module 1'

2='Mosoriot' 3='Turbo' 4='Burnt Forest'