Hello, I haven't used SAS in years and I am now trying to use it for some data analysis. I have a large data set that is output from another program into an excel spreadsheet. It is a survey that has many parts. Currently there are 229 columns. The first column is the specialty. The next 228 columns are Name, Question 1 Answer, Q2 Ans, Q3 And, Q4 Ans, and Q5 Ans for 38 specialties. The responses are all characters (Excellent, Good, Needs Improvement) with some left blank. Also, each column is currently named a unique random letter and number combination. Below is a crud example of what is currently looks like: Q2_1 Q2_2_1 Q2_2_2 Q2_2_3 Q2_2_4 Q2_2_5 Q109 Q110_1 Q110_2 Q110_3 Q110_4 Q110_5..... Specialty1 Bob Ex Ex Good Ex Ex Specialty1 Tom Good Good NI Ex Ex Specialty1 Sue Ex NI Good Ex Specialty1 Bob Ex NI Ni Good Ex Specialty2 Lee Ex Ex Good NI Ex Specialty2 Jim Good Ex Ex Good Specialty2 Joe Ex Ex Good Ex Ex I need it to look more like this: Name Q1_Ans Q2_Ans Q3_Ans Q4_Ans Q5_Ans Specialty1 Bob Ex Ex Good Ex Ex Specialty1 Tom Good Good NI Ex Ex Specialty1 Sue Ex NI Good Ex Specialty1 Bob Ex NI Ni Good Ex Specialty2 Lee Ex Ex Good NI Ex Specialty2 Jim Good Ex Ex Good Specialty2 Joe Ex Ex Good Ex Ex What would be the best/simplest way to combine 228 variables down to 6 variables? I am using SAS 9.4.
... View more