DATA Step, Macro, Functions and more

Creating a table with list of selected countries

Reply
Contributor
Posts: 44

Creating a table with list of selected countries

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

 

 Drug1Drug2Drug3
EU Total448564,575
Austria53947 657
India1078857
Bulgaria7017920
Newzealand291-- 653
UK23640 456
Denmark25723425
Estonia3,772456 456
Trusted Advisor
Posts: 1,137

Re: Creating a table with list of selected countries

Posted in reply to danwarags
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;
Thanks,
Jag
Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation