I am using macros because I am using a lot of years and different variables. &yr.=year &var.=Program_type. i attached what it produces. I also want another row below it with totals for cohort column and retention rates for entire program should look like this: total: 596 68.27 2000 78.74   proc report data = cretention&yr.&var. split='\'; column Instruction_Method &var.,(count Retention_rate); define Instruction_method / group "Fall Instruction Method" width=8; define &var. / across "&var."; define Count / 'Cohort'; define Retention_rate/ 'Retention Rate'; title "Fall &yr. to Spring Retention Rate by Fall Instruction Method and &var."; run;   thanks ... View more