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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.