Creating a table with list of selected countries

[danwarags]

Hello Everyone,

I have a dataset with country, sales, formulation as variables. There are numerous observations for each country and formulations (Drug1, Drug2, Drug3 etc). I want to create a table summing up the sales data by unique country and formulation. For example I need the output table as shown below

	Drug1	Drug2	Drug3
EU Total	448	56	4,575
Austria	539	47	657
India	107	88	57
Bulgaria	701	79	20
Newzealand	291	--	653
UK	236	40	456
Denmark	257	234	25
Estonia	3,772	456	456

[Jagadishkatam]

could you please provide sample data of how it looks

May be proc summary like below, could help you
proc summary data =sampledata ;
class country ;
var drug1 drug2 drug3 ;
output out = Sumry sum= ;
run;