topic Re: exporting sas table to existing excel file in SAS Programming https://communities.sas.com/t5/SAS-Programming/exporting-sas-table-to-existing-excel-file/m-p/209016#M38813 <HTML><HEAD></HEAD><BODY><P>Proc export doesn't really have that option unless you want to create a new sheet.&nbsp; You can update exisiting Excel workbooks by use of libname see:</P><P><A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf" title="http://www2.sas.com/proceedings/sugi31/024-31.pdf">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A></P><P></P><P>However it depends on what you want to do.&nbsp; What is in the existing spreadsheet, is it tabular format or all mixed up.&nbsp; You may find that its easier to export any data from SAS to CSV, then in your workbook write a VBA macro to import that data and process it into your file.&nbsp; Remember, SAS deals with fixed structure datasets, much like a database.&nbsp; Excel does not, it allows anything.&nbsp; Therefore the two are not necessarily useable from the other.</P></BODY></HTML> Tue, 24 Mar 2015 15:23:04 GMT RW9 2015-03-24T15:23:04Z exporting sas table to existing excel file https://communities.sas.com/t5/SAS-Programming/exporting-sas-table-to-existing-excel-file/m-p/209015#M38812 <HTML><HEAD></HEAD><BODY><P>hello</P><P>there is any option of export procedure to export tables to existing excel files ?</P></BODY></HTML> Tue, 24 Mar 2015 15:09:08 GMT https://communities.sas.com/t5/SAS-Programming/exporting-sas-table-to-existing-excel-file/m-p/209015#M38812 fadel 2015-03-24T15:09:08Z Re: exporting sas table to existing excel file https://communities.sas.com/t5/SAS-Programming/exporting-sas-table-to-existing-excel-file/m-p/209016#M38813 <HTML><HEAD></HEAD><BODY><P>Proc export doesn't really have that option unless you want to create a new sheet.&nbsp; You can update exisiting Excel workbooks by use of libname see:</P><P><A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf" title="http://www2.sas.com/proceedings/sugi31/024-31.pdf">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A></P><P></P><P>However it depends on what you want to do.&nbsp; What is in the existing spreadsheet, is it tabular format or all mixed up.&nbsp; You may find that its easier to export any data from SAS to CSV, then in your workbook write a VBA macro to import that data and process it into your file.&nbsp; Remember, SAS deals with fixed structure datasets, much like a database.&nbsp; Excel does not, it allows anything.&nbsp; Therefore the two are not necessarily useable from the other.</P></BODY></HTML> Tue, 24 Mar 2015 15:23:04 GMT https://communities.sas.com/t5/SAS-Programming/exporting-sas-table-to-existing-excel-file/m-p/209016#M38813 RW9 2015-03-24T15:23:04Z