topic Re: No option in Base SAS to define the encoding when saving data as a csv file in proc export in SAS Programming

No option in Base SAS to define the encoding when saving data as a csv file in proc export

sreevatsan1991 — Tue, 25 Sep 2018 20:09:00 GMT

When I try to read the csv file saved by SAS into python, I am getting unicode-decode error. The error was because of '0x80' character available in the file. it can be solved by explicitly defining the encoding when reading the file. But I need to solve it to in SAS while creating the .csv file.

Is there a way to define the encoding in the proc export code like (encoding='utf-8' etc

Code :

PROC EXPORT DATA= data1
OUTFILE= "F:\reports\&file_name..csv"
DBMS=CSV REPLACE;
RUN;

Re: No option in Base SAS to define the encoding when saving data as a csv file in proc export

Tom — Tue, 25 Sep 2018 20:11:25 GMT

Did you try using a fileref?

filename csv "F:\reports\&file_name..csv" encoding='utf-8';
PROC EXPORT DATA= data1 REPLACE
  OUTFILE= CSV DBMS=CSV 
;
RUN;

Re: No option in Base SAS to define the encoding when saving data as a csv file in proc export

Reeza — Tue, 25 Sep 2018 20:22:56 GMT

Try assigning a FILEREF to the output data set and set the encoding there.

filename myfile 'paht to file' encoding=....;

proc export data=data outfile=myfile dbms=csv replace;
run;

@sreevatsan1991 wrote:

When I try to read the csv file saved by SAS into python, I am getting unicode-decode error. The error was because of '0x80' character available in the file. it can be solved by explicitly defining the encoding when reading the file. But I need to solve it to in SAS while creating the .csv file.

Is there a way to define the encoding in the proc export code like (encoding='utf-8' etc

Code :

PROC EXPORT DATA= data1
OUTFILE= "F:\reports\&file_name..csv"
DBMS=CSV REPLACE;
RUN;

Re: No option in Base SAS to define the encoding when saving data as a csv file in proc export

sreevatsan1991 — Tue, 25 Sep 2018 20:28:56 GMT

Thanks a lot. This worked!