01-29-2018 04:23 PM
There's nothing below as sample data.
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.
01-30-2018 04:10 PM - edited 01-30-2018 04:15 PM
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.