BookmarkSubscribeRSS Feed
charlie_russell
Calcite | Level 5
I am having the hardest time using data from an existing Excel spreadsheet in a stored process created in Enterprise Guide. I don't understand how to create a stored process which imports my current Excel data and uses that in the process to get new output. Any help would be appreciated!
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
Hi:
Since your stored process executes on either the Stored Process server or the Workspace server, these servers do not generally have visibility of or access to files on your local computer's C: drive.

A similar question came up on the forum. Refer to this thread:
http://support.sas.com/forums/thread.jspa?messageID=2821ଅ

The suggested workaround was to FTP the local file to the appropriate server. Tech Support is probably your best bet for help with this question.

Good luck,
cynthia
charlie_russell
Calcite | Level 5
Cynthia,

Thanks for your help. Tech support got me on the right track!
deleted_user
Not applicable
I'm having a similar issue. I'd like to be able to execute a stored process from an Excel spreadsheet and have the stored process pick up the data in the spreadsheet as the starting point to the process.

It sounds like that's not possible because the stored process server won't recognize the location of the data? So the user will have to store the data out on a drive and then run the stored process and direct it to the location of the data?

Anyone have any other ideas around this?
Cynthia_sas
SAS Super FREQ
Hi:
Tech Support is probably your best bet for help with this question.
cynthia

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 862 views
  • 0 likes
  • 3 in conversation