Reading an EBCDIC file and arobas is converted to a instead of a @ the email field

[alepage]

Hello,

I am doing a proc compare and for some reason, I don't know , one of the field : client_email value

are converted to the second value instead of the first value.  @ is converted into à

Is there a simple way to avoid that?

66  ||  IRDENNIS@ICLOUD.COM   IRDENNISàICLOUD.COM 

[jimbarbour]

---

@alepage wrote:

one of the field : client_email value

are converted to the second value instead of the first value.  @ is converted into à

Is there a simple way to avoid that?

66  ||  IRDENNIS@ICLOUD.COM   IRDENNISàICLOUD.COM 

---

Is the same issue as on your other post?  Is this from EBCDIC?

As a quick work-around, you could do the below, but if there are other à characters in the data, this will not work.  For example, and email address of Thomas_à_Kempisàemail.com would not work with this quick work-around.  You would have to examine your data.

Jim

DATA	Have;
	INPUT	Email_Address	:	$64.;
DATALINES;
IRDENNISàICLOUD.COM
;
RUN;	

DATA	Want;
	SET	Have;
	Email_Address	=	TRANSLATE(Email_Address,'@','à');
RUN;

[SASKiwi]

If you want a solution then please post the code that is causing the problem in the first place.