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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.