topic Re: upcase of countries in email in SAS Programming

upcase of countries in email

pavank — Fri, 21 Jun 2024 12:13:38 GMT

data dsn;
input email $20.;
datalines;
Abc@123Ind
cd!345Aus
thr%34344Us
;
run;

output Like below

Abc@123IND
cd!345AUS
thr%34344US

Re: upcase of countries in email

PaigeMiller — Fri, 21 Jun 2024 12:38:00 GMT

data want;
    set dsn;
    first=cats(scan(email,1,'@!%'));
    delim=substr(email,length(first)+1,1);
    second=upcase(scan(email,2,'@!%'));
    email=cats(first,delim,second);
    drop first delim second;
run;

May I ask ... why? What is the benefit of converting parts of email addresses to capital letters? There is no requirement that e-mails addresses be capitalized.

Re: upcase of countries in email

pavank — Fri, 21 Jun 2024 13:00:05 GMT

Hi @PaigeMiller I do agree with you

Interview panel asked these type of questions

Re: upcase of countries in email

PaigeMiller — Fri, 21 Jun 2024 13:01:15 GMT

Ok, thanks. Pointless question, asking someone how to do work that doesn't need to be done.

Re: upcase of countries in email

Ksharp — Sat, 22 Jun 2024 06:24:58 GMT

data dsn;
input email $20.;
datalines;
Abc@123Ind
cd!345Aus
thr%34344Us
;
run;

data want;
 set dsn;
 want=prxchange('s/([a-z]+$)/\U\1/',1,strip(email));
run;