topic Re: how to export two datasets into single excel work sheet without merging two in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214237#M52810 <HTML><HEAD></HEAD><BODY><P>Use ODS TAGSETS.EXCELXP and proc print.</P><P>Caution: Name the file with a .xml extension, or otherwise Excel will complain when opening it.</P></BODY></HTML> Wed, 01 Apr 2015 10:39:07 GMT Kurt_Bremser 2015-04-01T10:39:07Z how to export two datasets into single excel work sheet without merging two https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214236#M52809 <HTML><HEAD></HEAD><BODY><P>Good day all,</P><P>I have two datasets. with different variable names.</P><P>Now i want to export these two datasets into excel within single work sheet.</P><P>without using set statement and merge and not combining the datasets.</P><P>is there any method to using ods to export these datasets into excel within single work sheet.</P><P>i.e. after completion of first dataset output then second dataset output is came.</P></BODY></HTML> Wed, 01 Apr 2015 10:14:51 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214236#M52809 Ravikumarkummari 2015-04-01T10:14:51Z Re: how to export two datasets into single excel work sheet without merging two https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214237#M52810 <HTML><HEAD></HEAD><BODY><P>Use ODS TAGSETS.EXCELXP and proc print.</P><P>Caution: Name the file with a .xml extension, or otherwise Excel will complain when opening it.</P></BODY></HTML> Wed, 01 Apr 2015 10:39:07 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214237#M52810 Kurt_Bremser 2015-04-01T10:39:07Z Re: how to export two datasets into single excel work sheet without merging two https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214238#M52811 <HTML><HEAD></HEAD><BODY><P><A __default_attr="74630" __jive_macro_name="thread" class="jive_macro jive_macro_thread" href="https://communities.sas.com/"></A></P></BODY></HTML> Wed, 01 Apr 2015 11:08:30 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-export-two-datasets-into-single-excel-work-sheet-without/m-p/214238#M52811 Reeza 2015-04-01T11:08:30Z