You might want to consider: ODS EXCEL FILE="C:\my\outputfile.xlsx" options (sheet_interval='PAGE') ods exclude directory; ods exclude members; proc contents data=sashelp._all_ memtype=data; run; ODS EXCEL CLOSE;     If you insist on naming and providing titles then you will need to 1) get a list of datasets 2) set the sheet_name for each individual table 3) set the title text for each proc contents call 4) call proc contents   The above can be done with CALL EXECUTE statements with the data set names in a control file or Macro coding.   Why? The use of the #BY directives ONLY work with a single data set at a time with BY group processing for a single Proc. So you could not use simply by groups to get the desired output. Which will not allow you to have data from three different datasets within a single by group. ... View more