Hi @Babloo
Let me first remind you of what I had told you few posts back!
Posted a month ago (112 views) | In reply to Babloo
@Babloo
As a SAS skilled person working with SAS Viya 3.5, My preference would be
1. Use the Task Prompts
2. Optimize my SAS data sets for querying.
The Task Prompts are more mature and provides lots of functionality out of the box (Stored Process Prompting Framework). It's shortens the development time.
But if you are a Web Stack Developer (Web, CSS, JS, Ajax) you may find the developing the HTML page more appealing, but you'll still need to interact with SAS skilled person, and someone who is familiar with how SAS Stored Processes used to work, as they are fundamentally provide the origin of the Task prompts.
Just my 2 cents
With that said, let me remind you, I'm not a JavaScript developer either, I'm familiar with it, but don't practice/use it.
But I'm familiar with Application Design principles and I can tell you, you are going about this the wrong way!
You'll be much better off adopting MVC (Model-Viewer-Controller) App design paradigm for this quest of yours. Let me break it down for you
Viewer: JavaScript Function that controls which SAS back-end program to call, and which HTML drop-down Single/Multiple select widgets to populate with the returned JSON Response from the SAS Server
Model: SAS Program/Macro that knows about which data set(s) needs to used and how it needs to be manipulated/processed
Controller: SAS back-end program that gets called by the Front-End Viewer, and figures out what to do based on the passed parameters to it, which Model to call/execute and generate the required JSON response in the required format
If all of the above is beyond/outside your skills set, then I would highly recommend you ask your management team to hire someone with those skills sets to help with achieving your projects objectives/goals.
That's all I can advise/help you with for now.
Good luck
... View more