topic Re: converting sas dataset to csv using utf 8 encoding in SAS Programming

converting sas dataset to csv using utf 8 encoding

HeatherNewton — Wed, 24 May 2023 06:19:20 GMT

%macro conversion_sdata(filename);
data &filename.;
   set twonov.&filename.;
run;
filename exprt "/mpoint/data_migration/&filename..csv" encoding="utf-8";
run;
%mend;

%conversion_sdata(ambs);

I tried this in sas on demand academic and it works fine,

when tried at work sas server, I get the following:

"ERROR: physical file does not exist, /mpoint/data/migration/ambs.csv.

0 records created in EXPRT from ambs.

why is that? how to resolve?

Re: converting sas dataset to csv using utf 8 encoding

HeatherNewton — Wed, 24 May 2023 08:08:00 GMT

I found the bug!! I forgot to create the directory

thank you guys

Re: converting sas dataset to csv using utf 8 encoding

Tom — Wed, 24 May 2023 12:07:13 GMT

@HeatherNewton wrote:

I found the bug!! I forgot to create the directory

thank you guys

Did you also fix the fact that your posted code was NOT making any attempt to create a CSV file?

Re: converting sas dataset to csv using utf 8 encoding

HeatherNewton — Thu, 25 May 2023 00:00:04 GMT

Yes i missed proc export line here
Thanks

Re: converting sas dataset to csv using utf 8 encoding

mkeintz — Thu, 25 May 2023 00:40:17 GMT

@HeatherNewton

You resolved the problem yourself - great.

Please mark your own response as the solution. This helps potential respondents understand in advance that the original request has been satisfied.