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,
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
Once you have converted your EG code into a stored process, your web application server can run it.
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...
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.