DATA Step, Macro, Functions and more

Using Macro Variables in Query Builder's Filter

Reply
New Contributor
Posts: 3

Using Macro Variables in Query Builder's Filter

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?

Super User
Posts: 19,778

Re: Using Macro Variables in Query Builder's Filter

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

New Contributor
Posts: 3

Re: Using Macro Variables in Query Builder's Filter

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?

Super User
Posts: 19,778

Re: Using Macro Variables in Query Builder's Filter

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

N/A
Posts: 1

Re: Using Macro Variables in Query Builder's Filter

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. 

Ask a Question
Discussion stats
  • 4 replies
  • 1109 views
  • 0 likes
  • 3 in conversation