topic Re: placing created column in specific position in SAS Procedures

placing created column in specific position

chemicalab — Tue, 19 Apr 2011 09:34:52 GMT

Hi all,

Ok maybe my question is simple but i cant seem to find if there is any solution to it,

I was just wondering when i create a new column(new variable ) in a dataset is there any command to define the place it should take instead of automatically placing it last?

lets say i calculate the sum of a few variables and i want the column that contains the sum to appear after the variables is it possible?

thnx in advance

Re: placing created column in specific position

Ksharp — Tue, 19 Apr 2011 10:16:31 GMT

It seems to do it ,Only after this dataset created.
Ex:
[pre]
proc report data=class nowd out=_class(drop=_break_);
column a a_sum b b_sum...
define a /display;
run;
[/pre]

The advantage of this way is that you can use sas variable list method Such as:
a1-a10 a-numeric-x a--z _character_ .........

Ksharp

Re: placing created column in specific position

chemicalab — Tue, 19 Apr 2011 10:24:36 GMT

Thnx Ksharp i will work my way on your advice thnx