topic Re: Move a certain column to the end/beginning without knowing the rest of columns in SAS Enterprise Guide

Move a certain column to the end/beginning without knowing the rest of columns

ayin — Wed, 29 Mar 2017 02:11:13 GMT

Original dataset:

Type Class ... Total ... Category

1. Need to move the column 'Total' to the end without changing the order for the rest of columns.

The result looks like:

Type Class ... Category Total

2. Need to move the column 'Total' to the beginning without changing the order for the rest of columns.

Total Type Class ... Category

Requirements:

Hard-coding like

retain ColA ColB ... ColZ Total;

wouldn't work because we wouldn't know the names for the rest of the columns or how many columns there are (they are dynamic).

Thank you.

Tom — Wed, 29 Mar 2017 02:23:29 GMT

Use the KEEP= and/or DROP= dataset options.

data one ;
  set have (drop=Total);
  set have ;
run;

data two;
  set have (keep=Total);
  set have ;
run;

ayin — Wed, 29 Mar 2017 02:33:32 GMT

That's super smart! Thank you.