topic Re: Macro not working in SAS Programming

Macro not working

jcis7 — Tue, 17 Mar 2015 15:57:18 GMT

Hi, I'm new to macros and cannot figure out why this doesn't work:

I have a bunch of questions I'm running the chi-square test on comparing two groups so I'm trying to create a macro.

The question names are:

q1_volun

q1_sec

etc....

I ran the code without the macro and it worked fine using the question names.

center pagesize=45 nonumber nodate symbolgen;

%macro analysis(question);

proc freq data=q1;

tables group*&question./chisq;

title "&question. - Chi-Sq - verifies info";

run;

%mend analysis;
%analysis (q1_vol);

%analysis (q1_sec);

Any help you can give is much appreciated! Thanks!

Re: Macro not working

RW9 — Tue, 17 Mar 2015 16:01:35 GMT

Hi,

You would need to be more specific, what doesn't work, what errors/warnings in the log, maybe also what data are you using, provide a datastep with some test data. The code seems fine.

Re: Macro not working

Astounding — Tue, 17 Mar 2015 16:18:24 GMT

The macro looks fine, especially if the same code ran without using a macro. One thing is suspect, though. You have a line:

center ... symbolgen;

These are options, so the word OPTIONS should be there:

options center ... symbolgen;

Could that be the problem?

Re: Macro not working

jcis7 — Tue, 17 Mar 2015 17:25:53 GMT

Thank you everyone! I closed out SAS and opened it and it miraculously worked.

Re: Macro not working

Haikuo — Tue, 17 Mar 2015 17:34:57 GMT

If you don't want to restart your SAS, here is some magic strings sometimes may work for you:

*))%*))*/;

;;;;

%mend;

options notes;

run cancel; quit;

proc unk; run;

Haikuo