topic Re: Sort issue in SAS Programming

Sort issue

hhchenfx — Tue, 07 Nov 2017 20:41:27 GMT

Hi Everyone,

I am not sure what to do with the sort below.

I just sort by var (character) and the result is:

I try to compress ( var, ". -") to eliminate these character and the sort on the variable but still doesn't help.

Can anyone tell me how to move TestPros in from of the TREX?

Many thanks.

HHC

SES

TREX- OII

TREX- TI

TestPros

VA-SP

Re: Sort issue

Reeza — Tue, 07 Nov 2017 20:53:06 GMT

Try the CASEFIRST option?

By default capital letters sort before lower case.

If case doesn't matter for order, but does matter for appearance, then I would consider creating a duplicate variable that is all one case and sorting by that.

You should also look into the Linguistic/Collating options to change the order.

But, if none of those work and you need a custom order, a format is the best approach, but it's essentially manual at that point.

Re: Sort issue

SuryaKiran — Tue, 07 Nov 2017 23:27:32 GMT

Hi,

A primary linguistic collation rule is to treat alphabetic characters equally regardless of case.

proc sort data=need sortseq=linguistic(strength=primary);;
by val ;
run;

Re: Sort issue

ChrisBrooks — Wed, 08 Nov 2017 02:08:01 GMT

If I understand you correctly you simply want TestCase to appear after SES and before TREX- Oil

Assuming I'm correct this should give you what you need

data have;
	length test $8;
	infile datalines;
	input test;
	datalines;
SES
TREX- OII
TREX- TI
TestPros
VA-SP
run;

proc sql;
	create table want
	as select test
	from have
	order by lowcase(test);
quit;

Re: Sort issue

hhchenfx — Wed, 08 Nov 2017 02:52:09 GMT

Thank you,

With all kind of option, SAS should make it simpler 🙂

HHC

Re: Sort issue

Ksharp — Wed, 08 Nov 2017 12:39:33 GMT

Maybe the following code could get you what you want.

data have;
	length test $8;
	infile datalines;
	input test;
	datalines;
SES
TREX- OII
TREX- TI
TestPros
VA-SP
run;

proc sql;
	create table want
	as select test
	from have
	order by compress(test, ,'ka');
quit;