topic plot using SGPLOT with Series statement for Semilog scale in Statistical Procedures

plot using SGPLOT with Series statement for Semilog scale

shampras — Tue, 13 Feb 2018 07:34:33 GMT

Hi,

I got the below message when used SGPLOT with Series statement to create PK graph.

NOTE: The log axis cannot support zero or negative values for the axis from plot data or due to default or

assigned BASELINEINTERCEPT value. The axis type will be changed to LINEAR.

it is not creating the y-axis in log scale.

Below is the code I used.

proc sgplot data=pkmean dattrmap=test noborder ;

series x = pktime1 y =meancmax/ group=column attrid=X markers;

xaxis label = 'Time (hr)' values = (0 to 60 by 10) minor MINORCOUNT=1;

yaxis label = 'Concentration (ng/mL)' values = ( 1 10 100 1000 10000) type=log logbase=10 logstyle=logexpand ;* minor MINORCOUNT=8 ;

keylegend / title="Concentration Vs. Time" location=inside position=TOPRIGHT across=1 down=2 noborder;

run;

Please let me know if you are aware of resolving this issue.

Thanks

Re: plot using SGPLOT with Series statement for Semilog scale

PeterClemmensen — Tue, 13 Feb 2018 07:42:13 GMT

Haven't seen your data, so I can't tell you if this is the only problem..

But when you use values = (0 to 60 by 10) in the XAXIS Statement and also use type=log in the YAXIS Statement you are effectively asking SAS to take log10(0), which is not defined.

Re: plot using SGPLOT with Series statement for Semilog scale

Rick_SAS — Tue, 13 Feb 2018 13:15:36 GMT

This is a data issue. One of your observations have meancmax=0.

You can use

WHERE meancmax > 0;

to plot only the valid values, or change the scaling on your Y axis.

To illustrate, run the following program. The NOTE appears. However, change the first DO loop to "do group=1 to 3" and the NOTE will no longer appear.

data A;
do group = 0 to 3; /* change to 1 to 3 to make NOTE go away */
 do x=1 to 60;
 y = group*x**2;
 output;
 end;
end;
run;

proc sgplot data=A noborder;
 series x=x y=y / group=group markers;
 xaxis label = 'Time (hr)' values = (0 to 60 by 10) minor MINORCOUNT=1;
 yaxis label = 'Concentration (ng/mL)' values = ( 1 10 100 1000 10000) 
 type=log logbase=10 logstyle=logexpand ;* minor MINORCOUNT=8 ;
 keylegend / title="Concentration Vs. Time" location=inside position=TOPRIGHT across=1 down=2 noborder;
run;

Re: plot using SGPLOT with Series statement for Semilog scale

shampras — Wed, 14 Feb 2018 00:58:35 GMT

Hi Rick,
It worked. I appreciate your timely help.

Thanks,
Syam