BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Adnan2
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

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/

 

The Boston Area SAS Users Group is hosting free webinars!
Next up: Joe Madden & Joseph Henry present Putting Power into the Hands of the Programmer with SAS Viya Workbench on Wednesday Nov 6.
Register now at https://www.basug.org/events.

View solution in original post

3 REPLIES 3
ChrisNZ
Tourmaline | Level 20

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

Quentin
Super User

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/

 

The Boston Area SAS Users Group is hosting free webinars!
Next up: Joe Madden & Joseph Henry present Putting Power into the Hands of the Programmer with SAS Viya Workbench on Wednesday Nov 6.
Register now at https://www.basug.org/events.
GraphGuy
Meteorite | Level 14

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1613 views
  • 2 likes
  • 4 in conversation