BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
purveshrana
Fluorite | Level 6

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 ?

1 ACCEPTED SOLUTION
3 REPLIES 3
andreas_lds
Jade | Level 19

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?

purveshrana
Fluorite | Level 6

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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