Help using Base SAS procedures

Re-Arrange Variables

Accepted Solution Solved
Reply
Super Contributor
Posts: 266
Accepted Solution

Re-Arrange Variables

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.


Accepted Solutions
Solution
‎11-19-2013 07:35 AM
Regular Contributor
Posts: 151

Re: Re-Arrange Variables

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;

View solution in original post


All Replies
Regular Contributor
Posts: 219

Re: Re-Arrange Variables

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

Hope this helps,

Ahmed

Solution
‎11-19-2013 07:35 AM
Regular Contributor
Posts: 151

Re: Re-Arrange Variables

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;

Super Contributor
Posts: 266

Re: Re-Arrange Variables

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 205 views
  • 0 likes
  • 3 in conversation