topic Re: what format to express SAS date like this Jan012012 in SAS Procedures

what format to express SAS date like this Jan012012

Mike_Davis — Tue, 07 Aug 2012 13:33:21 GMT

Hello everyone

I can use %put %sysfunc(date(),monyy7); to give a date format like AUG2012,but this doen't include date

what format we can use to express date like AUG082012??

Thanks

Mike

mkeintz — Tue, 07 Aug 2012 13:48:49 GMT

art297 — Tue, 07 Aug 2012 13:54:09 GMT

Not sure how you want to use it, but the following achieves the desired result:

data want;

input term date9.;

x= compress(put(term,worddate12.)," ,");

cards;

14jun2012

28feb2011

;

Astounding — Tue, 07 Aug 2012 14:24:32 GMT

Why wouldn't you just use &SYSDATE9? It is there for the taking, and wouldn't that be easier to read?

If you really want to rearrange it, you could use:

%let mydate = %substr(&sysdate9,3,3)%substr(&sysdate9,1,2)%substr(&sysdate9,6,4);
%put &mydate;

Good luck.

Mike_Davis — Tue, 07 Aug 2012 15:12:14 GMT

Thanks Art,

1.%put %sysfunc(compress("abc_%sysfunc(date(),worddate12.)"," ,"));

2.%put abc_%sysfunc(date(),Monname3)%sysfunc(strip(%sysfunc(date(),day)))_%sysfunc(strip(%sysfunc(date(),year)));

Mike_Davis — Tue, 07 Aug 2012 15:15:58 GMT

I believe &sysdate value is the date of the SAS section opened.not the current time.if the SAS section has opened for a long time,

this value could not express the current date we need.

Thank you

Mike