Thank you dear your response has worked for me, I want to know one more thing that can we sum the experience bucket with in the region. Like we have four experience bucket mainly 0-6 mths, 6-12 mths , 12-24 mths and > 24 mths and i want to count the no of employees in each exp bucket in each region. proc sql; create table PRACTISE.PRODSUMMARY as select REGION_NAME, COUNT(PAYROLL_ID), sum(TOTAL_MARGIN) as TOTAL_MARGIN, sum(CTC) as CTC from PRACTISE.ACTUALPRODAPR19NEW group by REGION_NAME; quit; Thanks.
... View more