Hi, Dataset1 name = city1, label=city_name_very_too_long_to_be_a_nameBoston, n=20 name = city2, label=city_name_very_too_long_to_be_a_nameNewYork, n=10 Dataset2 name = city1, label=city_name_very_too_long_to_be_a_nameChicago, n=5 name = city2, label=city_name_very_too_long_to_be_a_nameCapeCod, n=0 If I do: data dataset3; set dataset1 dataset2; run; Dataset3; City1 (label=city_name_very_too_long_to_be_a_nameChicago) City2 (label=city_name_very_too_long_to_be_a_nameCapeCod) 20 10 5 0 I am loosing the information related to my first Dataset1 (Boston and NewYork). Therefore, in Dataset3, I am assuming that 20 patients are coming from Chicago while they are coming from Boston. Hope this is more clear.
... View more