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!!!

sas-innovate-white.png

🚨 Early Bird Rate Extended!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Lock in the best rate now before the price increases on April 1.

Register now!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1122 views
  • 2 likes
  • 2 in conversation