Data Cleaning

[OoStatmasteroO]

Just looking for any tips/tricks you may have for dealing with "messy" data. I am working with some survey data that is pretty messy so I am just interested in how others deal with it.

 

[OoStatmasteroO]

For example, one thing I am trying to do is get rid of any special characters in an ID. I read about the one person using compress or prk, however what if you have an ID with "# 123456" - that would not get rid of the space after the #.

 

[klaz2002]

I am not sure what you mean that the compress function doesn't remove blanks after the pound sign. I have successfully used that function to remove blanks from a value with a pound sign.
Klaz