cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Haritha1
  • 12 Posts
  • 7 Likes Given
  • 0 Solutions
  • 0 Likes Received
This widget could not be displayed.

Re: Grouping of Relative month

by Fluorite | Level 6 in SAS Programming
‎07-02-2017 09:46 AM
‎07-02-2017 09:46 AM
Hi art297,   Thanks for your time and patience.   I have managed to code it though after spending considerable amount of time....) ... View more

Re: Grouping of Relative month

by Fluorite | Level 6 in SAS Programming
‎07-01-2017 11:08 PM
‎07-01-2017 11:08 PM
I hope it is clear. ... View more

Re: Grouping of Relative month

by Fluorite | Level 6 in SAS Programming
‎07-01-2017 09:40 PM
‎07-01-2017 09:40 PM
This is relative month calculation.    ID 1 has M1 in 01.2014(relative_month1 variable) and M2 in 02.2014. I grouped this in 201401 bucket ID 1 has M1 in in 02.2014(relative_month2 varibale) and M2 in 05.2014 -  I grouped this in 201402 bucket   So M2 can fall on any date but we are not showing it in the output.   we are just showing when a particular patient has started and how many  follow up's he has.   I will give another example if 10 patients are satrting on 01.2014(M1) and out of the 10, 9 are coming back second time(can be on any date), I will flag the second instance as M2 and represent 9 in M2. In the input data the complication is our initiations can also happen in between the follow up period. same patient can have multiple initiation dates, ID 1 has initiation dates on 01.2014,  04.2014,   07.2014. our first initiation date is  on 01.2014 when the follow up for this is M4, again the same ID is initiated also on 04.2014.   Sorry if this is confusing.   In the output I'm interested to show only the initiation date and the follow up's.     ... View more

Re: Grouping of Relative month

by Fluorite | Level 6 in SAS Programming
‎07-01-2017 09:10 PM
‎07-01-2017 09:10 PM
Hi,   Please interpret the output vertically.   In  input data ID 1 has three M1's. First M1 is starting on 01.2014 (relative_month1 variable) and has follow up of 10months.  Second M1 is starting on 04.2014 (relative_month2 variable)  and has follow up of 7months. Third M1 is starting on 07.2014(relative_month3 variable)  and has follow up of 4months.   Same  thing is represented in the output. Hope I clarified ur question.   ID Flag date relative_month1 relative_month2 relative_month3 1 1 1.2014 m1     1 0 2.2014 m2     1 0 3.2014 m3     1 1 4.2014 m4 m1   1 0 5.2014 m5 m2   1 0 6.2014 m6 m3   1 1 7.2014 m7 m4 m1 1 0 8.2014 m8 m5 m2 1 0 9.2014 m9 m6 m3 1 0 10.2014 m10 m7 m4 ... View more

Grouping of Relative month

by Fluorite | Level 6 in SAS Programming
‎07-01-2017 11:59 AM
‎07-01-2017 11:59 AM
Hi,   I'm struck again with one more logic. I have data as below.   ID Flag date relative_month1 relative_month2 relative_month3 1 1 1.2014 m1     1 0 2.2014 m2     1 0 3.2014 m3     1 1 4.2014 m4 m1   1 0 5.2014 m5 m2   1 0 6.2014 m6 m3   1 1 7.2014 m7 m4 m1 1 0 8.2014 m8 m5 m2 1 0 9.2014 m9 m6 m3 1 0 10.2014 m10 m7 m4 2 1 2.2014 m1     2 0 3.2014 m2     2 0 4.2014 m3     2 1 5.2014 m4 m1   2 0 6.2014 m5 m2   2 0 7.2014 m6 m3   2 1 8.2014 m7 m4 m1 2 0 9.2014 m8 m5 m2   I need output as below.     201401 201402 201403 201404 201405 201406 201407 201408 m1 1 1   1 1   1 1 m2 1 1   1 1   1 1 m3 1 1   1 1   1   m4 1 1   1 1   1   m5 1 1   1 1       m6 1 1   1         m7 1 1   1         m8 1 1             m9 1               m10 1               m11                 m12                 Here is how i want to group, for example ID 1 has M1 in  01.2014,  04.2014,  07.2014.   In 01.2014 it has 10 months follow up. In 04.2014 it has 7 months follow up In 07.2014 it has 4 months follow up. same thing is represented in the output.   I have millions of records like this, different ID's can have  M1 on the same date.   I have taken cohort approach to solve this which is very lengthy.   Thanks alot in  Advance. please let me know if  something is not clear.   I edited the question as there was some error in the output given. ... View more

Re: calculating relative month

by Fluorite | Level 6 in SAS Programming
‎07-01-2017 09:59 AM
‎07-01-2017 09:59 AM
Thanks alot for your time. This is very helpful ... View more

calculating relative month

by Fluorite | Level 6 in SAS Programming
‎06-30-2017 09:50 PM
‎06-30-2017 09:50 PM
Hi,   I have an input data as follows.   ID Flag date 1 1 1.2014 1 0 2.2014 1 0 3.2014 1 1 4.2014 1 0 5.2014 1 0 6.2014 1 1 7.2014 1 0 8.2014 1 0 9.2014 1 0 10.2014 2 1 2.2014 2 0 3.2014 2 0 4.2014 2 1 5.2014 2 0 6.2014 2 0 7.2014 2 1 8.2014 2 0 9.2014   I need output as follows.   ID Flag date relative_month1 relative_month2 relative_month3 1 1 1.2014 m1     1 0 2.2014 m2     1 0 3.2014 m3     1 1 4.2014 m4 m1   1 0 5.2014 m5 m2   1 0 6.2014 m6 m3   1 1 7.2014 m7 m4 m1 1 0 8.2014 m8 m5 m2 1 0 9.2014 m9 m6 m3 1 0 10.2014 m10 m7 m4 2 1 2.2014 m1     2 0 3.2014 m2     2 0 4.2014 m3     2 1 5.2014 m4 m1   2 0 6.2014 m5 m2   2 0 7.2014 m6 m3   2 1 8.2014 m7 m4 m1 2 0 9.2014 m8 m5 m2   for each ID with change in flag number to 1, I want to create a new varibale (relative month variable) and assign it to m1 and the follow up period should increment by 1. Hope the question is clear.   Any help is appreciated. Thanks alot in Advance. ... View more

Re: formatting numeric to date

by Fluorite | Level 6 in SAS Programming
‎02-10-2017 05:32 AM
‎02-10-2017 05:32 AM
Hi RW9,   I'm working in a VDI, so couldn't post the data and log information.   Thanks for your reply.   I did the same and it worked.     Is there a way to do it with out concatenating 01?   Thanks. ... View more

formatting numeric to date

by Fluorite | Level 6 in SAS Programming
‎02-10-2017 05:07 AM
‎02-10-2017 05:07 AM
Hi,   I'm working on a data which has numeric variable in the follwing way.   01.2015 04.2015 06.2015 09.2015   I tried converting it in to date format by using following code.   format variable yymmn6.;   I'm getting following output.   196001 196001 196001 196001   can any one please tell me the reason for the above output and how do I rectify the probem.   Thanks alot in advance.   ... View more

Base SAS programming_Cumulative sum

by Fluorite | Level 6 in SAS Programming
‎12-16-2016 12:43 AM
‎12-16-2016 12:43 AM
Hi,   I have a data set with 100 records for customerID 1. I need for every row cumulative sum considering only 12 rows before the current row. PS: In which case i will not have cumulative sum for the first 12 rows. How can I do this in SAS? Thanks in Advance.   ID Number cum_sum 1 1   1 2   1 3   1 4   1 5   1 6   1 7   1 8   1 9   1 10   1 11   1 12   1 13     So on........, ... View more

Re: SAS Rows

by Fluorite | Level 6 in SAS Programming
‎11-29-2016 04:15 AM
‎11-29-2016 04:15 AM
This is helpful.   Thanks..) ... View more

Create rank from a flag

by Fluorite | Level 6 in SAS Programming
‎11-28-2016 09:21 AM
‎11-28-2016 09:21 AM
Hi Everyone,   Could you please help me to code the below logic.   I have a flag variable in my data set and I want to create a Rank variable in the following way.   PS: I'm using SAS 9.4.   flag Rank 0 1 1 2 1 2 1 2 0 3 1 4 1 4 0 5 1 6 1 6 1 6   Thanks a lot in Advance. ... View more
Contact Me
Likes given to
Quick links