topic Re: Date display as character date in SAS Programming

Date display as character date

zimcom — Fri, 21 Aug 2020 20:29:30 GMT

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!

Re: Date display as character date

novinosrin — Fri, 21 Aug 2020 20:32:19 GMT

Please try-

TD = catx(' ', put(trtsdt,date11.), doseduration);

Re: Date display as character date

zimcom — Fri, 21 Aug 2020 20:35:18 GMT

Thank you so much, and have a great weekend!!

Re: Date display as character date

ballardw — Fri, 21 Aug 2020 20:35:26 GMT

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.

Re: Date display as character date

zimcom — Fri, 21 Aug 2020 20:41:16 GMT

Thank you for the explaination!