BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
JohanK
Calcite | Level 5

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!

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Try this

 

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

View solution in original post

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

Try this

 

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

Great, this works... Thanks 

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 516 views
  • 0 likes
  • 2 in conversation