topic Re: How to insert p-value in summary box of fit plots? in Graphics Programming

How to insert p-value in summary box of fit plots?

Joa14 — Sun, 11 Sep 2022 04:04:37 GMT

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.

I am using:

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

Thanks!

Re: How to insert p-value in summary box of fit plots?

Ksharp — Sun, 11 Sep 2022 10:42:01 GMT

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;

Re: How to insert p-value in summary box of fit plots?

Joa14 — Mon, 12 Sep 2022 05:38:48 GMT

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?

Re: How to insert p-value in summary box of fit plots?

Ksharp — Mon, 12 Sep 2022 10:46:00 GMT

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

yaxis min=-10;

Re: How to insert p-value in summary box of fit plots?

Joa14 — Mon, 12 Sep 2022 15:09:04 GMT

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.

Re: How to insert p-value in summary box of fit plots?

DanH_sas — Mon, 12 Sep 2022 16:51:07 GMT

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

Re: How to insert p-value in summary box of fit plots?

Ksharp — Tue, 13 Sep 2022 11:59:31 GMT

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.