Hello Experts,
I woud like to import the attached file, but I don't know how to choose the encoding option. When I try to convert this file to csv I have the same encoding problem. My code is :
filename mon_f temp;
data _null_;
infile "XXXXX\data_act.xlsx" dsd truncover lrecl=32767 encoding=wlatin1;
file mon_f lrecl=1000000;
input ligne :$char32767.;
if notdigit(scan(ligne,1,',')) and length(scan(ligne,1,','))>1 then
put '|' @;
else if length(scan(ligne,1,','))>1 then
do;
put;
end;
len=lengthn(ligne);
put ligne $varying32767. len @;
run;
proc import datafile=mon_f dbms=csv out=donnee replace;
getnames=no;
run;
Thank you very much !
... View more
