https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609054#M8446 <P>One way that I insert information into a Excel worksheet ranges is by using DDE.</P> <P><FONT style="background-color: #ffffff;"><A href="https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#ddeexamples.htm" target="_blank">https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#ddeexamples.htm</A></FONT></P> <P>&nbsp;</P> Tue, 03 Dec 2019 14:19:41 GMT VDD 2019-12-03T14:19:41Z https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609017#M8443 <P>I would like to know how one can insert data into an excell files using sas studio.</P> <P>&nbsp;</P> <P>I can export into a new sheet without any problem, but inserting between some rows, i cant find it.&nbsp;</P> <P>&nbsp;</P> <P>Some programs i have to use to load data , are using excell with a standard.&nbsp;</P> <P>&nbsp;</P> <P>So i would like to know, how can i insert data between A2:A750 in a sheet named sas_output</P> <P>&nbsp;</P> Tue, 03 Dec 2019 11:40:42 GMT https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609017#M8443 BartDekeyser 2019-12-03T11:40:42Z https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609054#M8446 <P>One way that I insert information into a Excel worksheet ranges is by using DDE.</P> <P><FONT style="background-color: #ffffff;"><A href="https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#ddeexamples.htm" target="_blank">https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#ddeexamples.htm</A></FONT></P> <P>&nbsp;</P> Tue, 03 Dec 2019 14:19:41 GMT https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609054#M8446 VDD 2019-12-03T14:19:41Z https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609074#M8447 <P>If you're on Windows then take a look at the exportxl macro. I think it can do everything that you described. You can download it from:</P> <P><A href="http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS" target="_blank" rel="nofollow noopener noreferrer">http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS</A></P> <P>&nbsp;</P> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Tue, 03 Dec 2019 15:00:37 GMT https://communities.sas.com/t5/SAS-Studio/insert-data-into-excell-sheet/m-p/609074#M8447 art297 2019-12-03T15:00:37Z