First things first: change the title so that it matches the problem you have, something like "transposing data" seems to be adequate. Using the title “base sas" in a community about base sas programming is not that, well, informative. Second point, don't write all upcase. It reduces readability and is seen as shouting. Posting the code you tried will, most likely, result in more useful answers, because we can explain what went wrong or at least what you have to change. Edit: proc transpose seems to do exactly what you need. So, again, please post the code you tried and explain what wrong with result. Proc transpose, of course, generates one extra column, but that can easily be dropped.
... View more