Dear SAS Community,
I have a list of "Old_dates" of which I would like to create a new variable "New_dates" that groups the "Old_dates by week according to the last Saturday in that week. See my example below. As I have many years worth of dates, how do I automate the process? I'd like to avoid manual coding for the new variable (i.e. if '02Mar2013' < old_date <=09Mar2013 then new_dates = '09Mar2013').
Note, old_dates may not always have all 7 days in a week listed. Sometimes only 3-4 dates are listed per each 7 day time frame and one may or may not be a Saturday (see "New-dates=09Mar2013).
Thank you in advance!
Sophia
Old_dates New_dates
24Feb2013 = 02Mar2013
25Feb2013 = 02Mar2013
26Feb2013 = 02Mar2013
27Feb2013 = 02Mar2013
28Feb2013 = 02Mar2013
01Mar2013 = 02Mar2013
02Mar2013 = 02Mar2013
05Mar2013 = 09Mar2013
06Mar2013 = 09Mar2013
07Mar2013 = 09Mar2013
08Mar2013 = 09Mar2013
11Mar2013 = 16Mar2013
12Mar2013 = 16Mar2013
13Mar2013 = 16Mar2013
16Mar2013 = 16Mar2013
new_dates=intnx('week',old_dates,0,'end');
new_dates=intnx('week',old_dates,0,'end');
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.