10-11-2017 09:42 AM
10-11-2017 04:12 PM
10-16-2017 10:52 AM
For instance, if someone said Sam123@gmail.com and also firstname.lastname@example.org-I'd want one of those deleted from the database.
To fix this you need to clean your data first.
This code gets rid of missing e-mails, is there a way to prevent that?
To deal with this you likely need to do it manually.
First sort and then use a data step with first/last but coding an exception for the missing emails.
proc sort data=have; by group_var; run; data want; set have; by group_var; if first.group_var or missing(group_var); run;
Need further help from the community? Please ask a new question.