topic Re: Realtime processing of data from Online form in SAS Programming

Realtime processing of data from Online form

Yiang — Tue, 23 Jan 2024 09:25:14 GMT

at the moment, i collect data using an online survey form.

I want to score the data collected. My scoring algo are all written in a set of scripts in .SAS format.

At the moment, scoring is done offline after i download the data from the online survey form.

If i want to retain the SAS scripts, does anyone have any suggestion how i can achieve realtime scoring ?

I do not know is there any SAS webform that we can submit by a click of a button which will trigger the SAS scripts in a cloud server and then output the scores back to the webform.

One of my colleague was sharing with me that it can be done by converting everything to R Shiny (hence algo to be reengineered into R too). However, R involves alot of packages which i have some reservation using it.

I wish to seek some ideas if i can remain on a SAS platform as my scripts are well validated. thank you

Re: Realtime processing of data from Online form

JosvanderVelden — Tue, 23 Jan 2024 09:56:10 GMT

You'll have to provide details on the SAS Platform you have access to. Is it SAS9.4, SAS9.4 Enterprise Intelligence or a SAS Viya based infrastructure. You'll also have to explain how the survey is made available for the participants. A webform, mobile app, Google doc/form, or ...?

Re: Realtime processing of data from Online form

Yiang — Tue, 23 Jan 2024 10:44:10 GMT

at the moment, i only have SAS 9.4. nothing else.

I am using Qualtric via Web browser as the data collection tool. It can work on mobile phone browser though i refrain running it using the native phone app (because the interface is just not suitable for the kind of scales i am collecting).

However, i am open to subscribing to new SAS services such as Viya or some SAS products etc as long as i

have a single platform where data collected via eg SAS webform (if there is such product) and the scoring scripts can also be run at the same time to return an output onto the screen in realtime. Thank you

I do not know does SAS have such end to end solution for such a scenario.

Re: Realtime processing of data from Online form

ballardw — Tue, 23 Jan 2024 13:41:45 GMT

Now that you have mentioned an actual data source we can look for related items.

https://support.sas.com/resources/papers/proceedings15/3399-2015.pdf

https://www.mwsug.org/proceedings/2015/BB/MWSUG-2015-BB-05.pdf

https://communities.sas.com/t5/SAS-Programming/Qualtrics-to-SAS-API/td-p/537457

May get you started