I think I have a wrong approach. Tried the code and I think that's not what I'm looking for. So basically, I have the 1st dataset and my goal is to add it on the existing table that consist of member table. I'm not sure on how I will add the yearmonth in order plus the total without hard coding it. e.g. proc sql; create table test as select a.id, a.fullname, b.aug2019, b.sept2019, b.oct2019, b.nov2019, b.dec2019,b.jan2020, b.feb2020, b.mar2020, b.apr2020, b.may2020, b.jun2020, b.july2020, (b.aug2019 + b.sept2019 + b.oct2019 + b.nov2019 + b.dec2019 + b.jan2020 + b.feb2020 + b.mar2020 + b.apr2020 + b.may2020 + b.jun2020, b.july2020) as total label='total counts' from member_tbl a left join dataset1 b on a.id=b.id order by id ; QUIT;
... View more