Your SAS programs, embedded in web apps and elsewhere

Stored process integration with web server

Reply
Contributor
Posts: 61

Stored process integration with web server

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

Super User
Posts: 7,758

Re: Stored process integration with web server

Posted in reply to sandeep_reddy

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

?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 61

Re: Stored process integration with web server

Posted in reply to KurtBremser

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

Super User
Posts: 7,758

Re: Stored process integration with web server

Posted in reply to sandeep_reddy

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

(http://servername/SASStoredProcess)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 61

Re: Stored process integration with web server

Posted in reply to KurtBremser

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

Super User
Posts: 7,758

Re: Stored process integration with web server

Posted in reply to sandeep_reddy

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 61

Re: Stored process integration with web server

Posted in reply to KurtBremser

Hi Bremser,

 

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

 

Thanks & Regards,

Sandeep.o

Frequent Contributor
Posts: 106

Re: Stored process integration with web server

Posted in reply to sandeep_reddy

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

Ask a Question
Discussion stats
  • 7 replies
  • 237 views
  • 0 likes
  • 3 in conversation