sas developer interview questions shared by candidates
whats is the difference between merge and join .
said merge requires sorting of data and join doesnt .
Both are horizontal combination of data set values. where, merge needs the data set to be sorted before combining. And join combines data set values based on Cartesian product.
Using join you can split lines (duplicate). For example, you have AETERM in Adverse Event, where AETERM = "headtoothache". It's 2 independent DECOD, and if you need to control it by MedDRA dictionary you need to split lines where AETERM in both lines equal to 'headtoothache' but AEDECOD in the first line equal to 'HEADACHE' and 'TOOTHACHE' in the second line.
See Interview Questions for Similar Jobs
- Business Analyst
- Software Engineer
- Programmer Analyst
- Project Manager
- Associate Analyst
- Team Leader
- Senior Business Analyst
- Senior Analyst
- Data Scientist
- Assistant Manager
- Data Analyst