topic Re: Put (to_char) function in SAS PROC SQL showing YYYY/MM format from datetime in SAS Programming

Put (to_char) function in SAS PROC SQL showing YYYY/MM format from datetime

MartinJurca — Sun, 26 Jan 2020 17:10:54 GMT

Hi.

I have a column with datetime values like this: 01.01.20 09:28:35,000000

And I want to change them into this format (YYYY/MM): 2020/01

In Oracle SQL I used function to_char(column_name,'YYYY/MM') but I wasn't able to do the same thing in SAS PROC SQL.

I tried things like put(column_name,yyyySmm7.) but it either doesn't work or date values are out of range or it shows weird numbers...

Can anybody help me with this?

Thanks in advance!

Re: Put (to_char) function in SAS PROC SQL showing YYYY/MM format from datetime

unison — Sun, 26 Jan 2020 17:44:25 GMT

Sounds like you need:

put(datepart(column_name), yymms7.) as yyyysmm

Re: Put (to_char) function in SAS PROC SQL showing YYYY/MM format from datetime

MartinJurca — Sun, 26 Jan 2020 17:53:56 GMT

Thanks, it is working!

Re: Put (to_char) function in SAS PROC SQL showing YYYY/MM format from datetime

Peter_C — Sun, 26 Jan 2020 22:29:33 GMT

Other approaches you might consider:
Without changing the internal value, assign it SAS Format DTdate9.
Instead of this standard format (as I don't think DTyymms format exists), you can create your own format with your preferred date layout using the Format Procedure)