From: Al on
Dear all:


This is the data i have .. The output desired is 'want' dataset

data have;
input pat ds $ vis res $ code $ term $;
cards;
1 2 1 X ABC PQR
1 2 2 X DEF STU
1 2 12 X GHI VYZ
1 3 15 X JKL CHS
1 3 10 X MNO MNO
;
run;

proc sort data = have;
by pat ds code term;
run;

proc transpose data = have prefix = Day out = want;
by pat ds code term;
var res;
id vis;
run;

How can i order(ascending) the transposed columns in the 'Want'
dataset



Thanks in advance
Al