topic Re: Sort a variable with two works in SAS Studio

Sort a variable with two works

sasban — Thu, 19 Oct 2017 23:58:32 GMT

I'm trying trying to sort: Week 2, Week 12, Week 16, Week 8, Week 4 in ascending order of week number, but could not get the order. Any suggestions please?

Re: Sort a variable with two works

kiranv_ — Fri, 20 Oct 2017 00:05:16 GMT

it is not very clear what you want to achieve. if you can show sample input data and result you want, someone will be able to help you

Re: Sort a variable with two works

Shmuel — Fri, 20 Oct 2017 00:11:30 GMT

It is not clear what type of variables you have.

Assuming the variable is character then you will get it sorted like:

'Week 12'
'Week 16'
'Week 2 '
'Week 4 '
'Week 8 '

in order to get it in order of the week number, you need keep the number as a separate numeric variable

to get it in order: 2 4 8 12 16.

Re: Sort a variable with two works

Reeza — Fri, 20 Oct 2017 00:52:42 GMT

You can create a new variable which is just the week number and use that’s to sort.

You can also look into the collating sequence options within PROC sort.