Astounding thank you for getting back to me! To answer your previous question: There does seem to be missing data in some of the variables. There are no multiple answers for multiple variables. The max(var) did not work.
... View more
I have changed the variables such as 0/1 variables in each column the 1 = a different number ex. 2 for black column and 3 for Asian column.
... View more
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
I have multiple variables in my dataset that have Y/N data but I need to convert it to 0/1 data for analysis. Does anyone know a macro or a code that would help with this conversion of the variables with Y/N data?
... View more