When I read something like
@dgaribal wrote:
approximately 925 variables
The back of my mind immediately starts to scream "DESIGN FAILURE!".
One way to easily convert is this:
data have;
input id $ (A B C) ($);
datalines;
A 1 0 1
B 0 0 1
;
proc transpose
data=have
out=long
;
by id;
var a--c;
run;
data long2;
set long;
numvar = input(col1,best.);
run;
proc transpose
data=long2
out=want (drop=_name_)
;
by id;
id _name_;
var numvar;
run;
But you should seriously contemplate if the long layout (dataset LONG2) isn't better in the long run.
... View more