Hello, Please, I need help writing the codes to pick out values from an array of variables. So, the variables thirty_pct1-thirty_pct15 are variables showing if the patient had a 30% decrease in lab values from baseline, so 1 if 'yes' and 0 if 'no'; lab_date1-lab_date5 are the corresponding dates when the lab tests were done and pct_chg1-pct_chg5 is the percent change from baseline. I want to create columns showing the first increase and next decrease with the corresponding lab_dates and pct_chg. The patient with ID 223 has two decreases and increases so there will be two columns for date of decrease and two for dates of increase. Thank you!   data WORK.CLASS(label='Student Data'); input ID$3. thirty_pct1 thirty_pct2 thirty_pct3 thirty_pct4 thirty_pct5 lab_date1 lab_date2 lab_date3 lab_date4 lab_date5 pct_chg1 pct_chg2 pct_chg3 pct_chg4 pct_chg5; datalines; 222 0 1 1 0 1 2JAN2022 1FEB2022 4MAR2022 5APR2022 6MAY2022 -24 -31 -35 -19 -32 223 . 1 0 1 0 . 1FEB2022 4MAR2022 5APR2022 6MAY2022 . -31 -28 -33 -25 224 0 . 1 0 0 2JAN2022 . 4MAR2022 5APR2022 6MAY2022 -24 . -35 -19 -32 ;run;     ... View more

Hello, Please, I need help extracting the dates for a =>10% change in weight from baseline from a consolidated dataset for a longitudinal study for a weight loss program. There should be two variables for the dates one for the =>10% increase in weight from baseline and the other for the =>10% decrease weight as well as the associated percent change in weight. I am interested in dates for an =>10% increase in weight and if the weight ever dropped by =>10% after the weight gain., i.e. an =>10% decrease in weight after the weight gain. Some participants have multiple events of =>10% change in weight from baseline. This means they gained over 10% then lost over 10% and then gained over 10% and subsequently lost over 10%. I am attaching a made-up dataset.  Thank you. ... View more