how to read .csv with pipe delimiter data correctly in proc import

1239 — Wed, 08 Sep 2021 11:23:14 GMT

Hi,

I am trying to import .csv with pipe delimiter where some of the values are converting into question mark symbol and I am not sure whether this unicode character issue or some other.

Could you please review the below code along with sample file and help me in importing this .csv pipe delimiter file with values correctly as currently output value mm² is read as mm�

filename temp "C:\Test.csv"  encoding="utf-8";
PROC IMPORT OUT=test
	DATAFILE= temp
	DBMS=DLM REPLACE;
	DELIMITER='|';
	GETNAMES=YES;
	DATAROW=2;
	GUESSINGROWS=MAX;
RUN;

Re: how to read .csv with pipe delimiter data correctly in proc import

Kurt_Bremser — Wed, 08 Sep 2021 11:54:05 GMT

This is not UTF encoding, it's standard Latin 1, so use

filename temp "~/Test.csv" encoding="wlatin1";

topic Re: how to read .csv with pipe delimiter data correctly in proc import in SAS Programming

how to read .csv with pipe delimiter data correctly in proc import

Re: how to read .csv with pipe delimiter data correctly in proc import