insert data into excell sheet

[BartDekeyser]

I would like to know how one can insert data into an excell files using sas studio.

I can export into a new sheet without any problem, but inserting between some rows, i cant find it. 

Some programs i have to use to load data , are using excell with a standard. 

So i would like to know, how can i insert data between A2:A750 in a sheet named sas_output

[VDD]

One way that I insert information into a Excel worksheet ranges is by using DDE.

https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#ddeexamples.htm

[art297]

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:

http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

Art, CEO, AnalystFinder.com