SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Merging two Lab datasets

Reply
Occasional Contributor
Posts: 6

Merging two Lab datasets

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.

Super User
Posts: 23,332

Re: Merging two Lab datasets

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.


 

Occasional Contributor
Posts: 6

Re: Merging two Lab datasets

[ Edited ]

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.

Super User
Posts: 23,332

Re: Merging two Lab datasets

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

 

Occasional Contributor
Posts: 6

Re: Merging two Lab datasets

[ Edited ]

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.

Ask a Question
Discussion stats
  • 4 replies
  • 136 views
  • 0 likes
  • 2 in conversation