Hello I want to join multiple columns that have the same type of data, into 1 column so that I'm able to conduct analysis on just 1 column instead of multiple columns with the same type of data. Below is an example of how the data is currently structured item cat1 cat2 cat3 cat4 cat5 A 111 222 333 444 555 B 666 777 888 999 101 C 112 212 313 414 515 D 123 234 567 890 145 I want the data to look like this: item cat1 A 111 A 222 A 333 B 666 B 777 B 888 C 999 C 555 C 101 D 789 D 456 Data Want;
set Have ;
cat 1 = cat 2;
keep cat 1 ;
run; I would also like to know how to get the data back to the original structure once I've completed my analysis please ?
... View more