I have a data set that looks something like this: idnum var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 1 a b 12 e 2 3 4 5 6 7 2 v f 15 g 5 6 7 8 9 10 3 ... I want to combine var6-10 under one headin, but still have them seperate (if that makes sense). So it would end up something like this: idnum var1 var2 var3 var4 var5 newvar 1 a b 12 e 2 var6 3 var7 4 var8 5 var9 6 var10 7 2 v f 15 g 5 var6 6 var7 7 var8 8 var9 9 var10 10 Is this even possible? I've attempted PROC TRANSPOSE but I can't figure it out. Any help would be much appreciated!
... View more