How to save macro data into a table

tparvaiz — Fri, 29 Jun 2012 15:40:43 GMT

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

Re: How to save macro data into a table

Patrick — Fri, 29 Jun 2012 16:08:29 GMT

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;