I am trying to create a log graph using proc template. I have zero value in some variables. when I run the following I am getting a 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.
I tried options changing the values from zero to 1 (@rick_sas), I am still getinng the same note. Any advise on this please. I used proc template so far. So I was comfortable using. if no option left may be will go with SGPLOT( new to this).
data mean;
input trtan time mean sd;
cards;
1 0 0 0
1 1 2.5 0.8
1 3 5 1.6
1 6 10 3.2
2 0 0 0
2 1 2.8 0.7
2 3 3.3 1.2
2 6 5.3 1.4
;
run;
data mean1;
set mean;
lower = MEAN - sd;
upper = MEAN + sd;
if mean=0 then do;
mean=.;
sd=.;
end;
run;
ods path(prepend) work.templat(update);
proc template;
define statgraph series;
begingraph/ BORDER=False datasymbols=( circle Asterisk) ;
layout lattice / rowdatarange=data columndatarange=data rowgutter=10 columngutter=10;
layout overlay / xaxisopts=( label=('time') tickvalueattrs=(family='Courier New' size=8 ) labelattrs=(family='Courier New' size=8 )
linearopts=( viewmin=1 viewmax=6 tickvaluesequence=( start=1 end=6 increment=1)))
yaxisopts=( label=('time)') labelattrs=(family='Courier New' size=8 ) tickvalueattrs=(family='Courier New' size=8 )
type=log
linearopts=( viewmin=1 viewmax=10 tickvaluesequence=( start=0.0 end=10 increment=1)));
seriesplot x=time y= MEAN / group=sex name='series' display=(markers) connectorder=xaxis ;
scatterplot x=time y= MEAN / yerrorupper = upper yerrorlower = lower group=trtan name='scatter';
discretelegend 'series' / opaque=false border=true halign=right valign=top displayclipped=true across=2 order=rowmajor location=inside titleattrs=(family='Courier New' size=8 );
endlayout;
endlayout;
endgraph;
end;
run;
ods graphics on/ width=9 in height=4.6 in ;
options orientation = landscape errors = 2 missing = ' ' nofmterr ls = 175 validvarname = upcase nofmterr nobyline
noquotelenmax ;
ods escapechar = '^';
ods results on;
ods listing close;
ods rtf file = "\&location\chk1.rtf"
style = rtf nogtitle nogfootnote;
proc sgrender data=mean1 template=series;
run;
ods rtf close;
ods listing close;
