Read comma delimited files with special characters

Sir_Lancelot — Thu, 31 Oct 2019 10:12:13 GMT

I am trying to read a comma delimited file with special characters. The program can read the first few fields correctly until a special character is reached. Thereafter, the next column shifts to the left. Please see below example:

Expected outcome

Field 1	Field 2	Field 3	Field 4
I	UNABLE TO EARMARK FOR VAF S/SHIP PRIOR TO 2002�	ZAR	88

However, this is what I am getting:

Field 1	Field 2	Field 3	Field 4
I	UNABLE TO EARMARK FOR VAF S/SHIP PRIOR TO 2002�ZAR	88

Re: Read comma delimited files with special characters

Kurt_Bremser — Thu, 31 Oct 2019 10:14:49 GMT

Please post your code (use the "little running man" icon) and the respective lines from the file (use the {i} button).

topic Read comma delimited files with special characters in New SAS User

Read comma delimited files with special characters

Re: Read comma delimited files with special characters