Hello,
I have made a lot of tests with your help (thank you very much). But I came to the conclusion that none of the encoding option is working neither the kcvt function because, in our program, a lot of input variables are formated in ebcdic format.
options dflang='english';
options locale=EN;
proc options;
run;
%let SrcPath=/finsys/bicoe/BICOE/CR_SR_Prj/LEGO_1259/EBCDIC_files;
%let ebcdicfname=pq.pxdwxqx.sefipaac.q92.ftp.d20210803b;
Data test;
infile "&SrcPath/&ebcdicfname." lrecl=3000 recfm=f ;
input @2042 email $char71.;
input @2042 email2 $EBCDIC71.;
email3 = kcvt(email,'e037','wlatin1');
run;
Data test;
infile "&SrcPath/&ebcdicfname." lrecl=3000 recfm=f ;
input @2042 email2 $EBCDIC71.;
email4 =tranwrd(email2,'à','@');
run;
The email3 works fine but we can not use it since in our programs, many input statements use an EBCDIC format.
Regarding the encoding ='something' into the infile statement, none that I have tested gave the appropriate results.
I have tests many options and I don't know what's going on with our SAS EG setting but I was unable to find a proper encoding setting that will works with our original sas programs.
Therefore, the only option that remain workable is the tranwrd option.
I thought that with your help, we could find a proper setting but none of the options gave me the expected results.
Thank again for your help.
... View more
