Thanks Kurt, I will investigate the ODS a bit more at some point ... View more

Thanks Reeza, I haven't been able to get my head around this yet but I will have a look soon ... View more

Thanks Reeza, I think I'll come back to this method when I'm a bit more capable ... View more

@RW9 wrote: Left join the count on rather than sub-query then: proc sql; create table WANT as select A.COUNTRY, A.CUSTOMER_PER_COUNTRY, B.TOTAL_CUSTOMERS, A.CUSTOMER_PER_COUNTRY / B.TOTAL_CUSTOMERS * 100 as PCENT from (select COUNTRY,count(distinct CUSTOMER) as CUSTOMER_PER_COUNTRY from HAVE GROUP BY COUNTRY) A left join (select count(distinct CUSTOMER) as TOTAL_CUSTOMERS from HAVE) B on 1=1; quit;       Thanks RW9, I amended that slightly, adding a GROUP BY, and it worked. ... View more