Hello everyone,
I have a variable Region (which is a number from 1 to 6). I have added a format like so:
[pre]PROC FORMAT library=PROJET.FORMATS;
value $Region
1='Pacific' 2='Americas' 3='Oceania' 4='Middle East' 5='Asia' 6='Africa';
RUN;[/pre]
I want to sort them alphabetically (Africa, Americas, ... , Pacific) and not numerically by ID (Pacific, Americas, ... Africa). I have typed this:
[pre]proc sort data=TEMP; format Region $Region.; by Region; run;
proc sort data=TEMP; by Region; run;[/pre]
...and looked here:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000146878.htm
...but no luck. Any ideas? Apparently there's simply an option in SAS to do that.
Thank-you in advance