Re-Arrange Variables

[Aman4SAS]

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.

[AhmedAl_Attar]

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

Hope this helps,

Ahmed

[Keith · Accepted solution]

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;

[Aman4SAS]

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