topic Append the data in the excel in SAS Programming https://communities.sas.com/t5/SAS-Programming/Append-the-data-in-the-excel/m-p/129890#M26508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to append the data in the excel every month on a column wise using Libname excel method.&nbsp;&nbsp;&nbsp;&nbsp; </P><P>For example:i need to append the data everymonth</P><P></P><P>How can i do this..it would be helpfull if you suggest me on the same</P><P></P><P>thanks</P><P>shruthi</P></BODY></HTML> Thu, 31 Oct 2013 10:25:02 GMT shru 2013-10-31T10:25:02Z Append the data in the excel https://communities.sas.com/t5/SAS-Programming/Append-the-data-in-the-excel/m-p/129890#M26508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to append the data in the excel every month on a column wise using Libname excel method.&nbsp;&nbsp;&nbsp;&nbsp; </P><P>For example:i need to append the data everymonth</P><P></P><P>How can i do this..it would be helpfull if you suggest me on the same</P><P></P><P>thanks</P><P>shruthi</P></BODY></HTML> Thu, 31 Oct 2013 10:25:02 GMT https://communities.sas.com/t5/SAS-Programming/Append-the-data-in-the-excel/m-p/129890#M26508 shru 2013-10-31T10:25:02Z Re: Append the data in the excel https://communities.sas.com/t5/SAS-Programming/Append-the-data-in-the-excel/m-p/129891#M26509 <HTML><HEAD></HEAD><BODY><P>1 libname pointing into the rangename in excel (the data to be extended)) </P><P>libname exl 'your_workbook' ;</P><P>2</P><P>proc append base = exl.rangenam1 data= dataset_of_newrows ;</P><P>run ;</P><P></P><P>(but I have no sas/access to pc files to test this)</P></BODY></HTML> Sun, 10 Nov 2013 18:34:06 GMT https://communities.sas.com/t5/SAS-Programming/Append-the-data-in-the-excel/m-p/129891#M26509 Peter_C 2013-11-10T18:34:06Z