BookmarkSubscribeRSS Feed
KDLiwen
Calcite | Level 5

Is it possible to create a stored process that I can call from SAS Add-ins for Microsoft Office that will read a Excel 2007 that I have edited and write out a dataset to our database in a UNIX environment.  We do not have SAS Access to PC Files or SAS/Connect.  I am currently doing this process manually from Enterprise Guide but the user does not want his staff using EG, and wants them to basically 'push a button' in Excel to move the data to UNIX.  If it is possible, I would appreciate any input.

1 REPLY 1
KDLiwen
Calcite | Level 5

Oh, sorry.  And let me add that he doesn't want the users manually uploading the data themselves.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 1 reply
  • 775 views
  • 0 likes
  • 1 in conversation