I am trying to perform a transpose from wide to long. There are 27 variables that I am transposing. The data looks essentially like this: id var1 var2 var3 ... var27 1 a b c In the past when I have done this transpose, the result looks like this: id _name_ COL1 1 var1 a 1 var2 b 1 var3 c ... 1 var27 However, today the result I am getting looks like this: id _name_ COL1 COL2 COL3 ... COL25 1 var1 a a a 1 var2 b b b 1 var3 c c c ... 1 var27 This is the code I used: proc transpose data = data out = data_long ; by id; var var1 - var27; run; What am I doing wrong here? Why and I getting so many columns? My variables are all consecutive in the data set and all are the same format- $8. Using SAS 9.4 on Windows
... View more