About davies

davies · ‎11-27-2018

Hi, Thanks all for the quick replies! As luck would have it, just after I posted this I adapted this code to account for dates: https://communities.sas.com/t5/Statistical-Procedures/How-to-split-record-into-multiple-rows-one-row-per-month-year/td-p/249306 In the end, I did this, but your way seems much more efficient, I'll try that! Thanks again! data want; set have; date=StartDate; if StartDate lt EndDate then do while (date lt EndDate); day=day(date); month=month(date); year=year(date); output; date=intnx('day',date,1); end; drop date; run;

davies · ‎11-27-2018

Hi there, I've seen posts about splitting date ranges into months, but can't quite figure out how to split a date range into one row per day. For example, I have data that looks like this: ID StartDate EndDate Status 1 Jan 28, 2018 Jan 30, 2018 1 1 Jan 30, 2018 Feb 2, 2018 2 What I need is this: ID Date Status 1 Jan 28, 2018 1 1 Jan 29, 2018 1 1 Jan 30, 2018 2 1 Jan 31, 2018 2 1 Feb 1, 2018 2 1 Feb 2, 2018 2

Online Status	Offline
Date Last Visited	‎11-27-2018 12:09 PM

Re: Split date range into one row per day

Split date range into one row per day

Re: Split date range into one row per day

Split date range into one row per day