Hello, I was looking through all discussions but couldn't find a proper answer.
The situation is that I have a bar chart and I cannot find the way to sort it out - descending or ascending.
The code I have is:
Title 'Tasks done table';
proc sgplot data=go.Tasks_done;
vbar Name / response = Total datalabel group = Total GROUPORDER= ASCENDING;
label total = 'Taks'
name = 'Names';
run;
quit;
and table 'Tasks_done' consists of:
Total Name
2000 John
3000 Tom
Result is:
So I tried to put Descending or Ascending in code, but I couldn't. Lastly I figured out I need to have group option so then I can use Grouporder = ascending/descending. But my chart is not affected...The I read something about changing axis type (because as I understood I need axis to be 'Discrete' type or something like that.) But when I get deeper, it is getting more and more complicated. Can someone help me out with this?? If possible, could You alter my code or show examples so I could understand it better how to do this thing, cuz I am really stuck for some time with this,
Thank You!
You could use a XAXIS statement with option REVERSE or option DISCRETEORDER=DATA and sort accordingly. - PG
You could use a XAXIS statement with option REVERSE or option DISCRETEORDER=DATA and sort accordingly. - PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.