Help with Recoded Column

[mczeg]

Hello,

I'm having issues trying to recode a column to display the Fiscal Year (FY) for a particular range of dates.  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.

Attached document with screenshots.

Any help would be appreciated.

Thanks,

[Reeza]

You specify date literals in SAS as '01Jan2014'd

Try adding the quotes and d.

[mczeg]

Thanks a lot Reeza, that fixed my problem.