Fixing Character Data

Astounding — Mon, 12 Sep 2022 08:04:20 GMT

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:

which characters get removed (tabs, nulls, other?)
remove tabs for the current operating system vs. for all operating systems?
remove all instances, vs. remove occurrences only at the end or only at the beginning of a variable
name of output data set after "fixing"
should the cleaning level become a permanent part of the metadata (probably impractical, as data sets get modified frequently)

This is really a suggestion for discussion purposes. Under the current forum structure, I didn't see a way to make a Ballot suggestions.

Re: Fixing Character Data

Reeza — Mon, 12 Sep 2022 16:37:12 GMT

Community>SASWare Ballot for adding new ballot suggestions.

Interesting concept - would this be for text files before import or for SAS data sets?

Re: Fixing Character Data

Astounding — Mon, 12 Sep 2022 17:04:44 GMT

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.

topic Re: Fixing Character Data in SAS Programming

Fixing Character Data

Re: Fixing Character Data

Re: Fixing Character Data