topic Re: Create HTML and get the values in SAS Enterprise Guide

Create HTML and get the values

DEBE — Mon, 16 Apr 2018 10:54:28 GMT

Hello, is it possible to create a html with a input field...or perhaps with a checkbox field, where some variables can be checked and these values get associated with a macro or perhaps with into :variable?

I have EG and not many rights...i would like to store the html in C:Test..whatever and not on a server or elsewhere.

Google shows me some results, but there are many with stored processes..i would like to get the thing first done on a very simple way.

So 1. HTML...2. get the Values which are typed in or can be selected with a checkbox.

Re: Create HTML and get the values

Kurt_Bremser — Mon, 16 Apr 2018 10:59:48 GMT

Creating a HTML page for input, and then run SAS code depending on that input, is the job for SAS stored processes, as you need an interface between the HTML user agent (the browser) and SAS, and that's what the SAStoredProcess webapp (via SAS Web Server and SAS Web Application Server) does.

A .html file on your PC won't have any means to access SAS on the server.

Re: Create HTML and get the values

RW9 — Mon, 16 Apr 2018 11:00:48 GMT

Not easily. Why are you wanting this? Is it just to get macro items into your code, then use EG prompts.

http://support.sas.com/resources/papers/proceedings13/028-2013.pdf

If its more complex than that then you need to look at some sort of server backend with stored processes:

http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/index.html

I suspect if your not the admin this isn't what you would be looking at anyways, and that your problem is a lot simpler. Perhaps supply a use case?

Re: Create HTML and get the values

DEBE — Mon, 16 Apr 2018 11:19:27 GMT

I know how to work with prompts, but at this point i dont need them.

The layout for now is very simple.

1. You can input Name,Cars etc. and "Name" "Cars" need to be stored.

2. Name and Cars can be checked, in this "case" Name would be stored.

Im not sure how to start on that and if there is another way, but the best way would be a HTML file, so that a user can check it.

Re: Create HTML and get the values

Kurt_Bremser — Mon, 16 Apr 2018 11:23:40 GMT

That's exactly what user defined prompts do. Don't reinvent the wheel.

If you need something for "simple" users to work semi-automatically with SAS (without EG in the middle), then the stored processes and their web-interface are the way to go.

Re: Create HTML and get the values

DEBE — Mon, 16 Apr 2018 11:33:12 GMT

I know that prompts can do that...but i need some page or whatever, so that a user from elsewhere can put some values in and these values i need to get.

So i need the stored processes? Is there a good guide out there?

But the HTML needs than be put to a webserver, or can someone from outside get access to the HTML?

Re: Create HTML and get the values

andreas_lds — Mon, 16 Apr 2018 13:07:38 GMT

The "user from elsewhere" is the person that executes the sas program after he/she "put some values in"?

If not: why can't the "user from elsewhere" write the values in an text-file?

Re: Create HTML and get the values

AlanC — Mon, 16 Apr 2018 13:28:29 GMT

Kurt,

You can access SAS outside of this but the general point is taken. You do not have to go back to SAS through their defined means to get to a SAS executable. You can also use IOM and do it via alternatives like ASP.NET, Node.js, et al.

SAS stored processes is a means of doing it but it is not required. It is just simpler for most SAS users.