About MJGriggs

MJGriggs · ‎10-03-2023

So in Column H, all of the records for one account will add up to 100%. Those individual percentages are then used to take Other Data to a newly created State level.

MJGriggs · ‎10-03-2023

The numerator is the first occurrence of Data, the denominator is the sum of all of the Data records that match the same Account and State.

MJGriggs · ‎10-03-2023

SAS PROC SQL is the only tool I have to work with.

MJGriggs · ‎10-03-2023

I don't have any SAS code to share because I haven't figured this out - but hopefully the screenshot will provide enough context of what I'm attempting to do.

MJGriggs · ‎10-03-2023

I have 9 data sources joined; some of them are at Account/State level and some are only at Account level. I need to be able to calculate the percentage of sales by Account/State in the base data set so that I can apply that percentage to other Account-only level variables to approximate an Account/State value for numerators and denominators. The attached Excel file shows how the formula would work, but I need to translate this to PROC SQL. Anyone have any ideas? Any help is greatly appreciated.

Online Status	Offline
Date Last Visited	‎10-12-2023 01:13 PM

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

Re: PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE

PROC SQL PERCENT OF SALES BY ACCOUNT AND STATE