Hi, I am having trouble reading a file containing non-consistent data in wide format into long format. for example, the data looks like this: subject, sex, time1, time2, time3,..., intensity1, intensity2, intensity3.... 1,m,1,45,5,2,5,3 2,m,3,6,5,5,6,3 3,m,6,65,5,2,20,3,23,63 4,m,9,6,5,43,5,3 5,m,3,195,5,2,5,32,34,78,12,42 6,m,6,92,5,232,5,23 so some subjects may have 3 times and 3 intensities and other may have 4 times/intensities or 5 times/intensities... If I read the file as data id sex$ time1-5, intensity1-5; then transform into long format by data long; set wide; array t(5) time1-time5; array i(5) intensity1-intensity5; do j=1 to 5; time=t(j); intensity= i(j); output; end; however for those subjects that have <5 times/intensities, SAS will continue to read the next subject's data and the whole table screws up. is there a way I can read the data directly into long format? something like... data long; infle 'xxx'; input id sex$ @@; - do a loop that reads the remaining variables - I can change the variables into time1 intensity1 time2 intensity2 time3 intensity3.... time= intensity= output; thanks for any suggestions! ming
... View more