topic Help with Recoded Column in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142797#M11391 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm having issues trying to recode a column to display the Fiscal Year (FY) for a particular range of dates.&nbsp; In the "Specify a Replacement" dialogue box using either the Replace a Range or Replace a Condition tabs, If I use anything other than the formatted SAS dates available in the drop down I either get a syntax error or the query will run but no results will populate.</P><P></P><P>Attached document with screenshots.</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 28 Jan 2015 19:19:34 GMT mczeg 2015-01-28T19:19:34Z Help with Recoded Column https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142797#M11391 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm having issues trying to recode a column to display the Fiscal Year (FY) for a particular range of dates.&nbsp; In the "Specify a Replacement" dialogue box using either the Replace a Range or Replace a Condition tabs, If I use anything other than the formatted SAS dates available in the drop down I either get a syntax error or the query will run but no results will populate.</P><P></P><P>Attached document with screenshots.</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 28 Jan 2015 19:19:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142797#M11391 mczeg 2015-01-28T19:19:34Z Re: Help with Recoded Column https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142798#M11392 <HTML><HEAD></HEAD><BODY><P>You specify date literals in SAS as '01Jan2014'd</P><P></P><P>Try adding the quotes and d. </P></BODY></HTML> Wed, 28 Jan 2015 20:01:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142798#M11392 Reeza 2015-01-28T20:01:33Z Re: Help with Recoded Column https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142799#M11393 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Reeza, that fixed my problem.</P></BODY></HTML> Wed, 28 Jan 2015 21:24:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help-with-Recoded-Column/m-p/142799#M11393 mczeg 2015-01-28T21:24:45Z