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: 
APU_007
‎11-22-2019
  • 4 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: calculate total net stay and gap days

by Fluorite | Level 6 in SAS Programming
‎11-19-2019 11:53 AM
‎11-19-2019 11:53 AM
Hello @novinosrin,   This is what I was exactly looking for. Thank you so much for this piece of code. Regarding, adding +1, I was excluding the start date for a final total stay. It can be included/excluded as this would be a rule for every observation! ... View more

calculate total net stay and gap days

by Fluorite | Level 6 in SAS Programming
‎11-19-2019 09:37 AM
‎11-19-2019 09:37 AM
I have found some help but not quite able to resolve the issues so looking for a help to get it done correctly. Here is the example of sample data-set and result data-set that is desired.   Data have:   ID START_DATE End_Date 1 23-Jan-04 27-Mar-08 1 27-Mar-10 27-Mar-13 1 27-Mar-10 27-Aug-18 1 27-Mar-13 27-Mar-15 1 25-Sep-13 25-May-16 2 16-Dec-06 12-Dec-18 2 16-Jan-09 16-Jan-14 2 16-Jan-14 16-Jan-17 3 23-Jan-04 27-Mar-08 3 23-Jan-09 27-Mar-12 3 1-May-14 1-May-18 4 25-Feb-08 25-Feb-15 4 7-Mar-08 7-Mar-15 4 28-Feb-19 28-Feb-20   Data want: ID START_DATE End_Date Stay Gap Net_Stay 1 23-Jan-04 27-Aug-18 5330 730 4600 2 16-Dec-06 12-Dec-18 4379 0 4379 3 23-Jan-04 1-May-18 5212 1067 4145 4 25-Feb-08 28-Feb-20 4386 1454 2932   What is actually needed: START_DATE - minimum for a given ID End_Date - maximum for a given ID Stay - Total Stayed Gap - Any gap during the stay NetStay - Total Stay - Gap   Started thinking about going this route but appears with this logic - not able to salvage min(Start_Date) and Max(End_Date). data diff; merge have HAVE(firstobs=2 keep=ID START_DATE end_date rename=(ID=nID START_DATE=nSTART_DATE end_date=nend_date)); diff_date=end_date-start_date; if ID=NID then do; diff_btwn_date=nSTART_DATE-end_date; end; run;   Note: i am using SAS9.4   So, GAP is calculated as nStart Date - End_date. Example: For ID1 - There is no coverage between 3/27/2008 and 3/27/2010 so the GAP = 730 days. If there are multiple gaps then it has to be summed up to get the total gap days (for ID3 = 302 + 765 = 1067 days)   Thank you in advance for your help! ... View more

Re: SAS.exe has stopped working

by Fluorite | Level 6 in SAS Programming
‎04-20-2017 10:20 AM
‎04-20-2017 10:20 AM
I am having the exact same issue. It’s happening frequent but can't say it happening regularly. I kind of find one link but not yet tested. The link seems to be for the SAS9.4M2. I am running SAS9.04.01M4 in Windows 7, 64bit so not sure if it works for me.   http://support.sas.com/kb/54/246.html   You may also want to clean your residual temp datasets hanging out in temp directory gulping hard drive space. As I read when SAS terminates properly it deletes its all temp datasets but not so when it terminates with an error.    Here is one of the ways to check your work directory.    %let work_path=%sysfunc(pathname(work)); %put &work_path ;   HTH, APU_007 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-22-2019 02:45 PM
Likes given to
View All
Quick links