I have a large data set, in DAT format, that is sorted into rows whether it is imported into either excel or SAS. In excel I can very easily transfer all this information into the layout I need by using Text to Columns. This allows the data to be sorted and also for me to be able to add columns wherever I feel. However when it comes to SAS, both in my limited experience as a beginner and what I can find in forums, I don't believe there is anything that will do this the same way. I appreciate that the short term code writing will be slower but for future programming I hope to do this with one click. If anyone has any ideas on the process or code that I would need to input to do this, please let me know. Thanks Harry
... View more