How to save macro data into a table

Reply
Frequent Contributor
Posts: 134

How to save macro data into a table

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

Respected Advisor
Posts: 4,173

Re: How to save macro data into a table

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;

Ask a Question
Discussion stats
  • 1 reply
  • 186 views
  • 1 like
  • 2 in conversation