topic Re: short code to rearrange variables? in SAS Programming

short code to rearrange variables?

ubshams — Mon, 31 Aug 2020 17:38:52 GMT

my data set has following variables

x1 x2 x3 x4....x100 Month

How do I rearrange so that the following happens:

Month x1 x2 x3 x4....x100

In other words I need to rearrange so that Month is the first column. But I don't want to have to write down all other

100 variables (i actually have over 7,000 variables).

Thanks in advance!

Re: short code to rearrange variables?

Reeza — Mon, 31 Aug 2020 17:55:03 GMT

Here is a reference that illustrates how to refer to variables and datasets in a short cut list:
https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

data want;
retain month x1-x100;
set have;
run;

@ubshams wrote:

my data set has following variables

x1 x2 x3 x4....x100 Month

How do I rearrange so that the following happens:

Month x1 x2 x3 x4....x100

In other words I need to rearrange so that Month is the first column. But I don't want to have to write down all other

100 variables (i actually have over 7,000 variables).

Thanks in advance!

Re: short code to rearrange variables?

Astounding — Mon, 31 Aug 2020 19:00:43 GMT

With 7,000 variables, I'm imagining that they are not necessarily named x1-x7000. You can shortcut the code and move MONTH to the first position just using:

data want;
retain month;
set have;
run;