04-25-2018 04:13 PM
Does your data set contain a variable named MONTH? If so, what's in it?
You might want to add a similar variable for the YEAR. Probably, you would want December 2017 to sort earlier than January 2018, so you would need both the month and year.
So what do you have already?
04-25-2018 07:28 PM
my below data table has month and counts. month data displays dynamically it changes every month. To create SG Plot group graph i am transpose the data. To do transpose by month it gives error as sort the month. once i sorted the month is displaying in alphabetic order and my graph x asis names are displaying in same order. I am expecting the month order should be jan,feb and march
proc sort data=dash.three_Month_Trend2;
proc transpose data=dash.three_Month_Trend2 out=dash.three_Month_Trend2;
set dash.three_Month_Trend2 (rename=(col1=count));
drop _NAME_ _LABEL_;
04-25-2018 07:43 PM
January, February would be sorted alphabetically.
Either convert to numeric, use IF/THEN statements and apply a format or consider using a SAS Date instead of the value 'January'.
If it's a SAS date with the MonNAME. format it will still show as January.