DATA Step, Macro, Functions and more

Merging variables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 121
Accepted Solution

Merging variables

Hi!  I merged two data sets by Patient ID, but realized two variables (PatDOB, PatDOB1) were named differently but both serve as birthddate.  So, now half values are under PATDOB1 and others under PATDOB.  They are both formatted same (mmddyy10.), so is there a way to move all values in PATDOB1 to PATDOB and then delete the variable PATDOB1?

 

Thanks!!


Accepted Solutions
Solution
‎11-20-2015 01:09 PM
Respected Advisor
Posts: 4,647

Re: Merging variables

PATDOB = coalesce(PATDOB, PATDOB1);

 

coalesce returns the first argument that is not missing.

PG

View solution in original post


All Replies
Regular Contributor
Posts: 161

Re: Merging variables

If you don't have a risk of over-writing one date with another, then just use an assignment statement and drop the unwanted variable, the simplest I can think of.... 

Kannan Deivasigamani
Solution
‎11-20-2015 01:09 PM
Respected Advisor
Posts: 4,647

Re: Merging variables

PATDOB = coalesce(PATDOB, PATDOB1);

 

coalesce returns the first argument that is not missing.

PG
Frequent Contributor
Posts: 121

Re: Merging variables

@PGStats Thank you!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 201 views
  • 1 like
  • 3 in conversation