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
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
?
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
Once you have converted your EG code into a stored process, your web application server can run it.
(http://servername/SASStoredProcess)
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
And what happens when you try to access the web service?
Hi Bremser,
When i hit the URL ,it is showing a blank page.
Thanks & Regards,
Sandeep.o
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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.