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: 
Franci941
‎04-16-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-02-2019 11:30 AM
‎04-02-2019 11:30 AM
(The two passage bonis-default is missing) ... View more

Re: Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-02-2019 11:30 AM
‎04-02-2019 11:30 AM
My code is like: data prova2; set ew; by id; retain begin_date begin_date2 begin_date3; format begin_date ddmmyy10. begin_date2 ddmmyy10. begin_date3 ddmmyy10.; if id then do; begin_date=.; begin_date2=.; begin_date3=.; end; if stato=1 and begin_date=. then do; if begin_date2 ne . then do; days_bon_def2 = date - begin_date2; output; end; if begin_date3 ne . then do; days_bon_def= date - begin_date3; output; begin_date3=.; end; begin_date= date; begin_date2= date; end; if stato=0 then do; if begin_date ne . then do; days_def_bon= date - begin_date; output; begin_date=.; end; if begin_date3 =. then begin_date3=date; end; keep id begin_date begin_date2 begin_date3 days_def_bon days_bon_def days_bon_def2; run; ... View more

Re: Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-02-2019 11:28 AM
‎04-02-2019 11:28 AM
Sorry to bother you, but they change a little what professor ask to me. The range of days that I want: - between 1'default (first accurance) and 1'bonis (first accurance) - between 1'bonis (first accurance) and 1'default (first accurance) There is also the possibility of two passage bonis-default (like 0 0 1 0 0 0 1 1) - > in this case I want these intervals: - between 1'bonis (first accurance) and 1'default (first accurance) - between 1'default (first accurance) and 1'bonis (first accurance) - between 2'bonis (first accurance) and 2'default (first accurance) And in the same way, There is also the possibility of two passage default-bonis (like 1 1 0 0 1 0 0 0) - > in this case I want these intervals: - between 1'def(first accurance) and 1'bonis(first accurance) - between 1'bonis (first accurance) and 1'def (first accurance) - between 2'def (first accurance) and 2'bonis (first accurance) Thank you so much for your help! I try all the day but my code doesn't give me the correct output.. ... View more

Re: Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-02-2019 05:55 AM
‎04-02-2019 05:55 AM
Thank you so much! It runs correctly. Last question, if I have this situation? ID STATUS 1 1 1. 1 1. 0 1. 0 1. 1 1. 1 The dates are not important; if I want to calculate (as possibility of the previous code) 1) days between first default and first bonis (like before) 2) days between first default and Second default ... View more

Re: Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-02-2019 02:00 AM
‎04-02-2019 02:00 AM
It's only one example, the dates are different.. But for today, I think it's ok 31/12/2018 ... View more

Interval between dates with a condition

by Calcite | Level 5 in SAS Enterprise Guide
‎04-01-2019 05:28 PM
‎04-01-2019 05:28 PM
Hi! My dataset is like this one ID DATE STATUS 1 31/01/2016 0 1 31/05/2016 1 1 28/02/2017 0 2 28/02/2018 1 2 31/05/2018 1 3 31/01/2016 1 3 31/03/2016 1 3 31/05/2016 0 4 31/01/2016 1 4 31/07/2016 0 4 28/02/2017 1 5 31/01/2016 0 5 31/05/2016 1 5 28/02/2017 1 You consider status=1 as default and status=0 'in bonis'. For each ID, I have to calculate the days between: - if it starts with default (status=1) and it continues always with default (like ID=2) -> calculate the days between the first observation date (28/02) and today - if it starts with default (status=1) and it continues with in bonis (status=0) (like ID=3) -> calculate the days between the last default date (31/03) and in bonis date - if it starts with bonis (status=0) and it continues with default (status=1) (like ID=5) -> calculate the days between the first default date (31/05) and today - if it starts with default (status=1), it continues with in bonis (status=0) and it returns in default (like ID=4) -> calculate the days between the first default date (31/01) and in bonis date (31/07), the days between the Second default date (28/02) and today - if it starts with in bonis (status=0) it continues with default (status=1) and it returns in bonis (like ID=1) -> calculate the days between the default date (31/05) and in bonis date Thank you so much to everyone who answers me soon! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-16-2019 12:45 PM
Quick links