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

Does anyone know how to modify/edit the variables appearing in the fit plots' summary box (in the output)? I want to include the p-value and standard error.

Sas_CommQ1.jpg

 

I am using:

PROC REG DATA=Test1 CORR;
MODEL Y=X / CLB P CLM;
RUN;

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

Save these statistics and Plot it by PROC SGPLOT.

 

ods output ParameterEstimates=x;
PROC REG DATA=sashelp.class CORR ;
MODEL height=weight / CLB P CLM;
quit;

proc sql ;
select catx(' ',Variable,'StdErr:',put(StdErr,8.2)) into : StdErr from x
 where Variable='Weight'
;
select catx(' ',Variable,'PValue:',put(Probt,pvalue8.2)) into : Probt from x
 where Variable='Weight'
;
quit;
proc sgplot data=sashelp.class;
reg y=height x=weight/clm;
inset "&StdErr." "&Probt.";
run;

Ksharp_0-1662892929782.png

 

View solution in original post

6 REPLIES 6
Ksharp
Super User

Save these statistics and Plot it by PROC SGPLOT.

 

ods output ParameterEstimates=x;
PROC REG DATA=sashelp.class CORR ;
MODEL height=weight / CLB P CLM;
quit;

proc sql ;
select catx(' ',Variable,'StdErr:',put(StdErr,8.2)) into : StdErr from x
 where Variable='Weight'
;
select catx(' ',Variable,'PValue:',put(Probt,pvalue8.2)) into : Probt from x
 where Variable='Weight'
;
quit;
proc sgplot data=sashelp.class;
reg y=height x=weight/clm;
inset "&StdErr." "&Probt.";
run;

Ksharp_0-1662892929782.png

 

Joa14
Obsidian | Level 7

Thank you so much, Ksharp.

 

I did try your code but it did not generate what I wanted. I found another one in this link https://support.sas.com/kb/65/202.html but the box with the summary is not shown correctly (as shown in the image). Any suggestions?Sas_CommQ2.jpg

 

Ksharp
Super User
Maybe there is not enough room for INSET.
Try add this into your SGPLOT :

yaxis min=-10;


Joa14
Obsidian | Level 7

Thank you so much, Ksharp.

I stopped using the software for several hours, and then when I tried again, it worked without putting your suggestion. However, now I get a warning that does not allow p-value and St Err to show in the summary box. As you can see in my previous graph, it worked (at least I could see the values), but now it does not. I wonder if it is a software issue. See the warning below. Any suggestion would be appreciated.

 

WARNING: Apparent symbolic reference PROBT not resolved.
229 "St Error"="&StdErr"
WARNING: Apparent symbolic reference STDERR not resolved.
DanH_sas
SAS Super FREQ

You might want want to do a "proc print data=x; run;" to make sure those parameters are in your data set.

Ksharp
Super User
As DanH said, make sure your macro variable generated correctly . To check it, open your dataset that generate these macro variable,and check if is there any obs/value to generate macro variable.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 6 replies
  • 518 views
  • 5 likes
  • 3 in conversation