topic Re: PROC SURVERYLOGISTIC Alternative? in SAS Procedures

PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 15:27:47 GMT

Hey guys,

So I am doing some multiple imputation. As some of you know, there are three steps to this. The second step requires use of PROC SURVERYLOGISTIC. I think it's main role is to save the parameter estimates for the final step. Is there an alternative to using it so i can accomplish all three steps?

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 15:30:36 GMT

I don't think that's the only thing that SURVEYLOGISTIC does, but I think it unlikely that some other combination of data step and PROCs will get the same results — unless you are willing to do a large amount of programming.

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 15:43:24 GMT

I did just the first step of the three step imputation process (which did fill in the values)..and did perfectly well when I fit the train data to the validation. (a bit over 80% accuracy)...so not sure..are the three steps always necessary?

Re: PROC SURVERYLOGISTIC Alternative?

ballardw — Fri, 26 Apr 2019 15:46:43 GMT

Are talking about using Proc MI or some other process?

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 15:57:58 GMT

Yes, I used proc mi to impute based on all the guidelines. But then couldn't do the second step.

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 16:43:00 GMT

You have left out some important details.

But then couldn't do the second step.

Why not? What did you try to do? What stopped you? What happened?

And also: what exactly is the second step, anyway? Give us the details.

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 16:50:31 GMT

Hi Paige,

I am following the procedures in a book called 'Multiple Imputation of missing data using SAS'. The first requires use of proc mi (which I have access to). Here is an example:

proc mi nimpute=3 data=c7_ex1 seed=55 out=c7_ex1_imp;
class racecat gender edcat selfrhealth diabetes arthritis stratum_secu;
fcs plots=trace(mean(bodywgt)) nbiter=20 logistic (edcat diabetes arthritis)
   discrim(racecat=gender edcat selfrhealth diabetes arthritis
   /classeffect=include) regression (bodywgt);
var stratum_secu kwgtr kage gender racecat edcat diabetes arthritis bodywgt
   selfrhealth;
run;

The second step however requires use of proc surveylogistic which I don't have access to. To do this aspect:

proc surveylogistic data=c7_ex1_imp;
weight kwgtr; strata stratum; cluster secu;
by _imputation_;
class racecat gender edcat selfrhealth / param=ref;
model diabetes (event='1')=gender racecat selfrhealth bodywgt;
ods output parameterestimates=c7_ex1_est;
run;

proc print data=c7_ex1_est;
run ;

The final step requires proc mianalyze which I have:

proc mianalyze parms(classvar=classval)=c7_ex1_est edf=56;
class racecat gender selfrhealth;
modeleffects intercept gender racecat selfrhealth bodywgt;
run;

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 16:59:12 GMT

This was not obvious when you originally stated your problem.

However, if you have PROC MI, you should have PROC SURVEYLOGISTIC, they are both part of SAS/STAT.

What happens when you try to use PROC SURVEYLOGISTIC?

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 17:02:10 GMT

I'm using a software called WPS that does not have access to this..at least not yet.

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 17:05:22 GMT

Well, there really is no replacement for PROC SURVEYLOGISITIC, unless you want to do a large amount of programming.

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 17:48:45 GMT

Can't I just use this solution?

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

Use ODS TRACE ON (or the SAS documentation) to find the name of the ODS table that contains the statistic that you want.
Use the ODS OUTPUT statement to specify the table name and a data set name. The syntax is ODS OUTPUT TableName=DataSetName. Then run the procedure to generate the table.
Read the data set to obtain the value of the statistic.

I know that proc surveylogistic does many things but I think in my context, all I need really is to have some way to store the parameter estimates so that they can be read in the final step of multiple imputation (by proc mianalyze, which I have)

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 17:51:36 GMT

ODS OUTPUT can collect the results from PROC SURVEYLOGISTIC, which means you have to run PROC SURVEYLOGISTIC, but you have told me you can't.

Re: PROC SURVERYLOGISTIC Alternative?

edasdfasdfasdfa — Fri, 26 Apr 2019 18:07:27 GMT

Would you be able to tell me if it is totally unnecessary to use proc surveylogistic (for missing values) unless you are using survey data?

Re: PROC SURVERYLOGISTIC Alternative?

PaigeMiller — Fri, 26 Apr 2019 18:19:45 GMT

At this point, I would like you to describe the problem and the analysis in detail. I feel I have been guessing at a lot of things.

Re: PROC SURVERYLOGISTIC Alternative?

ballardw — Fri, 26 Apr 2019 19:22:35 GMT

@edasdfasdfasdfa wrote:

Hi Paige,

I am following the procedures in a book called 'Multiple Imputation of missing data using SAS'. The first requires use of proc mi (which I have access to). Here is an example:

proc mi nimpute=3 data=c7_ex1 seed=55 out=c7_ex1_imp;
class racecat gender edcat selfrhealth diabetes arthritis stratum_secu;
fcs plots=trace(mean(bodywgt)) nbiter=20 logistic (edcat diabetes arthritis)
   discrim(racecat=gender edcat selfrhealth diabetes arthritis
   /classeffect=include) regression (bodywgt);
var stratum_secu kwgtr kage gender racecat edcat diabetes arthritis bodywgt
   selfrhealth;
run;

The second step however requires use of proc surveylogistic which I don't have access to. To do this aspect:

Procs MI and Surveylogistic are both part of SAS/STAT. If one is installed the other should be as well. Why do you not have access to Surveylogistic?

Re: PROC SURVERYLOGISTIC Alternative?

SuzanneDorinski — Fri, 26 Apr 2019 22:08:08 GMT

The only survey proc listed in the WPS documentation is SURVEYSELECT.