About pp2014

pp2014 · ‎03-28-2015

Thanks Haikuo for pointing out some mistakes I was making in my code. I do need sequence in my code if there are multiple statuses on same day(last day of the month). Below is the code base Xia's code with minor changes which works. data have; input id $ dt : yymmdd10. status $; format dt yymmdd10.; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 1 20150110 A 1 20150118 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 A 3 20150213 D 3 20150223 D 3 20150223 S ; data have; set have; year=year(dt);month=month(dt); if status = 'A' then seq = 1; else if status = 'S' then seq = 2; else if status = 'D' then seq = 3; run; proc sort data=have;by id year month dt descending seq;run; data want; set have; by id year month dt descending seq; if last.month; format dt monyy7.; drop year month seq; run; proc print data = want noobs; run; Output as follows: ID dt Status 1 DEC2014 A 1 JAN2015 S 2 JAN2015 A 3 FEB2015 S

pp2014 · ‎03-28-2015

Little changes to my earlier post. I do not need Persistent Flag. I need cummulative days between the Refill if the Patient is on Therapy. Below is the data I have : ID Rx Dt Next Rx Dt Days Supply Days between next refill Base date for Persistence 123 1/31/2013 3/5/2013 30 33 4/1/2013 123 3/5/2013 4/3/2013 30 29 5/4/2013 123 4/3/2013 5/1/2013 30 28 6/2/2013 123 5/1/2013 6/5/2013 30 35 6/30/2013 123 6/5/2013 7/3/2013 30 28 8/4/2013 123 7/3/2013 8/2/2013 30 30 9/1/2013 123 8/2/2013 1/28/2014 30 10/1/2013 123 1/28/2014 2/26/2014 30 29 3/29/2014 123 2/26/2014 3/26/2014 30 28 4/27/2014 123 3/26/2014 4/25/2014 30 30 5/25/2014 123 4/25/2014 6/25/2014 30 6/24/2014 123 6/25/2014 7/22/2014 30 27 8/24/2014 123 7/22/2014 10/25/2014 30 9/20/2014 My Final Output looks like below: ID Rx Dt Next Rx Dt Days Supply Days between next refill Base date for Persistence Is Next Rx date < Base date Therapy Days on Therapy(Cumm.) 123 1/31/2013 3/5/2013 30 33 4/1/2013 TRUE 1 33 123 3/5/2013 4/3/2013 30 29 5/4/2013 TRUE 1 62 123 4/3/2013 5/1/2013 30 28 6/2/2013 TRUE 1 90 123 5/1/2013 6/5/2013 30 35 6/30/2013 TRUE 1 125 123 6/5/2013 7/3/2013 30 28 8/4/2013 TRUE 1 153 123 7/3/2013 8/2/2013 30 30 9/1/2013 TRUE 1 183 123 8/2/2013 1/28/2014 30 10/1/2013 FALSE 123 1/28/2014 2/26/2014 30 29 3/29/2014 TRUE 2 29 123 2/26/2014 3/26/2014 30 28 4/27/2014 TRUE 2 57 123 3/26/2014 4/25/2014 30 30 5/25/2014 TRUE 2 87 123 4/25/2014 6/25/2014 30 6/24/2014 FALSE 123 6/25/2014 7/22/2014 30 27 8/24/2014 TRUE 3 27 123 7/22/2014 10/25/2014 30 9/20/2014 FALSE NOTE: Cumm. Days on Therapy is nothing but Cumm. Days between each refill for each Therapy If the Patient is on Therapy first time then Therapy = 1. It will continue to be 1 until Is Next Rx date < Base date = FALSE. During that time you should do the cummulative Days on Therapy. When you see the next Is Next Rx date < Base date = TRUE then Therapy becomes 2 and .Start doing cummulative Days on Therapy from that point on until Is Next Rx date < Base date = FALSE. After that if you see Is Next Rx date < Base date = TRUE then Therapy = 3 and start doing Cumm. days on Therapy and so on I would appreciate any help in this. Thanks

pp2014 · ‎03-27-2015

Hi Hai.Kuo, I got it working using following code: data have; input id $ dt yymmdd10. status $; format dt yymmdd10.; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 1 20150110 A 1 20150118 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S ; data have; set have; mnth = substr(put(dt,yymmddn8.),1,6); if status = 'A' then seq = 1; else if status = 'S' then seq = 2; else if status = 'D' then seq = 3; run; proc sort data = have; by id mnth descending seq; run; data want; set have; if last.mnth; by id mnth descending seq; keep id mnth status; run; Output was as follows: ID mnth Status 1 201412 A 1 201501 A 2 201501 A 3 201502 S

pp2014 · ‎03-27-2015

Thanks lot everybody for help...

pp2014 · ‎03-27-2015

Any help please...

pp2014 · ‎03-27-2015

I have the following data in the table: ID Rx Dt Next Rx Dt Days Supply Base date for Persistence 123 1/31/2013 3/5/2013 30 4/1/2013 123 3/5/2013 4/3/2013 30 5/4/2013 123 4/3/2013 5/1/2013 30 6/2/2013 123 5/1/2013 6/5/2013 30 6/30/2013 123 6/5/2013 7/3/2013 30 8/4/2013 123 7/3/2013 8/2/2013 30 9/1/2013 123 8/2/2013 1/28/2014 30 10/1/2013 123 1/28/2014 2/26/2014 30 3/29/2014 123 2/26/2014 3/26/2014 30 4/27/2014 123 3/26/2014 4/25/2014 30 5/25/2014 123 4/25/2014 6/25/2014 30 6/24/2014 123 6/25/2014 7/22/2014 30 8/24/2014 123 7/22/2014 10/25/2014 30 9/20/2014 What I have to do is check if Next Rx dt < Base date for Persistence. If it is TRUE then count as Therapy = 1 and Days on Therapy = 30. If the next record is TRUE again then Therapy = 1 and Days on Therapy = 60 and so on until I find a record where Next Rx dt < Base date for Persistence = FALSE. Then Therapy = . and Days on Therapy = . If for the following record, Next Rx dt < Base date for Persistence = TRUE then it will have Therapy =2 and Days of Supply =30. Next Record if it is TRUE then Therapy = 2 and Days of Supply = 60 and so on... After that I want Persitent Flag = 'Y' for each last record of the Therapy. My Output should look like below: ID Rx Dt Next Rx Dt Days Supply Base date for Persistence Is Next Rx date < Base date Therapy Days on Therapy Persitent Flag 123 1/31/2013 3/5/2013 30 4/1/2013 TRUE 1 30 123 3/5/2013 4/3/2013 30 5/4/2013 TRUE 1 60 123 4/3/2013 5/1/2013 30 6/2/2013 TRUE 1 90 123 5/1/2013 6/5/2013 30 6/30/2013 TRUE 1 120 123 6/5/2013 7/3/2013 30 8/4/2013 TRUE 1 150 123 7/3/2013 8/2/2013 30 9/1/2013 TRUE 1 180 Y 123 8/2/2013 1/28/2014 30 10/1/2013 FALSE 123 1/28/2014 2/26/2014 30 3/29/2014 TRUE 2 30 123 2/26/2014 3/26/2014 30 4/27/2014 TRUE 2 60 123 3/26/2014 4/25/2014 30 5/25/2014 TRUE 2 90 Y 123 4/25/2014 6/25/2014 30 6/24/2014 FALSE 123 6/25/2014 7/22/2014 30 8/24/2014 TRUE 3 30 Y 123 7/22/2014 10/25/2014 30 9/20/2014 FALSE I would appreciate any help in this. Thanks

pp2014 · ‎03-27-2015

Thanks Kurt

pp2014 · ‎03-27-2015

Thanks Kurt. I tried but I am not getting correct output. Below is my code: data have; input id $ dt yymmdd10. status $; format dt yymmdd10.; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 1 20150110 A 1 20150118 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S ; data have; set have; format mnth monyy5.; mnth = dt; if status = 'A' then seq = 1; else if status = 'S' then seq = 2; else if status = 'D' then seq = 3; run; proc sort data = have; by id mnth descending seq; run; data want; set have; if last.mnth; by id mnth descending seq; keep id mnth status; run; I want the output as follows: ID mnth Status 1 Dec14 A 1 Jan15 A 2 Jan15 A 3 Feb15 S

pp2014 · ‎03-27-2015

data have; input id $ dt yymmdd10. status $; format dt yymmdd10.; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 1 20150110 A 1 20150118 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S ; I want for each month for each ID Last status . There may be multiple months of data for one ID. If there are multiple statuses on the same day then I want the seq to be (A, S, and D). Thanks

pp2014 · ‎03-27-2015

data have; input id $ dt yymmdd10. status $; format dt yymmdd10.; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 1 20150110 A 1 20150118 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S ; If I have the data as above: I want last status Each month for each id.( There may be multiple months of data for one ID) If there are 3 Statuses(A, D, S) on the same day I want the following seq: A first, S and then D. So my output should look like: ID YrMn Last_Status 1 201412 A 1 201501 A 2 201501 A 3 201502 S

pp2014 · ‎03-27-2015

Thanks Naveen. I want for each ID each month their last status. SO if suppose ID 1 has in the month of December 3 statuses A, D, S. I want last status for December in that seq (there may be in several days in the same month) but I want last status for that month based on seq. There may be multiple Statuses on last day in the given month. Also for the same ID = 1 if there may be data for Jan 2015, I want last status in Jan 2015 , or if there may be data for Feb 2015 I want last status for that ID in Feb 2015 and so on...

pp2014 · ‎03-27-2015

My Output is as follow: ID YrMn Last_Status 1 201412 A 2 201501 A 3 201502 S I you look at the data data there were 3 statues for ID =3 on same day. I need above output based on sample data

pp2014 · ‎03-27-2015

I want it based on the sequence if there are 3 statuses on same day. But my output should for each ID each month what is last status. Thanks

pp2014 · ‎03-27-2015

data have; input id $ dt yyyymm8. status $; cards; 1 20141203 D 1 20141210 D 1 20141210 A 1 20141210 S 2 20150104 A 2 20150115 D 2 20150118 S 2 20150118 D 2 20150118 A 3 20150210 S 3 20150213 D 3 20150223 D 3 20150223 S I want last status Each month for each id. If there are 3 Statuses(A, D, S) on the same day I want the following seq: A first, S and then D. So my output should look like: ID YrMn Last_Status 1 201412 A 2 201501 A 3 201502 S Thanks

pp2014 · ‎03-05-2015

I have character field Var1 = "00001234" I convert the above value from character to numeric as follows: data a; format Var1_new 11.; Var1 = "00001234"; Var1_New = Var1 *1; run; Above example does convert to numeric but keeps Zeros. Also I want to know how to get rid of padded zeros in case of Character Value. So If have Var1 = "00001234". I want Var1 = "1234" Thanks

Online Status	Offline
Date Last Visited	‎04-15-2020 05:53 PM

Re: Help with Transposing Columns into rows

Help with Transposing Columns into rows

Help with Removing Blanks in the field

Re: Help in finding the New Rx Writers

Re: Help in finding the New Rx Writers

Help in finding the New Rx Writers

Re: Filling up and down missing values with non-missing values

Re: Filling up and down missing values with non-missing values

Filling up and down missing values with non-missing values

Re: Carriage Returns - Need to be removed

Re: Filtering URL addresses

Re: How to subtract hours from datetime Variable in proc sql

Re: Help with getting Last Status Each month

Re: Help with Calculating Days on Therapy and # of Therapies

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with Calculating Days on Therapy and # of Therapies

Help with Calculating Days on Therapy and # of Therapies

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Re: Help with getting Last Status Each month

Help with getting Last Status Each month

How to get rid of padded zeros when converting from Character to numer...