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

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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