BookmarkSubscribeRSS Feed
BartDekeyser
Calcite | Level 5

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

 

2 REPLIES 2
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

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
Opal | Level 21

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

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

SAS Enterprise Guide vs. SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 697 views
  • 1 like
  • 3 in conversation