For quite a few questions on this forum, the answer lies in fixing character data ... removing tabs or occasionally removing nulls. The programming to do this isn't overwhelming, but it might be to a relatively new SAS programmer. It shouldn't be too hard to construct a fix, along the lines of proc remove_tabs data=. Executing the proc would involve looking at all character variables, and removing any tab characters. There could be options to specify:
This is really a suggestion for discussion purposes. Under the current forum structure, I didn't see a way to make a Ballot suggestions.
Thanks!
This would be for SAS data sets. SAS needs to get it right (easily) when determining which fields to process. So I would think that rules out text files.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.