topic Re: Creating a loop for chisquare analysis in New SAS User

Creating a loop for chisquare analysis

oadeyemi — Tue, 24 Sep 2019 17:20:40 GMT

Good day everyone.

I am new to loops and macros.

So I have the task of running chi-square statistics on a series of sixteen variables

I feel I can get a more parsimonious SAS code by using loops and/or macros.

I have a series of variable X1 to X16 to run against y.

Please kindly assist.

Thanks

proc surveyfreq data=xx;
weight = wt;
strata = strata;
cluster = cluster;
tables y*x1 / chisq;
run;

Re: Creating a loop for chisquare analysis

Reeza — Tue, 24 Sep 2019 17:25:58 GMT

proc surveyfreq data=xx;
weight = wt;
strata = strata;
cluster = cluster;
tables y*(x1-x16) / chisq;
run;

Does that give you what you want?

@oadeyemi wrote:

Good day everyone.

I am new to loops and macros.

So I have the task of running chi-square statistics on a series of sixteen variables

I feel I can get a more parsimonious SAS code by using loops and/or macros.

I have a series of variable X1 to X16 to run against y.

Please kindly assist.

Thanks
proc surveyfreq data=xx;
weight = wt;
strata = strata;
cluster = cluster;
tables y*x1 / chisq;
run;

Re: Creating a loop for chisquare analysis

oadeyemi — Tue, 24 Sep 2019 17:35:51 GMT

Thank you for the response.

Yes, that can work too.

But x1 to x16 are long variable names.

I am thinking of pooling them in a local macro and use the macro for the step.

Do you understand my thought? Would it be more parsimonious?

Something like this....(note: this is not SAS format)

local a x1 x2 x3 x4 x5...x16

For each `var' in a....

....and I plug in a at

tables y*`a'

Re: Creating a loop for chisquare analysis

Reeza — Tue, 24 Sep 2019 17:49:54 GMT

No, it would not be more parsimonious, in fact it's more verbose.

Use Variable Lists of some form instead.

If you have a common prefix, or the variables are side by side this is easy.

If not, and you list the variables in a local macro variable then you would just replace my x1-x16 with the macro variable instead. And that would still be more typing and characters so again, more verbose. The solution above is the most parsimonious solution, if that's your goal.

Various methods to list variables are included here:

https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

The method you've mentioned would not be parsimonious in either R or Python, there are easier ways in those languages as well.

@oadeyemi wrote:

Thank you for the response.

Yes, that can work too.

But x1 to x16 are long variable names.

I am thinking of pooling them in a local macro and use the macro for the step.

Do you understand my thought? Would it be more parsimonious?

Something like this....(note: this is not SAS format)

local a x1 x2 x3 x4 x5...x16

For each `var' in a....

....and I plug in a at

tables y*`a'

Re: Creating a loop for chisquare analysis

PaigeMiller — Tue, 24 Sep 2019 18:06:45 GMT

@oadeyemi wrote:

Thank you for the response.

Yes, that can work too.

But x1 to x16 are long variable names.

I am thinking of pooling them in a local macro and use the macro for the step.

Do you understand my thought? Would it be more parsimonious?

Something like this....(note: this is not SAS format)

local a x1 x2 x3 x4 x5...x16

For each `var' in a....

....and I plug in a at

tables y*`a'

Typing the list of variables into a macro variable, or typing the list of variables into the PROC SURVEYSELECT as suggested by @Reeza, is equal amount of effort.

Getting a macro to work that does the looping is extra work that doesn't exist if you use PROC SURVEYSELECT as Reeza showed. I don't see what you gain by a macro.

Re: Creating a loop for chisquare analysis

oadeyemi — Tue, 24 Sep 2019 18:14:47 GMT

I agree with you.

Thanks for your explanation.

Thanks for sharing the link too.

Re: Creating a loop for chisquare analysis

oadeyemi — Tue, 24 Sep 2019 18:15:34 GMT

I agree with you.

Thank you for your explanation.

The goal is to be as parsimonious as possible.

Re: Creating a loop for chisquare analysis

Watts — Tue, 24 Sep 2019 18:27:08 GMT

proc surveyfreq data=xx;
    weight wt;
    strata strata;
    cluster cluster;
    tables y*(x1-x16) / chisq;
run;

Syntax correction. (Don't use "=" in WEIGHT, STRATA, and CLUSTER statements.)