Desktop productivity for business analysts and programmers

Help with Recoded Column

Reply
Occasional Contributor
Posts: 10

Help with Recoded Column

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,

Super User
Posts: 19,167

Re: Help with Recoded Column

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

Try adding the quotes and d.

Occasional Contributor
Posts: 10

Re: Help with Recoded Column

Thanks a lot Reeza, that fixed my problem.

Ask a Question
Discussion stats
  • 2 replies
  • 476 views
  • 0 likes
  • 2 in conversation