topic Re: How to - Order the Variable with an Exception? in SAS Programming

How to - Order the Variable with an Exception?

turcay — Sat, 15 Oct 2016 13:29:50 GMT

Hello everyone,

I try to order my variable values. I can order by using PROC SORT but on the other hand I also want to add the values which is began "W" letter at the end of column.

Can somebody help me to order my variable?

Data Have;
Length Variable $ 20 Value 8;
Infile Datalines Missover;
Input Variable Value;
Datalines;
House 10
Car 5
Yakuza 15
Zebra 20
Home 10
W_House 5
W_Car 20
W_Yakuza 5
W_Zebra 15
W_Home 10
;
Run;

Proc Sort Data=Have;
By Variable;
Run;

My desired output as below;

Thank you

Re: How to - Order the Variable with an Exception?

Astounding — Sat, 15 Oct 2016 13:44:50 GMT

You will need to create a new variable that indicates whether the value begins with "W". For example, add to the DATA step:

group = (variable =: 'W');

Then when you sort, you can sort:

by group variable;

It's up to you whether you want to check for "W" or "W_" ... either is possible.

Re: How to - Order the Variable with an Exception?

turcay — Mon, 17 Oct 2016 08:20:27 GMT

Thank you very much. The following code worked.

Data Want;
Set Have;
Group = (Variable =:'W');
Run;

Proc Sort Data=Want;
By Group Variable;
Run;