New to SAS -- I know this is probably silly to most of you but it's taken me hours. I have a dataset that looks like this: COMMODITY COUNTRY QUANTITY1 QUANTITY2 QUANTITY3 010 ARGENTINA 2 8 3 010 ANDORRA 3 10 2 010 TOTAL FOR ALL COUNTRIES 5 18 5 020 BELGIUM 10 6 30 020 RUSSIA 15 4 20 020 TOTAL FOR ALL COUNTRIES 25 10 50 There are many commodity codes, countries, and quantities, so doing it manually would be a pain. I am trying to use Quantity 1 values as a base quantity (so the others should be untouched) to generate a percentage report to see which country generates what % of world total quantity for a given commodity code. Ideally that would be represented in a different column like so: COMMODITY COUNTRY QUANTITY1 % of total QUANTITY2 QUANTITY3 010 ARGENTINA 2 40% 8 3 010 ANDORRA 3 60% 10 2 010 TOTAL FOR ALL COUNTRIES 5 100% 18 5 020 BELGIUM 15 50% 6 30 020 RUSSIA 15 50% 4 20 020 TOTAL FOR ALL COUNTRIES 30 100% 10 50 Later in my program, the rows that do not exceed 3% will be omitted from the final dataset, so I need this column to be permanent. Thank you so much!
... View more