topic Re: Creating a HTML User interface in Graphics Programming

Creating a HTML User interface

Adnan2 — Tue, 12 Nov 2019 16:55:52 GMT

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

Re: Creating a HTML User interface

ChrisNZ — Wed, 13 Nov 2019 03:26:15 GMT

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

Re: Creating a HTML User interface

Quentin — Wed, 13 Nov 2019 13:13:22 GMT

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-Integration-Technologies/ta-p/418253

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

Re: Creating a HTML User interface

GraphGuy — Mon, 18 Nov 2019 14:49:51 GMT

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