DDE skill is obsolete, Try LIBNAME. https://communities.sas.com/t5/SAS-Programming/SAS-code-to-update-specific-cell-values-in-Excel/m-p/885125 https://communities.sas.com/t5/SAS-Procedures/exporting-updating-an-excel-file/m-p/331607 https://communities.sas.com/t5/SAS-Programming/Update-Excel-after-I-run-SAS-Script/m-p/737731 ... View more

I believe SAS/Graph Proc Gchart is built to do exactly what you want (including the 'by' groups), without needing any extra processing, etc...   data Have; length home_campu $6; input acadplan $ count1fifth home_campus $; datalines; 155 128 CHSTR 155 9 MIDLO 156 150 MIDLO 156 90 CHSTR 480 99 MIDLO 480 87 CHSTR 212 97 CHSTR 212 64 MIDLO 299 120 CHSTR 299 92 MIDLO 464 135 CHSTR 464 25 MIDLO ; data Have; set Have; label cawardx='Award Level'; cawardx='AAS'; run; axis1 label=(a=90 "Number of Students") order=(0 to 250 by 50) minor=none; axis2 label=('Academic Plan'); pattern1 v=s c=red; pattern2 v=s c=blue; title1 "Chart 3: Annual Five-Year Mean Headroll Enrollment"; proc gchart data=Have; by cawardx; vbar acadplan / sumvar=count1fifth descending subgroup=home_campus raxis=axis1 maxis=axis2 width=5; ... View more

This icon on the message editor is for pasting code   ... View more

Cynthia_sas, thanks for your reply. I have decided to take a different approach to a solution by using a 'by' statement and some pre-report manipulation of the dataset.   Thanks for you help...   Jim ... View more

Hi:   Well, either use the PROC FREQ numbers or use a DATA step or get them from TABULATE.     But I did not mean to imply that you can't do cumulative N or cumulative percent with  PROC REPORT. It is totally possible. See below:   For percent of the group, as the original question showed, a slightly more complex compute block is needed. There's a LONG discussion of percents and percents of groups starting with Example 4 on page 22 of this paper: https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf .   For SASHELP.SHOES, it is possible to do cum count and cumpercent of group  using a slightly different logic, as shown below:   You could always calculate the numbers in a DATA step program, but that frequently means two passes through the data, which is OK if it makes maintenance easier. But PROC REPORT can do the CUM count and CUM percent too.   Hope this helps,   Cynthia ... View more

DBailey, thanks for the reply. I tried your suggestion and it still resolves to variable name not its value. ... View more