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,128

Re: Creating a table with list of selected countries

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
  • 152 views
  • 0 likes
  • 2 in conversation