Hi everyone,   I ended up transposing all of the data in SAS (hours of work) and my database is now working. I am sure that there is a way in SAS but this ended up being easier in the short run. Thank you Jim for telling me that the variables shouldn't be numeric, I would have struggled to figure this out for a long time otherwise.   Thank you for your assistance, Sarah ... View more

Hi Jim,   I was hoping to compare the scores from two different variables to evaluate whether there is a correlation. I figured I would need to create columns for each variable right?   If obemerg=1; Group_ID Teamwork score Communication score Variable 3……97 1A41956 3 1 1 1A41957 4 2 2 1A41958 5 5 5 1A41959 2 4 4 1A41960 5 3 3 1A41961 1 5 5   As of right now, the scores for teamwork and communication and every variable are all in the same column...   Thank you,   Sarah ... View more

Hi Jim Thank you for your help. It is unfortunately more complicated. The variable column has 96 different options, two of which are teamwork and communication. The scores are from 1-5 and there are many different teams that are evaluated. So in total there are over 43,000 rows. A sample of these data and the excel file is below:   Date Room Group Year obemerg med_team variable group_id $ Score bad_action Day exclude_med exclude_team exclude_perf 11/13/2014 1 1 2014 1 1 70 1A41956 1 0 0 0 1 0 11/13/2014 2 1 2014 1 1 70 2A41956 3 0 0 0 0 0 11/13/2014 3 1 2014 1 1 70 3A41956 2 0 0 0 0 0 11/13/2014 4 1 2014 1 1 70 4A41956 2 1 0 0 0 0 11/13/2014 5 1 2014 1 1 70 5A41956 3 0 0 0 0 0   So I want to create columns of the group ID with scores (1-5) for each component from variable (96 total). Is that possible?   Thanks! Sarah ... View more

Hi Paige,   Unfortunately this did not work. I think that is what I am trying to do, though. At the end it stated that despite the code variables teamwork and total were not found.   I posted a sample of the database to explain the complexity and what I am trying to do in previous reply.   Thank you,   Sarah ... View more