BookmarkSubscribeRSS Feed
Calcite | Level 5



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.




Quartz | Level 8

Hey Aaron, 

Without Boemksa
I would recommend to use instead of jqGrid. The implementation is much easier. In any case, you use ajax to get or update your data. Ajax supports most of the main HTML verbs. The two most useful for you are POST/GET. The key difference between them is that the parameters provided in URL for GET method and in the body for POST method. 
As for implementation, you could use one or several stored procedures.  
For several stored procedures, you could have end points such as getData, deleteData, updateData that correspond to different stored procedures all of which execute the specific operation and have separate logic.
For single stored procedure, you could use a collection of marcros where a single get/post parameter triggers the required stored procedure.
For example imagine the folloing SAS code:
%MACRO getData; 
%MACRO updateData;
Now you just need to pass a service name to your stored procedure to trigger the part that you care about. For example, This will pass parameter "service" and it will resolve the macro variable service in the code above the the macro that you want to run. 
With Boemska
The development method with Boemska is different. To begin with, I would recommend to get their excellent SAS Hot Editor working that you can find here: Once you have this working, check their API documentation ( and have a look how the editor is working. 
Sorry, I couldn't help you with jqGrid, trust me, this is not the best framework to use. 
For more information about {An}alytium, visit
Barite | Level 11

Hi Aaron,


If you're looking for a 'ready made' solution to what you describe, I would refer you to


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.


SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs



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. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1 like
  • 3 in conversation