I have a excel file looks like this:
seg mile date1 date2 date3 ......
Min. Med. Max. Min. Med. Max. Min. Med. Max.
1 1 . . . . . . . . .
.........
I want extract "Med." for each observation to SAS:
seg mile date Med.
1 1 1 .
1 1 2 .
...........
What's the best to do it?
I'm thinking export the whole dataset to SAS. then transpose the data and
filter the med. value for each date. Is this a good wa
