topic Re: create date as mmdd numeric in SAS Programming

create date as mmdd numeric

Elliott — Thu, 07 Dec 2017 14:15:19 GMT

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.

Re: create date as mmdd numeric

PeterClemmensen — Thu, 07 Dec 2017 14:25:35 GMT

How are your date values stored?

Re: create date as mmdd numeric

RW9 — Thu, 07 Dec 2017 14:38:22 GMT

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.

Re: create date as mmdd numeric

Elliott — Thu, 07 Dec 2017 15:23:57 GMT

sorry,

I am using the today function for the date.

data _null_;

work_date= today();

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

run;

Re: create date as mmdd numeric

PeterClemmensen — Thu, 07 Dec 2017 15:27:13 GMT

Use mmddyyN4 format like this

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

%put &wod.;

Re: create date as mmdd numeric

Elliott — Thu, 07 Dec 2017 15:39:24 GMT

Thank you so much, you all are awesome!

Re: create date as mmdd numeric

rvsidhu035 — Sun, 10 Dec 2017 13:24:46 GMT

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