topic Re: Using Macro Variables in Query Builder's Filter in SAS Programming

Using Macro Variables in Query Builder's Filter

avigdo — Thu, 13 Mar 2014 15:23:33 GMT

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?

Reeza — Thu, 13 Mar 2014 15:35:19 GMT

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

avigdo — Thu, 13 Mar 2014 16:11:57 GMT

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?

Reeza — Thu, 13 Mar 2014 16:18:32 GMT

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

BKST_merlin — Thu, 13 Mar 2014 16:22:55 GMT

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.