topic Populate combobox from SAS table in Developers

Populate combobox from SAS table

SASAlex101 — Tue, 15 Aug 2023 21:36:12 GMT

I have a webpage using SAS web services that were building to call stored processes from. The stored processes take in parameters for the reports they generate. As of now, we're hard coding the list of values into Box1 combobox within the webpage itself. However, what I would like is to have the comboboxes populate with the values of a SAS table say... xNames.sas7bdat on the SAS server. This way we can control the values of the combobox directly from SAS or automate the refresh of values daily..

We're using nodejs and the react framework and our page is going to be hosed on a TomCat Server. Wondering if any has been any info on this topic of populating comboboxes with SAS column values.

Thx;

Re: Populate combobox from SAS table

AllanBowe — Wed, 16 Aug 2023 12:21:53 GMT

You just need to send those data values back to the _webout fileref in JSON format. This macro can help: https://core.sasjs.io/mm__webout_8sas.html

Here is a seed app in react that does exactly as you describe: https://github.com/sasjs/react-seed-app/

You could also deploy our data management SAS app, free for unlimited users, but written in angular, that has many such examples: https://datacontroller.io

Re: Populate combobox from SAS table

SASAlex101 — Wed, 16 Aug 2023 20:48:23 GMT

This is great. Awesome code library. I can appreciate the time it took to create it. I have registered an SP with the macros you mentioned. It returns a JSON formatted thing. We can then use react to populate a combo box with that response. Thanks again;