Updating my post. I was able to figure-out a solution for this problem, using a macro which pulls specific cells from the proc surveyfreq ods output table. It took me a long tie to create the macro, but eventually I got it done. In the example above, there are 4 possible values for the independent predictor variable "RaceEthnicity" and 5 possible values for the dependent/outcome variable "response." So in order to create my formatted table, I needed to first understand the following logic.  After I did that, it was easy to create a macro based on a series of do/to/end statements. %macro mergetables(indepvariable,outcomevariable,out_tablename,maxrowvals,maxcolvals,tablenum); %let currentcolval=1; %do currentcolval = 1 %to &maxcolvals ;   data merged_col&currentcolval&outcomevariable;   %let string2 = &outcomevariable&currentcolval;   set %do currentrow=1 %to %eval(&maxrowvals +1); &string2&currentrow %end; ;   run;   proc datasets;   delete %do currentrow=1 %to %eval(&maxrowvals +1); &string2&currentrow %end; ;   run; %end; %let currentcolval=1;   data pre&tablenum&outcomevariable&indepvariable;   merge %do currentcolval=1 %to  &maxcolvals ; merged_col&currentcolval&outcomevariable %end; ;   by F_&indepvariable;   run;   proc datasets;   delete %do currentcolval=1 %to &maxcolvals ; merged_col&currentcolval&outcomevariable %end; ;   run; %let currentrowval=1; data  &tablenum&outcomevariable&indepvariable; merge pre&tablenum&outcomevariable&indepvariable %do currentrowval=1 %to %eval(&maxrowvals +1); For_n_of_row&currentrowval %end; ; by F_&indepvariable; run; /*  EXPORT THE DATASET '&tablenum&outcomevariable&indepvariable' saved as '&tablenum&out_tablename' */ PROC EXPORT DATA=WORK.&tablenum&outcomevariable&indepvariable             OUTFILE= "C:\Documents and Settings\user\Desktop\save_exports\&tablenum&out_tablename"             DBMS=EXCEL5 REPLACE; RUN; /*  EXPORT THE DATASET of proc surveyfreq statistics '&out_tablename' */ PROC EXPORT DATA=WORK.&out_tablename             OUTFILE= "C:\Documents and Settings\gjbautista\Desktop\save_exports\psfd\&tablenum&out_tablename"             DBMS=EXCEL5 REPLACE; RUN; %let currentrowval=1; proc datasets; delete pre&tablenum&outcomevariable&indepvariable %do currentrowval=1 %to %eval(&maxrowvals +1); For_n_of_row&currentrowval %end; ; run; %mend mergetables; /*   Call the macro    */ %mergetables(raceethnicity,response,T_01_psfd_racexresponse,4,5,T_01); ... View more