https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438034#M109175 <P>This worked perfectly-thanks!</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 16 Feb 2018 18:04:24 GMT kbone1975 2018-02-16T18:04:24Z https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438006#M109168 <P>I am trying to convert a calculated date with a YYMMD7. format to a CHAR format in a proc sql where clause. The table I am selecting from has a text date column (2018-01). I have tried using put(date, CHAR7.) and get an error. Is there something else I can do to make this work?&nbsp;&nbsp;</P> Fri, 16 Feb 2018 15:58:57 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438006#M109168 kbone1975 2018-02-16T15:58:57Z https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438009#M109169 <PRE><CODE class=" language-sas">data _null_; x=put(today(),yymmd7.); put x=; run;</CODE></PRE> Fri, 16 Feb 2018 16:05:30 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438009#M109169 Ksharp 2018-02-16T16:05:30Z https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438034#M109175 <P>This worked perfectly-thanks!</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 16 Feb 2018 18:04:24 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-convert-YYMMD7-to-CHAR7/m-p/438034#M109175 kbone1975 2018-02-16T18:04:24Z