I want to collapse multiple columsn (as some are empty) into few columsn to reduce size of the file.
Maximum columns populated in Have is 3 so poutput should have 3 columns and orignial 5 can be dropped
Have
Record Class1 Class2 Class3 Class4 Class5
1 A C
2 B
3 D E
4 A
5 B C D
Want
Record Classnew1 ClassNew2 ClassNew3
1 A C
2 B
3 D E
4 A
5 B C D
Hi, I'm sure this question will get lots of replies. Here's on idea ...
data x;
input record (class1-class5) (:$1.);
datalines;
1 A . C . .
2 . B . . .
3 . . . D E
4 A . . . .
5 . B C D .
;
data y (keep=record class: );
set x;
array class(5);
new = catt(of class(*));
do i=1 to 5;
class(i) = char(new,i);
end;
run;
data set Y ...
Obs record class1 class2 class3 class4 class5
1 1 A C
2 2 B
3 3 D E
4 4 A
5 5 B C D
Hi, I'm sure this question will get lots of replies. Here's on idea ...
data x;
input record (class1-class5) (:$1.);
datalines;
1 A . C . .
2 . B . . .
3 . . . D E
4 A . . . .
5 . B C D .
;
data y (keep=record class: );
set x;
array class(5);
new = catt(of class(*));
do i=1 to 5;
class(i) = char(new,i);
end;
run;
data set Y ...
Obs record class1 class2 class3 class4 class5
1 1 A C
2 2 B
3 3 D E
4 4 A
5 5 B C D
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.