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?
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
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?
You've marked your question as answered so I assume your problem is resolved.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.