Here is the answer. First convert into numeric variable sales using input function and use compress function to replace alphabets from value and then use proc sql. Here is the code. Correct me if I am wrong data ds1; infile cards; input Branch $ year sales $; cards; india 2009 1mn india 2009 2mn india 2010 1.2mn nepal 2008 0.5mn nepal 2009 1mn ; data ds2; set ds1; sales1=compress(sales,'','a'); numeric=input(sales1,8.); drop sales; run; proc sql; create table demo as select Branch,year,avg(numeric)as sales from ds2 group by Branch,year ; quit;
... View more