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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.