BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
PamG
Quartz | Level 8

Is there a way to save results from ESTIMATE statement to a file?  I have a product of 2 multi-category  variables and would like to plot the estimates on a graph.  Attaching a code for sample data. 

data Neuralgia;
   input Treatment $ Sex $ Age Duration Pain $ @@;
   datalines;
P  F  68   1  No   B  M  74  16  No  P  F  67  30  No
P  M  66  26  Yes  B  F  67  28  No  B  F  77  16  No
A  F  71  12  No   B  F  72  50  No  B  F  76   9  Yes
A  M  71  17  Yes  A  F  63  27  No  A  F  69  18  Yes
B  F  66  12  No   A  M  62  42  No  P  F  64   1  Yes
A  F  64  17  No   P  M  74   4  No  A  F  72  25  No
P  M  70   1  Yes  B  M  66  19  No  B  M  59  29  No
A  F  64  30  No   A  M  70  28  No  A  M  69   1  No
B  F  78   1  No   P  M  83   1  Yes B  F  69  42  No
B  M  75  30  Yes  P  M  77  29  Yes P  F  79  20  Yes
A  M  70  12  No   A  F  69  12  No  B  F  65  14  No
B  M  70   1  No   B  M  67  23  No  A  M  76  25  Yes
P  M  78  12  Yes  B  M  77   1  Yes B  F  69  24  No
P  M  66   4  Yes  P  F  65  29  No  P  M  60  26  Yes
A  M  78  15  Yes  B  M  75  21  Yes A  F  67  11  No
P  F  72  27  No   P  F  70  13  Yes A  M  75   6  Yes
B  F  65   7  No   P  F  68  27  Yes P  M  68  11  Yes
P  M  67  17  Yes  B  M  70  22  No  A  M  65  15  No
P  F  67   1  Yes  A  M  67  10  No  P  F  72  11  Yes
A  F  74   1  No   B  M  80  21  Yes A  F  69   3  No
;


proc logistic data=Neuralgia;
   class Treatment Sex /param=ref;
   model Pain= Treatment Sex Age ;
     estimate 'Pairwise B vs P' Treatment 0  1 / exp CL;
    estimate 'Pairwise A vs B' Treatment 1 -1 / exp CL;
    estimate 'Female vs Male' Sex 1 / exp CL;

run;
1 ACCEPTED SOLUTION

Accepted Solutions
yabwon
Onyx | Level 15

how about adding ODS output statement:

ods output Estimates=work.E;
proc logistic data=...
...
run;

before proc logistic, and then to use data from WORK.E dataset?

 

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



View solution in original post

4 REPLIES 4
PamG
Quartz | Level 8

I can't edit my original post here are more details.

 

I can't use effectplot.  I am doing a conditonal logit and have interaction effect between a time-invariant and time varying covariate.  Hence I need to use the ESTIMATE to calculate the effect sizes.

PROC LOGISTIC;

STRATA=id,

MODEL outcome(EVENT='1')=bmi bmi*race;

RUN;

PamG
Quartz | Level 8

I missed the CLASS statement.

 

PROC LOGISTIC;

STRATA=id,

CLASS race;

MODEL outcome(EVENT='1')=bmi bmi*race;

RUN;

yabwon
Onyx | Level 15

how about adding ODS output statement:

ods output Estimates=work.E;
proc logistic data=...
...
run;

before proc logistic, and then to use data from WORK.E dataset?

 

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



PamG
Quartz | Level 8

Perfect!  This works beautifully.  I could not find any documentation on this.  I guess I was not looking in the right place.  Thank you so so much!!!

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 458 views
  • 1 like
  • 2 in conversation