create date as mmdd numeric

[Elliott]

am trying to create a macro variable to append to a report name and I need it to be mmdd, (ie 0709, for july 9th).  So far I have been unsuccessful trying to separate the date parts and concatenating back together in this format.  I know there is probably an easy fix but I am just not getting there.  Any assistance will be greatly appreciated.

Thanks.

[PeterClemmensen]

How are your date values stored?

[RW9]

Show some test data, we can't guess!

data _null_;
  call symput('d',put('01JAN2016'd,yymmdd10.));
run;

ods rtf file="abc_&d..rtf";
...

For example.

[Elliott]

sorry,

I am using the today function for the date.

data _null_;

work_date= today();

call symput ("wod",put(work_date,yymmddn8.));

run;

[PeterClemmensen · Accepted solution]

Use mmddyyN4 format like this

data _null_;
work_date= today();
call symput ("wod",put(work_date,mmddyyN4.));
run;

%put &wod.;

[Elliott]

Thank you so much, you all are awesome!

[rvsidhu035]

data month_date;
x='07jun1989'd;
format x mmddyyn4.;
run;