topic Re: Using macro for Kruskal Wallis test in SAS Programming

Using macro for Kruskal Wallis test

aayo — Thu, 16 Apr 2020 07:23:57 GMT

Hello,

Please help.

I am trying to use macro for non-parametric test but I get warning below.

%let numgroups=9;

%let dataname=d;

%let obsvar=a;

%let group=B;

%let alpha=0.05;

title "Nonparametric test to examine the effect of B on a";

run;

/*invoke the KW_MC macro*/

%KW_MC(source=&dataname, groups=&numgroups, obsname=&obsvar, gpname=&group, sig=&alpha);

705 %KW_MC (source=&dataname, groups=&numgroups, obsname=&obsvar, gpname=&group, sig=&alpha);

180

WARNING: Apparent invocation of macro KW_MC not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order

my normal working code is

proc npar1way
data=d;
title "Nonparametric test to examine the effect of B on a";
class B;
var a;

run;

Shmuel — Thu, 16 Apr 2020 08:05:09 GMT

Macro KW_MC should be either compiled and saved in a SAS catalog or invoked

for compilation from a folder by:

%include <path and folder name>(KW_MC.sas);

You can use the macro only after compilation, by %KW_MC(...);

kelxxx — Thu, 16 Apr 2020 08:05:25 GMT

Hi,

Can you verify your code %macro .. %mend;

because SAS don't know %KW_MC

I think that this macro is not successfully compiled

Have a nice day.

aayo — Thu, 16 Apr 2020 22:10:48 GMT

how do I go about it? Below is my working code.

proc npar1way
data=x;
title "Nonparametric test to examine the effect of B on A";
class B;
var A;

run;

aayo — Fri, 17 Apr 2020 00:27:14 GMT

I finally pulled through. Below is my working macro code.

%macro KW_MC (obsvar,classvar,dataname,alpha);
proc npar1way
data=&dataname;

class &classvar;
var &obsvar;
run;
%mend;
/*invoke the KW_MC macro*/
%KW_MC(obsvar= x, classvar= y, dataname=a , alpha=0.05);