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
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
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.