Greeting!
I want concatenate a SAS date variable trtsdt (eg., "2018-04-27") with text string doseduration "10 minutes" into a new text variable "27-Apr-2018 10 minutes", but when I use
TD = catx(' ', trtsdt, doseduration);
what I got is "21301 10 minutes"
How can I got the date portion appear as date like "27-Apr-2018 10 minutes"
Thank you so much!
Please try-
TD = catx(' ', put(trtsdt,date11.), doseduration);
Try:
D = catx(' ', put(trtsdt, date11.), doseduration);
you need to explicitly apply a format with Put to create a text value. Otherwise the CATX and similar functions will use a Best. format yielding integers for dates.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.