Merging two Lab datasets

[Neha0909]

I need to merge two laboratory datasets hematology and coagulation data sets together. The form I’d of both the data sets are same.how can I merge both of them in one dataset.

[Reeza]

There's nothing below as sample data.

---

@Neha0909 wrote:

I need to merge two laboratory datasets hematology and coagulation data sets together. The form I’d of both the data sets are same.how can I merge both of them in one dataset.

---

[Neha0909]

Hi, 

i was was able to merge the data sets but now I  need to create a macro to merge different laboratory datasets. Please help. I cannot share the datasets as it’s confidential. 

i used Proc sort to sort the data and then used set and merge statement to Create a new dataset. And used proc sql to rearrange the column names. 

Is there any other way I can merge the data set effeciently. And how can I Create a generic macro for all the laboratory data which can be modified as per the trial requirements.

[Reeza]

Then make fake data that represents your data but that you can share. 

[Neha0909]

I will create a fake data and upload it by tomorrow so that you have a clear idea about what I guidance I’m looking for.