topic Re: How to put case count label in Proc Gplot in SAS Procedures

How to put case count label in Proc Gplot

LilyY_ — Wed, 11 Apr 2012 12:23:38 GMT

Dear all,

I have a plot produced by proc gplot. I now need to add on the case count to each data point. There are multiple cases with same value.

Does anyone know how to do this without creating new variables? I know I probably can do this by creating a new "count" variable and then use pointlabel.

Thanks in advance!

Re: How to put case count label in Proc Gplot

LilyY_ — Wed, 11 Apr 2012 14:14:09 GMT

Or any other SAS procedures can create this type of line graph?

Basically, I have about 10+ time points, I want to graph out the mean value for each time point. Every time points may have from 1 to 100 cases.

Thanks!

Re: How to put case count label in Proc Gplot

MikeZdeb — Wed, 11 Apr 2012 15:17:54 GMT

hi ... there's most likely a nice looking SG solution too, but here's one for GPLOT ...

data test;

do x = 1 to 10;

y = ceil(100*ranuni(0));

output;

if ranuni(0) lt .3 then output;

if ranuni(0) lt .2 then output;

if ranuni(0) lt .1 then output;

end;

run;

proc sql;

create view xy as select x,y,count(*) as count from test group by x,y;

quit;

goptions reset=all ftext='calibri' htext=2 gunit=pct;

symbol1 v='6c'x f='wingdings' h=2 c=blue pointlabel=(c=blue "#count");

axis1 offset=(2,2)pct;

proc gplot data=xy;

plot y*x / haxis=axis1;

run;

quit;

Re: How to put case count label in Proc Gplot

Andre — Wed, 11 Apr 2012 15:49:16 GMT

With sgplot, Mike, the minimal would be

ods graphics on;

proc sgplot data=xy;

scatter x=x y=y / datalabel=count markerattrs=(symbol=circlefilled color=blue);

run;

but i don't know yet if in sgplot the tickmarks are generated by the data or if we could regulate them by program

xaxis grid values=(1 to 10 by 1);

could render better but is limited as i don't see the possibility for minor tickmarks

Andre

Re: How to put case count label in Proc Gplot

LilyY_ — Wed, 11 Apr 2012 16:08:09 GMT

Thanks. Mike. This is what I did. I created a count variable and then use pointlabel.