Use a string as a rule for where

[rodrigobarg]

Hi,

I have a macro function, as in the example

%macro teste (rule);

   Data example;

   set source;

   where &rule.

   run;

%mend teste;

%teste("COLUMN = 23");

So I want to use the string "COLUMN = 23" as a text for the WHERE rule. Is it possible? Or is there another way to do it in SAS (i.e. so I can change the rule in a macro variable, for example).

Thanls

[PeterClemmensen]

Yes it is possible. Did you try to run your code? What went wrong?

As I see it you are missing a semicolon

%macro teste (rule);
   Data example;
   set source;
   where &rule.;
run;

[rodrigobarg]

Sorry, I added the semicollon, but I still get a syntax error...

[Jagadishkatam · Accepted solution]

please try

%macro teste (rule);

   Data example;
   set source;
   where &rule.
   run;

%mend teste;

%teste(%nrstr(column=23))

[rodrigobarg]

This works! Thanks!