How to create interactive SAS reports.

[lawilap]

I have created a SAS macro, where I pass several macro parameters and generate an output report. I want to know if there is any way in SAS where I can do it more interactively. For eg, instead of manually opening the SAS code and entering the macro parameters, I can build some interactive dashboard (or something like that) , type or select the parameters and get a nice report from the selected parameters.

[Cynthia_sas]

Hi:
That sounds like the type of thing you can do with:
--SAS/AF or WebAF
--SAS Enterprise Guide and project-level prompts (look at Figure 23/24 in this paper https://support.sas.com/resources/papers/proceedings13/120-2013.pdf to see an example of using Macro variables as prompts in an EG project)
--SAS Stored Processes
--Custom web applications built in Java or ActiveX

Cynthia