02-20-2018 10:48 AM
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.
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 ?
02-20-2018 01:47 PM
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 ?
Need further help from the community? Please ask a new question.