Upload Excel into SAS Portal

Reply
Occasional Contributor
Posts: 19

Upload Excel into SAS Portal

Hello -

Is it possible to upload an excel file via a stored process running from the SAS portal?  For example, I'd like to be able to create a stored process that prompts for a excel file location, then have the stored process import & manipulate the excel file, and ultimately have it populate a SAS dataset.

Is this do-able?  Please let me know if there is documentation anywhere that explains how to do so.

Thanks!

George   

SAS Super FREQ
Posts: 709

Re: Upload Excel into SAS Portal

Hi

Please have a look at this discussions , it has sample code to build a SAS Stored Process, that allows you to upload a file

Occasional Contributor
Posts: 19

Re: Upload Excel into SAS Portal

Posted in reply to Bruno_SAS

Thanks Bruno - when I try to run this, I get the following error message... any thoughts as to how I can avoid this?

ERROR: Insufficient authorization to access E:\SAS\MAConfig\Lev1\SASApp\_webout.dat.

Thanks!

SAS Super FREQ
Posts: 709

Re: Upload Excel into SAS Portal

Did you run the code as SAS Stored Process?

Do not include the Stored Process macros %stpbegin and %stpend in your code

Ask a Question
Discussion stats
  • 3 replies
  • 454 views
  • 0 likes
  • 2 in conversation