i am having problem for across report for parent child colmuns.
below is the code. there are two columns Currentatt which is parent and
Attend_Stat which is child. i am getting the values wrong. for each cell the calculation is
(sum of individual cell value /sum of row values )*1000.
It almost looks to me like you have nesting at several levels in the columns. Since your code is so lengthy and you have to build absolute column names based on the possible combinations of all the ACROSS variables, it's hard to come up with a solution. My suggestion would be to simplify the code back to the place where you were getting correct numbers with one across variable and then introduce a second across variable into the program.
This is exactly the kind of problem that Tech Support is best able to handle. They can take a copy of your code and an example of your data and help you with the correct solution.
Just another thought...have you tried this report with PROC TABULATE??? The syntax for specifying a denominator definition does not require absolute column numbers when you have nested variables in the column dimension.
To contact Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane click on the link entitled, "Submit a Problem".