BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MaryA_Marion
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

@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.

View solution in original post

10 REPLIES 10
PaigeMiller
Diamond | Level 26

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

--
Paige Miller
MaryA_Marion
Lapis Lazuli | Level 10

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.

MM

StatDave
SAS Super FREQ

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;
MaryA_Marion
Lapis Lazuli | Level 10

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 

ballardw
Super User

@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.

MaryA_Marion
Lapis Lazuli | Level 10
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
MaryA_Marion
Lapis Lazuli | Level 10

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

MaryA_Marion
Lapis Lazuli | Level 10
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 10 replies
  • 3029 views
  • 2 likes
  • 4 in conversation