topic Export w/ Appending in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54708#M15177 <HTML><HEAD></HEAD><BODY><P>Say I have an excel file called direct.xls location c:\MyDocs\ and I have a sas dataset called allfile.&nbsp; Both have the same variables and allfile is not too large for excel.&nbsp; I want to export the sas dataset allfile into my existing direct.xls sheet1.&nbsp; How can I do this with proc append?&nbsp; </P><P></P><P>Thanks in advance.&nbsp; </P></BODY></HTML> Thu, 25 Aug 2011 17:38:20 GMT 1800bigk 2011-08-25T17:38:20Z Export w/ Appending https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54708#M15177 <HTML><HEAD></HEAD><BODY><P>Say I have an excel file called direct.xls location c:\MyDocs\ and I have a sas dataset called allfile.&nbsp; Both have the same variables and allfile is not too large for excel.&nbsp; I want to export the sas dataset allfile into my existing direct.xls sheet1.&nbsp; How can I do this with proc append?&nbsp; </P><P></P><P>Thanks in advance.&nbsp; </P></BODY></HTML> Thu, 25 Aug 2011 17:38:20 GMT https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54708#M15177 1800bigk 2011-08-25T17:38:20Z Export w/ Appending https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54709#M15178 <HTML><HEAD></HEAD><BODY><P>You can do it using the excel engine in a libref assignment.&nbsp; Example code for doing exactly what you want is described in the following paper: <A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A></P></BODY></HTML> Thu, 25 Aug 2011 17:43:45 GMT https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54709#M15178 art297 2011-08-25T17:43:45Z Export w/ Appending https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54710#M15179 <HTML><HEAD></HEAD><BODY><P>Wow, that was fast.&nbsp; Thanks it worked first try for me that is a first.&nbsp; Thanks again.</P></BODY></HTML> Thu, 25 Aug 2011 18:01:21 GMT https://communities.sas.com/t5/SAS-Procedures/Export-w-Appending/m-p/54710#M15179 1800bigk 2011-08-25T18:01:21Z