Using Macro Variables in Query Builder's Filter

[avigdo]

Hi,

I'm trying to use a macro variable (a date) in the filter, but I get an error. (Error 22-232)

That is what i'm typing - &start_of_month.

That variable is declared previously in a Program at the beginning of the  Process Flow.

Unfortunately, i cant attach printscreen due to Data security policy.

Is there a way to prevent that Error?

[Reeza]

The error text usually helps.

Guess off the cuff is that it's a type mismatch.

Ie your macro variable is 01June2013 and SAS is expecting a date literal instead, ie "01June2013"d

[avigdo]

TNX, so what do you advise me to do?

in the log, just before the red error message, the variable appears like that DATE'2014-02-01'

do i need to CAST that field?

[Reeza]

You've marked your question as answered so I assume your problem is resolved.

[BKST_merlin]

Try this:

%let start_of_month=01Jun2013;

Data test;

   Format date date9.;

     date="&start_of_month."d

   put date;

run;

I believe that you didn't enclose the macro reference variable in either single or double quotes so you can define it as a date variable.