what format to express SAS date like this Jan012012

[Mike_Davis]

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]

See the "formats by category" page: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001263753.htm

[art297 · Accepted solution]

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

;

[Mike_Davis]

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)));

[Astounding]

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]

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