topic Re: Reading an EBCDIC file and arobas is converted to a instead of a @ the email field in SAS Enterprise Guide

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

alepage — Fri, 13 Aug 2021 15:23:57 GMT

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

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

jimbarbour — Fri, 13 Aug 2021 20:02:25 GMT

@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;

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

SASKiwi — Fri, 13 Aug 2021 23:33:12 GMT

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