topic Re: Creating a table with list of selected countries in SAS Programming https://communities.sas.com/t5/SAS-Programming/Creating-a-table-with-list-of-selected-countries/m-p/269790#M53492 could you please provide sample data of how it looks<BR /><BR />May be proc summary like below, could help you <BR />proc summary data =sampledata ;<BR /> class country ;<BR /> var drug1 drug2 drug3 ;<BR /> output out = Sumry sum= ;<BR />run; Wed, 11 May 2016 16:33:30 GMT Jagadishkatam 2016-05-11T16:33:30Z Creating a table with list of selected countries https://communities.sas.com/t5/SAS-Programming/Creating-a-table-with-list-of-selected-countries/m-p/269779#M53489 <P>Hello Everyone,</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Drug1</TD><TD>Drug2</TD><TD>Drug3</TD></TR><TR><TD>EU Total</TD><TD>448</TD><TD>56</TD><TD>4,575</TD></TR><TR><TD>Austria</TD><TD>539</TD><TD>47</TD><TD>&nbsp;657</TD></TR><TR><TD>India</TD><TD>107</TD><TD>88</TD><TD>57</TD></TR><TR><TD>Bulgaria</TD><TD>701</TD><TD>79</TD><TD>20</TD></TR><TR><TD>Newzealand</TD><TD>291</TD><TD>--</TD><TD>&nbsp;653</TD></TR><TR><TD>UK</TD><TD>236</TD><TD>40</TD><TD>&nbsp;456</TD></TR><TR><TD>Denmark</TD><TD>257</TD><TD>234</TD><TD>25</TD></TR><TR><TD>Estonia</TD><TD>3,772</TD><TD>456</TD><TD>&nbsp;456</TD></TR></TBODY></TABLE> Wed, 11 May 2016 16:12:35 GMT https://communities.sas.com/t5/SAS-Programming/Creating-a-table-with-list-of-selected-countries/m-p/269779#M53489 danwarags 2016-05-11T16:12:35Z Re: Creating a table with list of selected countries https://communities.sas.com/t5/SAS-Programming/Creating-a-table-with-list-of-selected-countries/m-p/269790#M53492 could you please provide sample data of how it looks<BR /><BR />May be proc summary like below, could help you <BR />proc summary data =sampledata ;<BR /> class country ;<BR /> var drug1 drug2 drug3 ;<BR /> output out = Sumry sum= ;<BR />run; Wed, 11 May 2016 16:33:30 GMT https://communities.sas.com/t5/SAS-Programming/Creating-a-table-with-list-of-selected-countries/m-p/269790#M53492 Jagadishkatam 2016-05-11T16:33:30Z