topic Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis? in Graphics Programming

Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

montgomerybarre — Fri, 08 Dec 2023 23:55:46 GMT

I haver never had this issue before, seems like no matter what I try, sgplot is forcing this diagonal line. I have tried sorting the data in different ways, using different yaxis, xaxis, and discreteorder options, the scatter, series, and other statements... etc. All producing the same problem.

proc sgplot data=final ;
scatter x=month_year y=rate / group=state;
yaxis type=discrete;
run;

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

DanH_sas — Sat, 09 Dec 2023 00:01:47 GMT

Did you intentionally make the YAXIS to be discrete?

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

montgomerybarre — Sat, 09 Dec 2023 00:06:24 GMT

I tried discrete, linear, etc.

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

ballardw — Sat, 09 Dec 2023 00:20:26 GMT

If you can't share an example of your actual data then show us the complete output for Proc Contents for the data set.

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

Ksharp — Sat, 09 Dec 2023 10:07:22 GMT

Make sure your variable "rate " is NUMERIC tpye ,not CHARACTER.

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

montgomerybarre — Mon, 11 Dec 2023 19:21:04 GMT

Yup, the variable was somehow read in as character. Dumb mistake, thanks all!

Re: Every plot I make in proc SGPLOT forces a diagonal line via odd sorting of y axis?

ballardw — Mon, 11 Dec 2023 19:38:06 GMT

@montgomerybarre wrote:

Yup, the variable was somehow read in as character. Dumb mistake, thanks all!

Proc import or other "import" widget perhaps? From spreadsheet? All it takes is a very common two or more header row for a column to make character values with Import.