Solved: Creating a HTML User interface

Adnan2 · Posted 11-12-2019 11:55 AM

Hi All,

I have created a program to collate a number of monthly PDF reports over a certain time period by portfolio type into a singular PDF output via SAS.

What I would like to do is to create a HTML Interface which would enable be select reports for a certain portfolio. For instance if i want to review the reports for portfolio A, I would want be able to select portfolio A from the interface and in return i would get the collated report for portfolio A.

I have only currently got access to Base SAS.

Any ideas would be most welcomed

Thanks

Quentin · Posted 11-13-2019 08:13 AM

You only have BASE SAS, so your thought is that the HTML UI and SAS are running on the same PC? And would you run the SAS job as a batch job or some other way?

For some little reports where you just need to pass a few parameters, you can write the UI in whatever you want (e.g. some .NET language). Then it can submit the windows command to start a SAS batch job, and can pass a few parameters to it via -sysparm or text files or whatever. That might be easier than HTML if your back end is just BASE SAS.

That's probably the most simplistic approach to making a little UI that will call SAS.

More involved / feature rich would be to do stuff with SAS Integration Technologies, but I don't think you get that with just base SAS.

@ChrisHemedinger has a lot of papers/posts about building client apps with Int Tech, e.g.

https://communities.sas.com/t5/SAS-Communities-Library/Create-your-own-client-apps-using-SAS-Integra...

https://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/

BASUG is hosting free webinars Next up: Mark Keintz presenting History Carried Forward, Future Carried Back: Mixing Time Series of Differing Frequencies on May 8. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

View solution in original post

ChrisNZ · Posted 11-12-2019 10:26 PM

It seems to me that you need to learn HTML. It's not a complicated language.

High-Performance SAS Coding - Third Edition

Quentin · Posted 11-13-2019 08:13 AM

You only have BASE SAS, so your thought is that the HTML UI and SAS are running on the same PC? And would you run the SAS job as a batch job or some other way?

For some little reports where you just need to pass a few parameters, you can write the UI in whatever you want (e.g. some .NET language). Then it can submit the windows command to start a SAS batch job, and can pass a few parameters to it via -sysparm or text files or whatever. That might be easier than HTML if your back end is just BASE SAS.

That's probably the most simplistic approach to making a little UI that will call SAS.

More involved / feature rich would be to do stuff with SAS Integration Technologies, but I don't think you get that with just base SAS.

@ChrisHemedinger has a lot of papers/posts about building client apps with Int Tech, e.g.

https://communities.sas.com/t5/SAS-Communities-Library/Create-your-own-client-apps-using-SAS-Integra...

https://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/

BASUG is hosting free webinars Next up: Mark Keintz presenting History Carried Forward, Future Carried Back: Mixing Time Series of Differing Frequencies on May 8. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

GraphGuy · Posted 11-18-2019 09:49 AM

If you just want to create a simple page, which has links to the pdf reports you've already created, you could use Proc Print to print a simple table, and have the text in the table be the names of the reports, and assign url/links to those names.

For example, see the table below this map:
http://robslink.com/SAS/ods7/most_scenic_drive.htm

Here is the code I used (you can ignore the map stuff - just look at the 2 sections of code below the proc sgmap:

http://robslink.com/SAS/ods7/most_scenic_drive.sas