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

[montgomerybarre]

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;

[DanH_sas]

Did you intentionally make the YAXIS to be discrete?

[montgomerybarre]

I tried discrete, linear, etc.

[ballardw]

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

[Ksharp · Accepted solution]

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

[montgomerybarre]

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

[ballardw]

---

@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.