The SAS Output Delivery System and reporting techniques

ODS - proc logistic - specific record from output table

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

ODS - proc logistic - specific record from output table

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 Concordant76.6Somers' D0.582
Percent Discordant18.4Gamma0.613
Percent Tied5.0Tau-a0.030
Pairs1644147c0.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.

Clipboard02.jpg

Thanks for answers!!


Accepted Solutions
Solution
‎08-30-2012 10:07 AM
Respected Advisor
Posts: 4,644

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

Use more dataset options...

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

PG

PG

View solution in original post


All Replies
Respected Advisor
Posts: 3,124

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

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

Occasional Contributor
Posts: 9

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

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?

J.

Solution
‎08-30-2012 10:07 AM
Respected Advisor
Posts: 4,644

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

Use more dataset options...

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

PG

PG
Occasional Contributor
Posts: 9

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

thanks guys

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1074 views
  • 0 likes
  • 3 in conversation