Thanks for the response! I am splitting my datasets into several workbooks each with about 5 tabs. I have tried to adjust the export code in a similar manner, but each export overwrites the previous export. Hope I am making sense. I have 5 datasets I split out the way you indicate above and then try to split them out in a similar manner with PROC EXPORT. I can't figure out why the sheets are overwriting.

Also, on another note...what does the 'kad' mean that you put after the &column macro?
Thank you again!!

/*Export*/
proc sql;
/* build a mini program for each value */
/* create a table with valid chars from data value */
select distinct
cat('PROC EXPORT DATA=DELQ_', compress(&COLUMN.,,'kad'),
' FILE = ', '"~/shared_data/120day/avn/&USER_LC./export_folder/Delq_Notice_Rpt_',
compress(&COLUMN.,,'kad'),'_YYYY-MM.XLSX"', ' DBMS=XLSX REPLACE'),
cat("; SHEET = ", '"OPEN_PO_AND_DELQ"', "; RUN;")
into :prcexprt separated by ';'
from &TABLE.;
quit;

/* macro that includes the program we just generated */
%macro runsteps;
&prcexprt.;
%mend;

/* and...run the macro when ready */
%runSteps;