Hey folks ,here is my data and i want to flag the last non missing obs before week2 ,suggest a method other than subsetting and sorting
DATA LAB; INPUT USUBJID 3. VISIT $10. @15 LBTESTCD $3. @19 LBORRES 3. @23 LBDTC DDMMYY10.; FORMAT LBDTC DDMMYY10.; DATALINES; 101 SCREENING ALT 24 24-10-2015 101 PREDOSE ALT 52 22-11-2015 101 BASELINE ALT 45 22-12-2015 101 WEEK2 ALT 50 10-01-2016 101 WEEK4 ALT 45 11-02-2016 101 WEEK6 ALT 55 12-02-2016 101 SCREENING LDH 110 24-10-2015 101 PREDOSE LDH . 22-11-2015 101 BASELINE LDH . 23-12-2015 101 WEEK2 LDH 120 10-01-2016 101 WEEK4 LDH 120 11-02-2016 102 SCREENING ALT 44 24-10-2015 102 PREDOSE ALT 55 22-11-2015 102 BASELINE ALT . 10-01-2016 102 WEEK2 ALT 52 11-02-2016 102 SCREENING LDH . 24-10-2015 102 PREDOSE LDH . 22-11-2015 102 BASELINE LDH 120 12-12-2015 102 WEEK2 LDH 100 11-01-2016 102 WEEK4 LDH 110 12-02-2016 ; RUN;
... View more