topic Re: Re-Arrange Variables in SAS Procedures

Re-Arrange Variables

Aman4SAS — Tue, 19 Nov 2013 11:41:59 GMT

After Many operation i have a dataset with variable in diff order.

I want to re-arrange order of Variable in dataset.

Can we Do it....

Example

NAME AGE SEX (Current order )

NAME SEX AGE(Desired Order)

* i want to change in my dataset not in output or result.

Re: Re-Arrange Variables

AhmedAl_Attar — Tue, 19 Nov 2013 12:11:33 GMT

Use the LENGTH statement within your data set. It's the best way to arrange your variables/columns.

Hope this helps,

Ahmed

Re: Re-Arrange Variables

Keith — Tue, 19 Nov 2013 12:35:08 GMT

There are many ways to reorder variables in a dataset (a simple Google search will give you these), the important thing to note is that you need to replace the existing dataset (i.e. you can't just change the descriptor portion in something like PROC DATASETS).

My favourite method is to use the RETAIN statement before you read in the data, this way you don't need to know any of the variable attributes (type, length etc), just the names).

Here is an example

data class;

retain sex age height weight name;

set sashelp.class;

run;

Re: Re-Arrange Variables

Aman4SAS — Tue, 19 Nov 2013 12:59:57 GMT

Thanks.... it works in nice way........