topic Re: How can I output a date as a date within a string and not as numeric in SAS Programming

How can I output a date as a date within a string and not as numeric

JohanK — Thu, 19 Jan 2023 12:58:36 GMT

Dear reader, I ran into a small issue..

I want to output date as a visible date in (in this case DATE9.) format and not as a numeric output. The format of AESTDT is DATE9. As an example 01DEC2021

My code for this example is Code: MSG='Onset Date - '||TRIM(AESTDT)||'- is available';

The output is this: Onset Date - 22974- is available
But what I want is Onset Date - 01DEC2021- is available

What can I do? Thanks so much for your help!

Re: How can I output a date as a date within a string and not as numeric

PeterClemmensen — Thu, 19 Jan 2023 13:02:01 GMT

Try this

data test;
   AESTDT = '01DEC2021'd;
   MSG = 'Onset Date - '||TRIM(put(AESTDT, date9.))||'- is available';
run;

Re: How can I output a date as a date within a string and not as numeric

JohanK — Thu, 19 Jan 2023 13:20:46 GMT

Great, this works... Thanks