Hi, I am a novice user of SAS and wondered if someone could help me. I have two sets of data one with 'knowns' references and one with 'HP' which have some duplicate reference numbers when merged. I want to merge these two spreadsheets and remove the duplicates but I only want to remove the duplicates that came from the 'known' spreadsheet and not the 'HP' spreadsheet is this possible? Each spreadsheet does have a variable stating whether the reference is HP or known. Many thanks in advance ... View more