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
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.
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.
Thank you very much. The following code worked.
Data Want;
Set Have;
Group = (Variable =:'W');
Run;
Proc Sort Data=Want;
By Group Variable;
Run;
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.