topic Re: SAS Studio PROC SURVEYFREQ in SAS Studio

SAS Studio PROC SURVEYFREQ

RTurpin — Thu, 08 Jun 2017 17:56:48 GMT

Good afternoon all. I'm writing because I am analyzing complex survey data, and trying to run PROC SURVEYFREQ to analyze depression and anxiety by self-rated health. When I attempt to run it, SAS Studio softlocks, as it keeps waiting but never actually gets anywhere. I don't get any error screens or anything. The other survey procedures (PROC SURVEYLOGISTIC) work fine. Here is my code (though I don't think the issue is the code itself):

PROC SURVEYFREQ Data=Hlth.MHlth;
TABLES health*depression health*anxiety;

STRATA stratum;
WEIGHT fsweight;
CLUSTER psu;
TITLE "Health by Depression Tables";
RUN;

I appreciate any advice you might have on this, as I am completely stumped.

Re: SAS Studio PROC SURVEYFREQ

Reeza — Thu, 08 Jun 2017 18:22:36 GMT

Are you using SAS UE?

How big is your dataset?

Can you run the PROC SURVEYFREQ from the examples?

Re: SAS Studio PROC SURVEYFREQ

RTurpin — Thu, 08 Jun 2017 19:30:37 GMT

Thanks for the quick reply. I am using SAS University Edition, and it's a small dataset wiuth ~500 observations. Also, it seems to not work when I use the stratum and cluster statements together. If I use the weight and cluster statements, or the weight and stratum statements, it runs fine.

Re: SAS Studio PROC SURVEYFREQ

Reeza — Thu, 08 Jun 2017 19:38:47 GMT

So, SAS Studio isn't good at always throwing errors, sometimes it freezes and that's what you're running into.

There is a mistake somewhere in the logic/code, but I don't the proc well enough to comment on that portion.

Re: SAS Studio PROC SURVEYFREQ

ballardw — Thu, 08 Jun 2017 21:17:47 GMT

I think you need a TOTAL dataset on the proc statement to the total number of clusters in the population for each level of the STRATA variable.

Re: SAS Studio PROC SURVEYFREQ

RTurpin — Fri, 09 Jun 2017 05:31:29 GMT

Thanks all, I think I figured it out: PROC SURVEYFREQ just runs incredibly slowly on SAS Studio. It eventually worked after a very long wait period.

Thanks,

Rod Turpin