topic Re: ODS - proc logistic - specific record from output table in ODS and Base Reporting

ODS - proc logistic - specific record from output table

julob — Thu, 30 Aug 2012 09:35:49 GMT

Hello,

I am using the following code to filter "Association of Predicted Probabilities and Observed Responses" table from proc logistic procedure output.

proc logistic data=sasuser.out040;

model default='confidence(1)'n;

ods select Association;

ods output Association=myAssocioation;

run;

Percent Concordant	76.6	Somers' D	0.582
Percent Discordant	18.4	Gamma	0.613
Percent Tied	5.0	Tau-a	0.030
Pairs	1644147	c	0.791

In output table I want to store only one parameter (Somers' D). How can I do this?

The output table looks like this. I can, of course, do it by selecting cValue2 where Label2 = Sommers' D, but I hope that SAS offers getting the value I need directly from output of logistic procedure without any dummy workarounds.

Thanks for answers!!

Re: ODS - proc logistic - specific record from output table

Haikuo — Thu, 30 Aug 2012 13:37:07 GMT

Not sure if I understand what you are after, but it seems straightforward to me using a data set option:

proc logistic data=sasuser.out040;

model default='confidence(1)'n;

ods select Association;

ods output Association=myAssocioation(where=(Label2 = "Sommers' D"));

run;

Please note, ODS displays label, not the variable name, so make sure label2 is the variable name.

Haikuo

Re: ODS - proc logistic - specific record from output table

julob — Thu, 30 Aug 2012 13:51:10 GMT

Hi Haikuo,

by your code I get whole line from output (see screenshot above). I want extract only one value. Any ideas?

Or can I somehow extract only one column from output?

Re: ODS - proc logistic - specific record from output table

PGStats — Thu, 30 Aug 2012 14:07:23 GMT

Use more dataset options...

ods output Association=myAssociation(where=(Label2 = "Sommers' D") keep=Label2 nValue2);

Re: ODS - proc logistic - specific record from output table

julob — Thu, 30 Aug 2012 14:12:42 GMT

thanks guys