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;
you could try recoding so that if data= date2 then date2=. then you could remove the missing, that may work
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!