topic x-axis doesn't order properly in gplot.Any Suggestions in SAS Programming

x-axis doesn't order properly in gplot.Any Suggestions

momin — Wed, 29 Oct 2014 16:15:40 GMT

proc gplot data=shareef.tra_pt_1m1;

plot mean_*day;

symbol value= star interpol=sm45;

run;

quit;

my x-axis values arein order in the columneg 3,7,15,30,90,180,360,720.

However in the plot i see it as

15,180,3,30,360,7,720

Thanks for help.

Regards

Mohammed Shareef

Re: x-axis doesn't order properly in gplot.Any Suggestions

RW9 — Wed, 29 Oct 2014 16:20:28 GMT

Perhaps sort the input data, I know that sometimes the order is implied from the appearance in the data. Alternatively, and my suggestion, move over to sgplot or GTL (these are the most up to date, and offer a great welth of customization), and explicitly specify all your axis. You can find examples at: http://blogs.sas.com/content/graphicallyspeaking/

Re: x-axis doesn't order properly in gplot.Any Suggestions

data_null__ — Wed, 29 Oct 2014 16:28:37 GMT

DAY must be character as this example demonstrates.

data mean;
   infile cards dsd; 
   input nday @@;
   day = put(nday,f8.-l);
   mean = ranuni(3);
   cards; 
3,7,15,30,90,180,360,720
;;;;
   run; 
proc gplot; 
   plot mean*day;
   plot mean*nday;
   run;

Re: x-axis doesn't order properly in gplot.Any Suggestions

GraphGuy — Tue, 20 Jan 2015 19:10:03 GMT

As data_null points out, your day values appear to be character, and the axis is therefore sorting alphabetically (rather than numerically). You could use 'proc contents' to verify that. You could add a numeric version of 'day' to your dataset (or add it in a temporary dataset), as follows...

data plot_data; set shareef.tra_pt_1m1;

day_numeric=.; day_numeric=day;

run;

proc gplot data=plot_data;

plot mean_*day_numeric;

symbol value= star interpol=sm45;

run;