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.
Please post your data in the form of a datastep, much easier to help that way.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.