Hi, Thanks for your reply. I have a table named “Test” in Prepare Data in SAS data studio. My Table looks like this: Test Sequence Province ER_Code NOC_Code Number of jobs 2019m1 QC Capitale-Nationale 0011 1 2019m1 QC Chaudi�re-Appalaches 0011 1 2019m1 QC Montr�al 0011 1 2019m1 NL Avalon Peninsula 0012 3 2019m1 NL West Coast--Northern Peninsula--Labrador 0012 3 2019m1 PE Prince Edward Island 0012 2 2019m1 NS Halifax 0012 9 2019m2 QC Capitale-Nationale 0011 2 2019m2 QC Chaudi�re-Appalaches 0011 3 2019m2 QC Montr�al 0011 4 2019m2 NL Avalon Peninsula 0012 3 2019m2 NL West Coast--Northern Peninsula--Labrador 0012 3 2019m2 PE Prince Edward Island 0012 2 2019m2 NS Halifax 0012 9 I want the number of jobs aggregated by sequence & NOC-Code; and sequence & NOC-Code & province and add two new columns to my existing table “Test” as this: Test Sequence Province ER_Code NOC_Code Number of jobs Aggregated by sequence & NOC-Code Aggregated by sequence & NOC-Code & province 2019m1 QC Capitale-Nationale 0011 1 3 3 2019m1 QC Chaudi�re-Appalaches 0011 1 3 3 2019m1 QC Montr�al 0011 1 3 3 2019m1 NL Avalon Peninsula 0012 3 17 6 2019m1 NL West Coast--Northern Peninsula--Labrador 0012 3 17 6 2019m1 PE Prince Edward Island 0012 2 17 2 2019m1 NS Halifax 0012 9 17 9 2019m2 QC Capitale-Nationale 0011 1 9 9 2019m2 QC Chaudi�re-Appalaches 0011 1 9 9 2019m2 QC Montr�al 0011 1 9 9 2019m2 NL Avalon Peninsula 0012 3 17 6 2019m2 NL West Coast--Northern Peninsula--Labrador 0012 3 17 6 2019m2 PE Prince Edward Island 0012 2 17 2 2019m2 NS Halifax 0012 9 17 9
... View more