topic Re: Graph showing 'unknown' instead of values in Graphics Programming

Graph showing 'unknown' instead of values

AncaTilea — Tue, 16 Apr 2013 15:19:27 GMT

Hi.

Did any one of you encounter a situation where SAS renders a graph showing "unknown" instead of the true values?

Please see attached.

And the code that creates:

	ods graphics / reset width=5in imagename="Cancer" imagefmt=png
	antialias=on;

title "Prevalence of Something Bad";

proc sgplot data=my_data;

	series x=year y=something_bad_avg / markers;
	yaxis values=(0 to .5 by .1);
	xaxis values=(2000 to 2011 by 1);

run;

Any idea what would cause this?

Thanks.

Actually, to be more concise, is not the plot procedure that causes the problem...but the proc means output lists "unknown" as possible values....

See another attachment.

Re: Graph showing 'unknown' instead of values

PGStats — Tue, 16 Apr 2013 15:27:30 GMT

What is the format attached to variable something_bad_freq in my_data?

Re: Graph showing 'unknown' instead of values

AncaTilea — Tue, 16 Apr 2013 15:32:38 GMT

Hi.

So, in the first step there is a proc means on the data, by year, that will list the average of a variable for each year.

That said average is then plotted.

So, the format is a number.

Re: Graph showing 'unknown' instead of values

PGStats — Tue, 16 Apr 2013 15:44:28 GMT

Try adding option NOINHERIT to your OUTPUT statement in proc means.

Re: Graph showing 'unknown' instead of values

AncaTilea — Tue, 16 Apr 2013 16:00:34 GMT

I shall try, and let you know.

Thank you!

Re: Graph showing 'unknown' instead of values

AncaTilea — Tue, 16 Apr 2013 17:57:15 GMT

Thank you, Pierre.

It worked great. It was the format....

Thanks!