UTF-8 character strings

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

UTF-8 character strings

Hello All,

 

I am doing a proc export step to get the csv format file from SAS.

 

%macro export_mkt(mktname, outf);

PROC EXPORT DATA= LIB.&mktname.
OUTFILE= "&mydrv.\Projects\Neuro\VInsight_Data\Monthly\&outf._monthly.csv"
DBMS=DLM REPLACE;
DELIMITER=',';
PUTNAMES=YES;
RUN;
%mend;

 

 When the csv file is uploaded to Salesforce.com it is rejecting the file WITH AN ERROR SAYING ,

 

Error:Invalid utf8 character string: 'The Home Depot'

Error:Invalid utf8 character string: 'St.'

 

I witnessed in the Csv files that there were blanks in between and after the values. Do I have to compress the variable giving the above mentioned errors? How to solve this problem ?


Accepted Solutions
Solution
‎02-27-2018 02:44 PM
Valued Guide
Posts: 580

Re: UTF-8 character strings

Posted in reply to purveshrana

All Replies
Valued Guide
Posts: 580

Re: UTF-8 character strings

Posted in reply to purveshrana

The blank should not be a problem, but have you checked the encoding of the file created by proc export. Is it in utf-8?

Occasional Contributor
Posts: 5

Re: UTF-8 character strings

Posted in reply to andreas_lds

Hello Andreas,

 

It is not in the UTF-8 format. As of now I just exported the csv files to Ultraedit and again saved them as UTF-8. If there is a way I can incorporate UTF-8 format while doing a proc export in the sas code itself ?

 

Thanks

Solution
‎02-27-2018 02:44 PM
Valued Guide
Posts: 580

Re: UTF-8 character strings

Posted in reply to purveshrana
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 129 views
  • 0 likes
  • 2 in conversation