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
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://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/
It seems to me that you need to learn HTML. It's not a complicated language.
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://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/
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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.