topic Re: keep required email address in observations in SAS Programming

keep required email address in observations

BrahmanandaRao — Sun, 27 Mar 2022 07:52:53 GMT

data email;
input email $30.;
datalines;
xxxxxxxxxxx@gmail.com
xxxxxxxxxxxx@outlook.com
xxxxxxxxxxx@gmail.com
xxxxxxxxxxx@gmail.com
;
run;

How to keep only required email address

example here keep only gmail.com address

Re: keep required email address in observations

SASKiwi — Sun, 27 Mar 2022 08:10:19 GMT

data email;
input email $30.;
email_provider = scan(email, 2, '@');
datalines;
xxxxxxxxxxx@gmail.com
xxxxxxxxxxxx@outlook.com
xxxxxxxxxxx@gmail.com
xxxxxxxxxxx@gmail.com
;
run;

There are many ways to do this including the SCAN function to read the second word in the string where an ampersand is the delimiter.

Re: keep required email address in observations

BrahmanandaRao — Sun, 27 Mar 2022 08:19:44 GMT

i want output those who have gmail email address in this example data contains three gmail address

i want complete three gmail address

Re: keep required email address in observations

Kurt_Bremser — Sun, 27 Mar 2022 10:09:59 GMT

Just use the SCAN function with "@" as delimiter to get the domain from the email address; if the result of the function is found to be "gmail.com", keep the observation. Can be done in a WHERE statement, WHERE= dataset option, or Subsetting IF, depending on where the subsetting needs to be done.

I will not insult your intelligence by providing this EXTREMELY SIMPLE code. If you cannot solve such a simple issue by now (500+ posts here), then drop your illusion that you'll ever earn money with SAS work.