Stored process integration with web server

[sandeep_reddy]

Dear Team,

I have created one stored process and i am trying to integrate with SAS web server. I have followed some sample steps in the following URL https://libraries.io/github/Boemska/sas-hot-editor.

Requirement is  , a user needs to select the path of a .csv file and a column from csv file  needs  to be updated in a database table. 

Thanks & Regards,

Sandeep

[Kurt_Bremser]

So you need

- a prompt for a filename

- import that file to a SAS dataset

- update an existing dataset with data from the imported dataset

?

[sandeep_reddy]

HI Bremser,

Thanks For your Reply,

I have tested from SAS E.G and my code is working fine by giving a location in prompt. I need to link this stored process with existing  web server.

Thanks & Regards,

Sandeep

[Kurt_Bremser]

Once you have converted your EG code into a stored process, your web application server can run it.

(http://servername/SASStoredProcess)

[sandeep_reddy]

Hi Bremser,

AS in attached document i have followed the steps,but still i am not able to access. The mentioned code in the document is sample one.

Thanks & Regards,

Sandeep

[Kurt_Bremser]

And what happens when you try to access the web service?

[sandeep_reddy]

Hi Bremser,

When i hit the URL ,it is showing a blank page.

Thanks & Regards,

Sandeep.o

[boemskats]

Sandeep,

What exactly are you trying to do? The link you pasted points to an app that we built, but the steps there are deployment steps specific to that app - you shouldn't have to create any more stored processes or do any further integration. Following just some steps from that page really won't get you very far. 

The original app and instructions can be found at https://github.com/Boemska/sas-hot-editor, but you must either have your csv data already in a dataset, or point the editor to a database.

What I'm most curious to find out is.... how did you come across this project? We've barely advertised it to anyone...

Nik