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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.