Help using Base SAS procedures

placing created column in specific position

Reply
Frequent Contributor
Posts: 126

placing created column in specific position

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
Super User
Posts: 10,018

Re: placing created column in specific position

Posted in reply to chemicalab
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
Frequent Contributor
Posts: 126

Re: placing created column in specific position

Thnx Ksharp i will work my way on your advice thnx
Ask a Question
Discussion stats
  • 2 replies
  • 101 views
  • 0 likes
  • 2 in conversation