Hi,
I need to create a table that will update with the dates for the next 15 days, as an example...
DAY DATE
D_1 30Jun2012:00:00:00
D_2 01Jul2012:00:00:00
D_3 02Jul2012:00:00:00
D_4 03Jul2012:00:00:00
...
Here is the macro that creates a date, but I need to know how to put it in a table
%let today = %sysfunc(today());
%let D_1 = %sysfunc(dhms(%sysfunc(intnx(day,&today,1)),7,0,0),DATETIME20.);
%let D_2 = %sysfunc(dhms(%sysfunc(intnx(day,&today,2)),7,0,0),DATETIME20.);
%let D_3 = %sysfunc(dhms(%sysfunc(intnx(day,&today,3)),7,0,0),DATETIME20.);
%let D_4 = %sysfunc(dhms(%sysfunc(intnx(day,&today,4)),7,0,0),DATETIME20.);
Thanks in advance
Why don't you just use a data step like below?
data mydates;
format date date9. datetime07 datetime21.;
do date=today() to today()+14;
datetime07=dhms(date,7,0,0);
output;
end;
run;
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.