Sorry, I don't open Excel files. It is better to post your data in a DATA step program that anyone can read as a text file. In my example, SASHELP.SHOES has a variable called SALES, in your example, you have a variable called RETAIL_PRICE. Your PROC MEANS code is giving your results the SUM or RETAIL_PRICE grouped by the class variable STORE_POSTCODE. In my examples, SALES is the equivalent of your variable RETAIL_PRICE and REGION is the equivalent of STORE_POSTCODE. In SASHELP.SHOES there are multiple sales for every REGION, so both REPORT and TABULATE are summarizing and calculating percent. Notice in the screen shot below (still using SASHELP.SHOES) how the sum of SALES for each region is the same whether you use PROC MEANS, PROC REPORT or PROC TABULATE. Then notice how the grand total of the SALES figure is the same. Notice how the percents calculate by REPORT and TABULATE are the same. PROC MEANS will provide you with the overall GRAND TOTAL for your RETAIL_PRICE variable, but not in the most usable way possible. READ in the documentation about the use of the _TYPE_ automatic variable. Personally, I find using TABULATE or REPORT much easier than PROC MEANS for sums and percents. cynthia   ... View more