Hi:
I did not open your Excel file -- it's more useful to have a DATA step program that creates your data, so I do not have to write a program to read the data.
However, do any of your demographic reports look like Examples for #1 (page 9) , or Example #8 (page 17) in this paper: https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf ?? If so, I had to restructure the data and add some "helper" variables to produce the final output from PROC REPORT for #1 and DATA _NULL_ for #8.
For challenges with ACROSS, this paper is useful: https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf and for working with COMPUTE blocks, this paper has some good tips: https://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf .
After the spare elegance of TABULATE syntax, PROC REPORT can seem wordy and overly complicated to some folks. But the ability to customize the breaks, add lines and compute new columns directly in the REPORT syntax are things that you can't do with TABULATE. I don't know whether you need any of those things, since I can't visualize your data from your description or what it is your desired report needs to look like.
Hope the papers point you to more info about PROC REPORT.
Cynthia
... View more