topic Re: can i convert date mm/dd/yyyy to character "mmddyyyy" in Discussions

can i convert date mm/dd/yyyy to character "mmddyyyy"

gow — Tue, 22 May 2012 20:55:08 GMT

I need to concat the date information with the file name, however during concat the date variable changes to sas or hexadecimal format. Thanks Gowri

pmroz — Wed, 23 May 2012 13:38:04 GMT

Use the Format statement to convert to text:

a = today();

b = format(a, "mmddyyyy");

print(b);

Yields the result:

"05232012"

gow — Thu, 24 May 2012 12:18:10 GMT

thanks, This was exactly what i was looking for!!