03-13-2014 11:23 AM
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?
03-13-2014 11:35 AM
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
03-13-2014 12:11 PM
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?
03-13-2014 12:22 PM
Format date date9.;
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.