topic Re: Proc Logistic output to create a dataset as shown in the tab 2 of the excel attached in Statistical Procedures

Proc Logistic output to create a dataset as shown in the tab 2 of the excel attached

gaurav21s — Tue, 18 Dec 2012 18:47:49 GMT

In the excel attached, For the 1st tab - 'Step 1" I have figured out the code via external assistanceto get the desired output but what I don't get is the way to run the logistic proc on the original data set to get the desired output as shown in the 2nd tab of the excel attached. ( exactly same format and columns). The proc logistic will include only those independent variables which have a mean > 0.02

_________________Step 1_______________________________________

proc summary data=Experiment ;

var _numeric_;

output out=means (drop=_type_ _freq_);

run;

proc transpose data=means out=vertical;

id _Stat_;

run;

proc sql ;

select _name_ into :varlist separated by ' '

from vertical

where mean > 0.02

;

quit;

%put varlist=&varlist;

_________________Step 2_______________________________________

PROC LOGISTIC DATA=?? descending;

MODEL detractor = ?? ;

RUN;

______________________________________________________________

Re: Proc Logistic output to create a dataset as shown in the tab 2 of the excel attached

Reeza — Tue, 18 Dec 2012 20:16:21 GMT

proc logistic won't give that to you by default. You'll need to manipulate the files it does provide yourself.

EDIT:

Actually, its just a sort, but if you can write the logistic code then someone can help with obtaining the output.

Do you know the logistic code to write?

Re: Proc Logistic output to create a dataset as shown in the tab 2 of the excel attached

Tom — Tue, 18 Dec 2012 23:55:26 GMT

I assume that the first ?? should be replaced with Experiment since that is the dataset you used in the previous step.

The second ?? you would want to replace with &VARLIST so that the list of variables you calculated in the first step is used.

You might need to add code to the SQL query to eliminate your dependent variable from VARLIST.

As to making the output look at the manual for PROC LOGISITIC and see what output datasets it can make. You can also look turn on ODS trace to see which of the printed outputs can be directed to datasets.

Re: Proc Logistic output to create a dataset as shown in the tab 2 of the excel attached

gaurav21s — Wed, 19 Dec 2012 04:01:24 GMT

Well, since I will be writing the code for 'proc log' for the first time, I may not be sure about the accuracy but I will try out Tom's suggestion and see how it works. My ultimate aim is to achieve a 'data set' through 'proc log' output as given below.:

Binary Variables	Coeff	SE	WS	Sig	Odds Ratio
I	1.03	0.13	60.73	1	2.8
H	0.79	0.19	17.63	0.95	2.21
A	0.57	0.14	15.74	1	1.77
K	0.98	0.1	91.16	0.97	2.67
Q	1.06	0.24	19.72	1	2.89
L	1.16	0.23	26.32	0.99	3.2
E	0.87	0.29	9.05	0.96	2.38
X	-1.02	0.12	77.34	0.98	0.36
M	0.7	0.22	10.57	0.98	2.01