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 |
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.