12-15-2016 12:57 PM
I'm helping a coworker combine and clean 84 csv files. I have imported them and combined them into one SAS data set. For some reason, her csv files have some odd-looking characters in place of apostrophes, quotes and in a few cases, the letter 'e'.
Here's a list of what I have vs what I want. The var in question is desc.
â€™ should become '
Ã© should be e
Ã¨ should be e
â€œ should be "
â€ should also be "
â€¢ I want to delete (suppress?) it
â€“ and â€” delete (suppress?) them.
Need further help from the community? Please ask a new question.