BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
SASAlex101
Quartz | Level 8

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; 

1 ACCEPTED SOLUTION

Accepted Solutions
AllanBowe
Barite | Level 11

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

/Allan
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

View solution in original post

2 REPLIES 2
AllanBowe
Barite | Level 11

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

/Allan
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
SASAlex101
Quartz | Level 8
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;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1511 views
  • 3 likes
  • 2 in conversation