Merge datasets without losing information

mariko5797 — Fri, 23 Jul 2021 18:43:41 GMT

Suppose my datasets are organized like so:

I want to combine the information from dataset 1 and dataset 2 such that my columns are DISEASE, BMIGRP, COUNT_A, and COUNT_B.

I don't want to lose any information. That is, I want to maintain all the DISEASES granted they exist in at least one of the datasets like so:

Is there an efficient way to achieve this? Thank you in advance.

Re: Merge datasets without losing information

Tom — Fri, 23 Jul 2021 19:04:53 GMT

Just the MERGE statement.

Just make sure the data sets are sorted first. They do not appear sorted in your photographs.

data want;
  merge dataset1 dateset2;
  by disease bmigrp;
run;