Suppose my datasets are organized like so:
![mariko5797_0-1627065540572.png mariko5797_0-1627065540572.png](https://communities.sas.com/t5/image/serverpage/image-id/61640i72F5A943248046DE/image-size/medium?v=v2&px=400)
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:
![mariko5797_1-1627065764454.png mariko5797_1-1627065764454.png](https://communities.sas.com/t5/image/serverpage/image-id/61641i65BB6EEE65276070/image-size/medium?v=v2&px=400)
Is there an efficient way to achieve this? Thank you in advance.