Hi all, I'm assuming this is a simple answer but here it goes: I have two tables for an email campaign: one with engagement levels, the other with revenue. I have the data rolled up to a regional grouping, and the unique ID's for each campaign are in both tables, so that is what I am using to join the two tables together. I basically want by campaign, by group - the engagements and revenue combined. My problem is that I am getting three matching rows returned now for each value that should be unique. Note that there are some campaigns without revenue, so I am using a left join to show the campaigns in the engagement table, and then also revenue where there is a match. proc sql; create table match as select distinct a.campaign_id, a.region, a.program, a.processed_dttm, a.sent, a.open, a.click, b.bookings, b.revenue from table.engagement a left join table.revenue b on a.campaign_id_id = b.campaign_id where a.campaign_id is not null group by 1; quit; Thanks for you help ahead of time!
... View more