topic Re: SAS Date Question in SAS Procedures

SAS Date Question

KevinC_ — Thu, 05 Nov 2009 22:02:57 GMT

Hello Everyone,

I am trying to put today's date in an output field in the format of mm/dd/yyyy or mm/dd/yy.

If I use today() i get a sas date. But i am not sure how to convert it to the formats above.

Thank you so much for any input!

Re: SAS Date Question

sbb — Fri, 06 Nov 2009 00:35:49 GMT

It depends on the technique you are using to display the "formatted" date. If you assign a SAS DATE (numeric) variable using today(), then you would use a FORMAT statement in your program with the desired output format specified for your variable, as shown below:

mydate = today();
format mydate mmddyys10.;

And, if you are using a SAS macro variable, you must run the SAS-generate text with a function, as shown below:

TITLE2 "RUN DATE: %SYSFUNC(TODAY(),MMDDYYS10.)";

Scott Barry
SBBWorks, Inc.

Re: SAS Date Question

KevinC_ — Fri, 06 Nov 2009 14:26:35 GMT

Thank you so much, Scott! That worked beautifully 🙂