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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.