topic Re: Merging two Lab datasets in SAS Data Management

Merging two Lab datasets

Neha0909 — Mon, 29 Jan 2018 21:15:23 GMT

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.

Re: Merging two Lab datasets

Reeza — Mon, 29 Jan 2018 21:23:51 GMT

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.

Re: Merging two Lab datasets

Neha0909 — Tue, 30 Jan 2018 21:15:47 GMT

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.

Re: Merging two Lab datasets

Reeza — Tue, 30 Jan 2018 21:12:43 GMT

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

Re: Merging two Lab datasets

Neha0909 — Tue, 30 Jan 2018 21:34:02 GMT

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.