topic Re: Use a string as a rule for where in SAS Programming

Use a string as a rule for where

rodrigobarg — Fri, 10 May 2019 20:40:39 GMT

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

Re: Use a string as a rule for where

PeterClemmensen — Fri, 10 May 2019 20:43:18 GMT

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;

Re: Use a string as a rule for where

Jagadishkatam — Fri, 10 May 2019 20:45:11 GMT

please try

%macro teste (rule);

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

%mend teste;

%teste(%nrstr(column=23))

Re: Use a string as a rule for where

rodrigobarg — Fri, 10 May 2019 20:45:46 GMT

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

Re: Use a string as a rule for where

rodrigobarg — Fri, 10 May 2019 20:50:07 GMT

This works! Thanks!