https://communities.sas.com/t5/SAS-Programming/i-have-3-outputs-and-want-to-export-them-into-single-excel-with/m-p/313761#M68226 <P>i have 3 outputs and want to export them into single excel with different sheets.&nbsp;</P> <P>&nbsp;</P> <P>Can any one help me easiest way to do then manually doing</P> Wed, 23 Nov 2016 12:57:23 GMT vraj1 2016-11-23T12:57:23Z https://communities.sas.com/t5/SAS-Programming/i-have-3-outputs-and-want-to-export-them-into-single-excel-with/m-p/313761#M68226 <P>i have 3 outputs and want to export them into single excel with different sheets.&nbsp;</P> <P>&nbsp;</P> <P>Can any one help me easiest way to do then manually doing</P> Wed, 23 Nov 2016 12:57:23 GMT https://communities.sas.com/t5/SAS-Programming/i-have-3-outputs-and-want-to-export-them-into-single-excel-with/m-p/313761#M68226 vraj1 2016-11-23T12:57:23Z https://communities.sas.com/t5/SAS-Programming/i-have-3-outputs-and-want-to-export-them-into-single-excel-with/m-p/313764#M68228 Hi, depending on what your outputs are (reports, datasets, etc) you have some choices: <BR />1) LIBNAME engine<BR />2) PROC EXPORT<BR />3) ODS TAGSETS.EXCELXP<BR />4) ODS EXCEL (with SAS 9.4)<BR /><BR />With #1 and #2, you would be doing "data-to-data" export and so would not have any ability to change the colors, fonts, use titles, etc. With #3 and #4 method, you would be sending procedure output to each sheet and have the ability to control colors, fonts, sheet_names, titles, etc. There are plenty of examples of all these methods in previous forum postings.<BR /> <BR />cynthia Wed, 23 Nov 2016 13:01:10 GMT https://communities.sas.com/t5/SAS-Programming/i-have-3-outputs-and-want-to-export-them-into-single-excel-with/m-p/313764#M68228 Cynthia_sas 2016-11-23T13:01:10Z