DATA Step, Macro, Functions and more

Specific Question-Merge

Reply
Super Contributor
Posts: 1,040

Specific Question-Merge

Hi Team,

I get a dataset by merging two datasets with Medical record Numbers.

Can i use the resultant dataset to merge with other dataset by bill  number??/

A single Medical record number can have several bill numbers associated with it

Regards

PROC Star
Posts: 7,363

Re: Specific Question-Merge

Yes.  Sounds like a one to many merge which can be done, easily, with either a datastep or proc sql.  If it is a many-to-many merge, you would want to do it with proc sql.

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation