Help using Base SAS procedures

help with merge

Reply
N/A
Posts: 0

help with merge

Hi all. I merged two datasets with 2 different date variables. However some dates are the same for both variables (ex. date=12/1/07 date2=12/1/07). My question is:
Is there a way to remove the dublicate variable (and somehow keep the 1st one)?
For ex., can I say:

data all;
merge one two;
by name;
if date=date2 then remove date2;
run;

Any help would be appreciated. Thanks.
N/A
Posts: 0

Re: help with merge

Posted in reply to deleted_user
you could try recoding so that if data= date2 then date2=. then you could remove the missing, that may work
Ask a Question
Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 1 in conversation