topic Re: Association table with % discordant is not being output. It should be model default? How to do? in Statistical Procedures

Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Wed, 28 Jul 2021 19:59:42 GMT

SAS CODE:

ods select ClassLevelInfo ConvergenceStatus GoodnessOfFit LackFitChiSq
ParameterEstimates clparmPL
OddsRatiosPL OddsRatiosWald
FitStatistics GlobalTests association ;
proc logistic data=xmatrix alpha=.05 ;
model dfree (event="0") = age ivhx1 ndrugtx treat / clparm=pl clodds=pl
lackfit aggregate gof rsquare influence scale=none expb;
run; quit;

Thanks. MM

Re: Association table with % discordant is not being output. It should be model default? How to do?

PaigeMiller — Wed, 28 Jul 2021 19:55:42 GMT

Are there any warnings or errors in the log? If so, show us the log (all of it, not just the warnings or errors)

Re: Association table with % discordant is not being output. It should be model default? How to do?

ballardw — Wed, 28 Jul 2021 19:58:05 GMT

What does your log show?

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Wed, 28 Jul 2021 20:17:11 GMT

Two problems here:

1. I only want summary data, not all step output

2. association of predicted probabilities and observed responses table is not output.

I hope the log file makes it this time.

Thank you.

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Wed, 28 Jul 2021 20:18:21 GMT

see attached. thank you. MM

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Wed, 28 Jul 2021 21:14:05 GMT

I found the table. It looks like I need to do something about the extra step output. Sorry. thank you. MM

Re: Association table with % discordant is not being output. It should be model default? How to do?

StatDave — Wed, 28 Jul 2021 20:38:11 GMT

Look more closely at your log and the ODS TRACE results. Notice that Step 5 is the last step, not Step 4. Also notice that the Association table does not have "Step" in its Path designation. So, if you want all of the tables from the last Step and the Association table, then you would specify:

ods select where = (_path_ ? 'Step5') association;

Re: Association table with % discordant is not being output. It should be model default? How to do?

ballardw — Wed, 28 Jul 2021 20:39:18 GMT

@MaryA_Marion wrote:

see attached. thank you. MM

The ODS TRACE output shows that the Association table was created. Are you asking about getting the results into a data set? That would require adding an ODS OUTPUT statement. Not all of the stuff that appears in the results can be captured by the procedure OUTPUT statement.

If you want the Association table information in a data set add:

ODS OUTPUT Association=work.assoc;

That should create a data set named work.assoc with the information from the association table.

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Thu, 29 Jul 2021 13:48:17 GMT

Thank you. That did help. After many tries, I figured out that excluding
tables works better than ODS include statement. I finally have something I
can use now. MM

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Thu, 29 Jul 2021 13:57:59 GMT

The abundance of output and a time deadline was a bad combination. After many tries and rereads of logs I came up with the following:

ods exclude 
Nobs
where = (_path_ ? 'Step0') 
where = (_path_ ? 'Step1')
where = (_path_ ? 'Step2')
where = (_path_ ? 'Step3')
where = (_path_ ? 'Step4')

it is simple and much less problematic than trying to include tables which never were included the way I wanted. Thanks to all of you. This was a critical topic for me. MM

Re: Association table with % discordant is not being output. It should be model default? How to do?

MaryA_Marion — Thu, 29 Jul 2021 14:58:17 GMT

Too much output; I found it. I also only use the ods exclude statement now.
It is working much better. Thank you very much for your help. MM