About NickS2

NickS2 · ‎06-28-2022

I am getting unusual results when I am using the lag function and not getting the results I am looking for. Dataset: ID Event_Date 1 12MAY2020 1 24JUN2020 1 08AUG2020 2 09APR2020 3 26JUN2020 3 30AUG2020 Program I wrote: data want; set have; by ID; if first.ID then prev_event_dt = .; else prev_event_dt=lag(Event_Date); run; Output I am expecting: ID Event_Date prev_event_dt 1 12MAY2020 . 1 24JUN2020 12MAY2020 1 08AUG2020 24JUN2020 2 09APR2020 . 3 26JUN2020 . 3 30AUG2020 26JUN2020 Please point out where I am going wrong with the program I wrote. Thank you

NickS2 · ‎06-16-2022

So I have a dataset with many variables and multiple observations for one ID. I want to keep the unique observations but at the same time populate the non-missing value from that observation. Below is the sample of the dataset: ID CLINIC ADM_DT DIS_DT DIAG_CD 1 ABC 03SEP2005 06SEP2005 1 ABC 03SEP2005 T10.009 1 ABC 19DEC2006 21DEC2006 1 ABC 19DEC2006 21DEC2006 F23.091 2 XYZ 06OCT2006 10OCT2006 J09.01 2 XYZ 06OCT2006 10OCT2006 3 LMN 21JAN2005 25JAN2005 3 LMN 21JAN2005 25JAN2005 3 LMN 04OCT2006 J09.2 3 LMN 04OCT2006 05OCT2006 ADM_DT is always populated in the dataset the issues are DIS_DT and DIAG_CD which are missing at some places. My aim is to get the DIS_DT and DIAG_DT for each patient for each ADM_DT. Output expected: ID CLINIC ADM_DT DIS_DT DIAG_CD 1 ABC 03SEP2005 06SEP2005 T10.009 1 ABC 19DEC2006 21DEC2006 F23.091 2 XYZ 06OCT2006 10OCT2006 J09.01 3 LMN 21JAN2005 25JAN2005 3 LMN 04OCT2006 05OCT2006 J09.2

NickS2 · ‎04-07-2022

Hello All, I am stuck with this issue where I want to add when there is change in flag value. Example: ID Flag 1 0 1 1 1 1 1 1 2 1 2 0 2 0 2 1 2 1 2 0 2 0 3 1 3 1 3 1 3 1 4 0 4 0 4 0 4 1 4 1 Output expected: ID Flag Cnt 1 0 1 1 1 2 1 1 2 1 1 2 2 1 1 2 0 2 2 0 2 2 1 3 2 1 3 2 0 4 2 0 4 3 1 1 3 1 1 3 1 1 3 1 1 4 0 1 4 0 1 4 0 1 4 1 2 4 1 2

NickS2 · ‎05-29-2020

@novinosrin This is exactly what I wanted. Thank you so much, you are a life saver.

NickS2 · ‎05-29-2020

@novinosrin This just gives me the records which are flagged and not the after date records of the patient who got flagged. Like for patient ID 1 the first record gets flagged so I want all the 4 records for that patient but for patient ID 3 the third record gets flagged then I want all the records after third record (including third record). I hope you got my point.

NickS2 · ‎05-29-2020

@mklangley No the second record for the patient ID 2 should be not get flagged because the first record already met the criteria.

NickS2 · ‎05-29-2020

@novinosrin I want to keep all the records of the patient who meet the treatment criteria except those records which are pre-dated to the treatment criteria met date. Thank you

NickS2 · ‎05-29-2020

Thank you @novinosrin, it worked flawlessly. I have one more question. Can I delete the all the records for the patients who did not meet the treatment criteria and previous date records of the patients who meet the treatment criteria? To be more precise I don't want any records of the patients who did not meet the treatment criteria but want to keep all the records of the patient who meet the treatment criteria except those records which are pre-dated to the treatment criteria met date.

NickS2 · ‎05-29-2020

@novinosrin ID DRUG DATE VISIT ENROL_FLAG DAY_DIFF 1 A 29APR2018 1 Y . 1 D 29APR2018 1 Y . 1 A 21MAY2019 2 Y 22 1 D 21MAY2019 2 Y 22 2 B 27JUN2015 1 Y . 2 B 26JUL2015 2 Y 29 2 C 26JUN2016 3 Y 365 2 C 27JUL2016 4 Y 31 3 C 03MAR2015 1 N . 3 B 03MAR2015 1 N . 3 C 12SEP2015 2 Y 193 3 B 12SEP2015 2 Y 193 3 D 15OCT2016 3 Y 388 3 D 14NOV2016 4 N 29 4 B 01NOV2014 1 N . 4 B 28NOV2014 2 N 27 4 B 23DEC2014 3 N 25 4 B 01AUG2015 4 N 247 5 D 12MAR2015 1 Y . 5 D 09APR2015 2 Y 28 5 D 03MAY2015 3 Y 22 5 C 10JUN2016 4 Y 401 5 C 03JUL2016 5 Y 24 I expect one patient to be flagged only once for a particular visit if he/she meets the criteria. The criteria is either it has to be patients first visit and ENROL_FLAG = "Y" and if this criteria is not satisfied then irrespective of the visit the ENROL_FLAG = "Y" and DAY_DIFF>180 days. Also if the patient has multiple record when he/she is meeting the criteria then all the records should be flagged. Like for patient ID 1, as he is meeting the criteria in his first visit, both the records should be flagged for treatment. Thank you

NickS2 · ‎05-29-2020

@novinosrin the results are not as expected when I applied this code to my dataset as there are patients who have taken different drug after a gap of more than 180 days and that is why it is flagging them again. For example if the patient ID 2 is taking C drug in his second visit then this code will raise the TRT_FLAG again.

NickS2 · ‎05-28-2020

Thanks Jagdish, But youe code is giving me the same result which I am getting.

NickS2 · ‎05-28-2020

Thank you Novino, I ran your code but it is flagging the ID number 2's both visits which I don't want.

NickS2 · ‎05-28-2020

Thank you for the reply Dave but if I will use the retain statement as you suggested it is flagging all the observations for that ID which I don't want. I just want to flag only those observations which are meeting the criteria I suggested above.

NickS2 · ‎05-28-2020

I want to flag the treatment if certain conditions are met but I don't want to flag it again for the same patient. The condition here is, if the patient is taking drug A. B, C or D for the very first time and the ENROL_FLAG = "Y". If the first condition doesn't get satisfied then the second condition is that ENROL_FLAG = "Y" and the DAY_DIFF > 180. Also if the patient is receiving two or more treatment on the same day where he is meeting this criteria all the observations should get flagged. The code I wrote is, data WANT; set HAVE; by ID DATE; if first.ID and ENROL_FLAG = "Y" then TRT_FLAG= "Y"; else if ENROL_FLAG="Y" and DAY_DIFF > 180 then TRT_FLAG="Y"; run; This is how my data looks like: ID DRUG DATE VISIT ENROL_FLAG DAY_DIFF 1 A 29APR2018 1 Y . 1 D 29APR2018 1 Y . 1 A 21MAY2019 2 Y 22 1 D 21MAY2019 2 Y 22 2 B 27JUN2015 1 Y . 2 B 26JUN2016 2 Y 365 3 C 03MAR2015 1 N . 3 B 03MAR2015 1 N . 3 C 12SEP2015 2 Y 193 3 B 12SEP2015 2 Y 193 The result I am getting is: ID DRUG DATE VISIT ENROL_FLAG DAY_DIFF TRT_FLAG 1 A 29APR2018 1 Y . Y 1 D 29APR2018 1 Y . 1 A 21MAY2019 2 Y 22 1 D 21MAY2019 2 Y 22 2 B 27JUN2015 1 Y . Y 2 B 26JUN2016 2 Y 365 Y 3 C 03MAR2015 1 N . 3 B 03MAR2015 1 N . 3 C 12SEP2015 2 Y 193 Y 3 B 12SEP2015 2 Y 193 The result I want: ID DRUG DATE VISIT ENROL_FLAG DAY_DIFF TRT_FLAG 1 A 29APR2018 1 Y . Y 1 D 29APR2018 1 Y . Y 1 A 21MAY2019 2 Y 22 1 D 21MAY2019 2 Y 22 2 B 27JUN2015 1 Y . Y 2 B 26JUN2016 2 Y 365 3 C 03MAR2015 1 N . 3 B 03MAR2015 1 N . 3 C 12SEP2015 2 Y 193 Y 3 B 12SEP2015 2 Y 193 Y

NickS2 · ‎05-22-2020

Thank you Kurt. This makes sense, simplifying the data makes it straight-forward.

Online Status	Offline
Date Last Visited	‎06-28-2022 05:28 PM

Unexpected results with lag function

Selecting the populated values for unique observations

Add only when Flag value changes

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Unexpected results with lag function

Re: Unexpected results with lag function

Re: Selecting the populated values for unique observations

Re: Add only when Flag value changes

Re: Flag only once if the criteria is met

Unexpected results with lag function

Selecting the populated values for unique observations

Add only when Flag value changes

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Re: Flag only once if the criteria is met

Flag only once if the criteria is met

Re: Complex programming goal