I have a couple stored processes to fetch a SAS dataset and then display it on the web in a jqGrid object. My jqGrid example allows for edits, adds, and deletes. I'd like to pass these edits, adds, and deletes back to my SAS dataset. Does anyone know how to accomplish this?
I suspect I may need to change the editurl option and use another stored process?
I hope to use the boemska tools once I get more admin privileges.
If you're looking for a 'ready made' solution to what you describe, I would refer you to https://datacontroller.io
If you're looking for an 'admin not necessary' approach to building & deploying web apps, you can also consider the SASjs framework - specifically, the 'streaming app' capability. This compiles a frontend into a series of STPs, obviating the need for a web server (and requisite access rights).
Happy to jump on a call to explain further.
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.