topic Re: Export to Multiple Excel Worksheets in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Export-to-Multiple-Excel-Worksheets/m-p/173149#M44604 <HTML><HEAD></HEAD><BODY><P>Either works, I'd recommend a single dataset.</P><P></P><P>Having each data set is a manual process and having them all in one allows you to use the BY group processing. </P><P></P><P>See the Data driven sheet example and the manual multiple worksheet examples here:</P><P></P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A> </P></BODY></HTML> Mon, 26 May 2014 14:57:08 GMT Reeza 2014-05-26T14:57:08Z Export to Multiple Excel Worksheets https://communities.sas.com/t5/SAS-Procedures/Export-to-Multiple-Excel-Worksheets/m-p/173148#M44603 <HTML><HEAD></HEAD><BODY><P>Hello I am using SAS version 9.3 and EG version 5.1. I have seen some of the other posts about exporting to multiple worksheets in Excel, which I will try, but I'm not sure how to save the data to know what is per worksheet. I have a data set of patient data and I am running various data quality checks on it.&nbsp; The required fields for each criteria may differ but I want each criteria to be its own Excel worksheet.&nbsp; So do I save each criteria as its own dataset to be sent to Excel as a separate worksheet or do I create one dataset&nbsp; with a column of "DQ flag" to identify the criteria the case matches?&nbsp; Thanks.</P></BODY></HTML> Mon, 26 May 2014 14:48:36 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Multiple-Excel-Worksheets/m-p/173148#M44603 shellp55 2014-05-26T14:48:36Z Re: Export to Multiple Excel Worksheets https://communities.sas.com/t5/SAS-Procedures/Export-to-Multiple-Excel-Worksheets/m-p/173149#M44604 <HTML><HEAD></HEAD><BODY><P>Either works, I'd recommend a single dataset.</P><P></P><P>Having each data set is a manual process and having them all in one allows you to use the BY group processing. </P><P></P><P>See the Data driven sheet example and the manual multiple worksheet examples here:</P><P></P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A> </P></BODY></HTML> Mon, 26 May 2014 14:57:08 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Multiple-Excel-Worksheets/m-p/173149#M44604 Reeza 2014-05-26T14:57:08Z