topic Re: Conditional output multiple data within macro in SAS Programming

Conditional output multiple data within macro

inyli — Wed, 08 Jan 2020 20:58:15 GMT

Hi, I'm doing conditional datasets output within a SAS macro:

I already had work.other dataset.

%macro m(w);

data dat1 dat2;

set other; w = &w.;

if diff le &w. then output dat1;

else output dat2; run;

%mend;

It works when I run without the "%macro"

But, when I call the macro by doing "%m(1);", I got an error saying something wrong with the "set":

Statement is not valid or it is used out of proper order.

Thoughts? Thanks!

Re: Conditional output multiple data within macro

PaigeMiller — Wed, 08 Jan 2020 21:05:55 GMT

As the first line of your program, use

options mprint;

Then run the program again, and see if the LOG is more clear and helps you figure out what you did wrong.

If you can't understand what it is telling you, then please copy the log as text (the code AND the error messages) and — DO NOT SKIP THIS STEP — paste it into the window that appears when you click on the {i} icon.

Re: Conditional output multiple data within macro

Kurt_Bremser — Thu, 09 Jan 2020 06:24:45 GMT

... and don't forget to accept an answer as solution in https://communities.sas.com/t5/SAS-Programming/Enumerate-unique-value-by-group/m-p/615834

Re: Conditional output multiple data within macro

inyli — Thu, 09 Jan 2020 13:22:04 GMT

Thanks! I got my problem solved.