Hi, when you do a "true" EXPORT, you are sending SAS data format to other data format (for example SAS data format exported to SPSS data format, or SAS data format exported to DBF data format or SAS data format to Excel data format) You do a true data-to-data export with PROC EXPORT or the SAS Libname engine. In that scenario, then your two separate tables (data tables from OUT=) would NOT be placed side by side. However, as shown by PGStats, when you move to a REPORT format, for some (but not all) destinations, you can get "side by side" REPORT tables (not data tables). As far as ODS CSV, there is no support of the COLUMNS=2 option. That option is only for RTF/PDF, which are paged destinations and have the controls to do multi-column REPORT documents. When you use ODS, you have several methods to create ASCII text REPORT files -- either CSV, HTML or XML -- that Excel knows how to open and render. Unless you post process the CSV output (such as suggested by Xia), ODS CSV does not support the COLUMN option. ODS HTML does not support the COLUMN option. There is an ODS Destination called ODS HTMLPANEL, that will produce columnar output -- but the output is meant to be opened in a browser. I believe that the other destinations -- like ODS TAGSETS.EXCELXP and the experimental ODS EXCEL will put each TABULATE output on a separate worksheet, not side-by-side. So, in the end, it remains to be seen whether you want a SAS data-to-Excel data output or a SAS output report-to-Excel report document output. You might be able to use the PROC EXPORT or Libname engine methods to write named ranges side-by-side -- but that generally means you have to create the named ranges first. cynthia
... View more