Prev: DDE error unless Excel running
Next: Announce: Roland's SAS Macros website to be reorganised
From: ManojK on 25 May 2010 03:21
Hi all,

I have a data set which has a single column and 240 rows. In each
column there are alphabets not in order. For ex.
Obs Col1
1 BA
2 CAB
3 DBCA
4 CEBAD
and so on....

Now I want to arrange this column so that in all rows alphabets should
be in ascending order
like this
Obs Col1
1 AB
2 ABC
3 ABCD
4 ABCDE
and so on.....

Please take me out of this problem.
From: ManojK on 25 May 2010 06:40
On May 25, 12:21 pm, ManojK <khandelwalmano...(a)gmail.com> wrote:
> Hi all,
>
> I have a data set which has a single column and 240 rows. In each
> column there are alphabets not in order. For ex.
> Obs Col1
> 1     BA
> 2     CAB
> 3     DBCA
> 4     CEBAD
> and so on....
>
> Now I want to arrange this column so that in all rows alphabets should
> be in ascending order
> like this
> Obs Col1
> 1     AB
> 2     ABC
> 3     ABCD
> 4     ABCDE
> and so on.....
>
> Please take me out of this problem.

It can be also seen as a matrix of 17 columns and 240 rows instead of
just 1 column. As I concatenated it to get it only in 1 column. So you
can use either way.
 | 
Pages: 1
Prev: DDE error unless Excel running
Next: Announce: Roland's SAS Macros website to be reorganised