04-27-2017 06:40 AM
04-27-2017 07:13 AM
Examining the help guidance under the Post on a new post will help you to post a good question, and hence get a good answer. Please post test data - in the form of a datastep in a code block in the post. Then post what the output should look like. And finally clearly explain the steps between the two.
04-27-2017 09:24 AM
Is your input a text file or a SAS dataset?
I suspect this data is being loaded incorrectly to start with and you may be able to fix it before this step.