04-30-2015 09:31 AM
04-30-2015 09:37 AM
Based on your question I'm not sure what you are asking for. Is this what you want?
format date1 date2 mmddyy10.;
date1 = '02DEC2014'd;
date2 = '03JAN2015'd;
date_diff = intck('day',date1,date2);
04-30-2015 09:42 AM
Sorry the link didn't show up:
I am trying to find another code that does similar to this. The issue with this it does not work for cross year boundaries i.e December 2014 and January 2015
04-30-2015 09:53 AM
Post some test data. I personally would expand your data for each date then sum it up, note to transpose you would need to know year and month e.g.
do day_date=effective_date to end_date;
create table WANT as
COUNT(1) as CNT
group by YR,
04-30-2015 10:10 AM
Here are some sample data:
Visit Number Checkin Date CheckoutDate
Should be this:
Visit Number Checkin Date CheckoutDate Dec 2014 Jan 2015
04-30-2015 10:26 AM
Yes, my program should work on that. I wouldn't go with having dates as columns though. Its a bad idea in the longer term, I mean if you had a time period (not necessarily on one row, but over all data) of several years, you can end up with lots of columns with few data in. Better to keep it normalised as my output will do, or genericise the columns, e.g. COL1-COLx, so you can use arrays and fill up only the ones you need.