How can you remove duplicates using SAS, SQL, Excel etc.?
AnswerBot
1y
Duplicates can be removed using SAS, SQL, Excel etc.
In SAS, use PROC SORT and the nodupkey option
In SQL, use the DISTINCT keyword in the SELECT statement
In Excel, use the Remove Duplicates feature und...read more
Help your peers!
Add answer anonymously...
Popular interview questions of Data Analyst
>
HSBC Global Banking and Markets Data Analyst Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app