How to find email domains using proc sql

Question

In mysql this would look like: substring_index(email, '@', -1)

But I can't seem to find if a function like this is available in SAS proc sql.

score 2 · Accepted Answer · answered Apr 13 '18 at 18:02

2

this seems to work

data _null_;
x='rxx@gmail.com';
dom=substr(x,findc(x,'@'));
put dom;
run;

answered Apr 13 '18 at 18:02

DCR

1

you are the one man! this worked. My rep isn't higher but consider this +1'ed – max Apr 13 '18 at 18:09
Use comments to ask for more information or suggest improvements. Avoid comments like "+1" or "thanks". – jchevali Apr 13 '18 at 18:13

score 0 · Answer 2 · answered Apr 13 '18 at 17:25

0

Use FINDW to find the position of @ and SUBSTR to return the remainder?

answered Apr 13 '18 at 17:25

jchevali

1

sounds like it could work - haven't been able to write the exact function using those two functions yet though. – max Apr 13 '18 at 17:37
In other languages such as SQLite, where FINDW is called instr(), it'd be something like substr('mail@server',1+instr('mail@server','@')) – jchevali Apr 13 '18 at 17:54
1

here's where I am so far - which seems to pull the domain minus the .com piece: scan(substr(email,index(email, "@")),1) – max Apr 13 '18 at 17:59
Can you try substr(email,1+findw(email,"@")) – jchevali Apr 13 '18 at 18:02

2 Answers2