topic Re: sgplot is not properly sequencing the y-axis in SAS Programming

sgplot is not properly sequencing the y-axis

newtriks — Wed, 06 Jul 2022 14:39:22 GMT

Here's the code -

PROC SGPLOT data=STAN.cardata;
scatter x=year y=age_adjusted_rate;
series x=year y=age_adjusted_rate;
RUN;

What I get is a straight line from lower left to upper right, with the y-axis values aligning with the year of the observation, rather than the value of the 'age adjusted rate'.

From the graph, here's a sample of the values of 'age adjusted rate' values on the y-axis from top to bottom:

2.81

2.52

2.48

2.65

3.09

3.43

.(10 additional values, also in improper order)

6.73

6.59

6.55

What am I missing?

Thanks-

Re: sgplot is not properly sequencing the y-axis

PaigeMiller — Wed, 06 Jul 2022 15:12:50 GMT

It seems to me the most likely explanation is that age_adjusted_rate is a character variable. Is it?

Can you show us the plot? (Use the "Insert Photos" icon to include your screen capture in your reply)

Re: sgplot is not properly sequencing the y-axis

newtriks — Wed, 06 Jul 2022 15:21:04 GMT

Yes, that's the answer. Thank you!