topic Re: Convert Character variable / string YYYYMM into a date in SAS Enterprise Guide

Convert Character variable / string YYYYMM into a date

gregor1 — Wed, 01 Aug 2018 17:41:56 GMT

I followed "Convert Character variable / string YYYYMM in date" solved discussion and entered the following code:

PROC SQL;

CREATE TABLE WORK.QUERY_FOR_COMBINED_PANDG_MONTHLY AS

SELECT /* interval */

(input(t1.yr_mnth !! "01",yymmdd8.)) FORMAT=YYMMDD8. LABEL="interval" AS interval

FROM PLCP.COMBINED_PANDG_MONTHLY_VOLUMES t1;

QUIT;

However, the results came back as dot (.). Not sure what I did wrong. Any help will be greatly appreciated.

Thanks,

Greg

Re: Convert Character variable / string YYYYMM into a date

Tom — Wed, 01 Aug 2018 17:47:32 GMT

Either your variable is defined as longer than 6 characters, or it does not have full 6 digits. Or perhaps it is a number instead of a string? In which case it will get converted using the BEST12 format and so have 6 leading spaces before the 6 digit number.

You could use the CATS() function to insure the trailing and/or leading spaces are removed.

input(cats(t1.yr_mnth,"01"),yymmdd8.)

Re: Convert Character variable / string YYYYMM into a date

gregor1 — Wed, 01 Aug 2018 19:53:27 GMT

Thanks Tom, I just tried your code and it worked perfectly. I appreciate your help and continue to learn.

Greg

Re: Convert Character variable / string YYYYMM into a date

ho0421 — Thu, 26 Sep 2019 13:35:37 GMT

This is very helpful. Thanks.