Hello, I am trying to combine multiple 0/1 column variables in to one general column variable. Example: Multiple column data for race such as White, Black, etc. and they are all 0/1. What would be the best way to change them into a single column data variable? Any help is much appreciated! ... View more

I am working with a data set and I performed the proc transpose to see multiple dates for the same variable in the by statement. transpose data=dataset out=wide; by var1; var var2; run; When I run this I get . in Col1 for some but Col2 has data in it. My question is how can I move the data in Col2 to Col1 or move all data over so the first variable is in Col1? Example: Col1     Col2     Col3 .        31        32 30       32        33 Thank you! ... View more