topic Re: SAS access in HTML in SAS Programming

SAS access in HTML

Babloo — Thu, 20 Apr 2023 17:43:24 GMT

Is there any example or reference to the documents to access SAS datasets in HTML and CSS coding to fetch and display the value from SAS dataset to the prompts in web page?

Re: SAS access in HTML

AhmedAl_Attar — Thu, 20 Apr 2023 18:16:14 GMT

Hi @Babloo

Need more info in order to help you out

Do you have SAS Server deployment to access or just bunch of SAS data set?
Do you have a Web Application that needs to display the Prompt values, or this is a Static HTML page?

This kind of information is important in order to properly guide/assist you

Re: SAS access in HTML

Babloo — Thu, 20 Apr 2023 18:31:43 GMT

I'm building the static HTML web page. I have a bunch of SAS datasets.

Re: SAS access in HTML

Kurt_Bremser — Thu, 20 Apr 2023 18:37:59 GMT

Do you have a BI server, enabling you to use stored processes through a web interface, or do you just have a third-party web server, from which you could call SAS in batch mode?

Re: SAS access in HTML

Tom — Thu, 20 Apr 2023 18:39:55 GMT

If you want to generate a static HTML file from a SAS dataset then just use a data step and the PUT statement.

Re: SAS access in HTML

Babloo — Thu, 20 Apr 2023 18:44:43 GMT

Currently I use SAS job execution server
and SAS Viya.

Not sure if this answers your question but this is what I know.

Re: SAS access in HTML

Babloo — Thu, 20 Apr 2023 18:53:43 GMT

I think that you have misunderstood my question.

I'm writing the HTML code at the moment which will create static web page.

Few of the prompts (dropdown) depends on values from the SAS datasets and I
couldn't hard code it in my HTML code as there are numerous values.

How to access SAS datasets in HTML to receive values from SAS datasets?

Re: SAS access in HTML

Reeza — Thu, 20 Apr 2023 19:11:47 GMT

See this paper as a starting point.
https://support.sas.com/resources/papers/proceedings20/4260-2020.pdf

Video @ bottom of page

https://sasjs.io/

Re: SAS access in HTML

Kurt_Bremser — Thu, 20 Apr 2023 19:09:05 GMT

Instead of writing the HTML code, write SAS code which creates the HTML code.

filename htmlfile "path/to/your/file.html";

data _null_;
file htmlfile;
set sashelp.class end=done;
if _n_ = 1
then do;
  put '<html>';
  put '<head>';
  /* put additional header lines, as needed */
  put '</head>';
  put '<body>';
  put '<table>';
  put '<thead>';
  put '<tr>';
  put '<td>Name</td>';
  put '</tr>';
  put '</thead>';
  put '<tbody>';
end;
put '<tr>';
put '<td>' name '</td>';
put '</tr>';
if done
then do;
  put '</tbody>';
  put '</table>';
  put '</body>';
  put '</html>';
end;
run;

Re: SAS access in HTML

AhmedAl_Attar — Thu, 20 Apr 2023 20:03:56 GMT

@Babloo

PS: You would have saved us time and efforts if you had stated you have SAS Viya from the beginning

Look at this article Create a SAS Viya Job with a prompt using Task Prompts

Hope this helps

Re: SAS access in HTML

Babloo — Fri, 21 Apr 2023 07:09:53 GMT

@Kurt_Bremser Good idea. Unfortunately, it's not helping me either. I executed your code just by chnaging the path and dataset name and all I got is below.

There were two observations and 2 variables in my dataset. Should I need to update the HTML code apart from path nad dataset name? Whether this HTML code tells how it is connected to SAS?

<html>
<head>
</head>
<body>
<table>
<thead>
<tr>
<td>Name</td>
</tr>
</thead>
<tbody>
<tr>
<td>. </td>
</tr>
<tr>
<td>. </td>
</tr>
</tbody>
</table>
</body>
</html>

Re: SAS access in HTML

Babloo — Fri, 21 Apr 2023 07:18:11 GMT

@AhmedAl_Attar Thanks for the reference document. However I could not see that the provided link has reference to built HTML webpage using SAS.

Re: SAS access in HTML

Babloo — Fri, 21 Apr 2023 07:21:41 GMT

@Reeza Any other references? Provided link is to build HTML app but I want to build the webpage using HTML code.

Re: SAS access in HTML

Babloo — Fri, 21 Apr 2023 08:55:35 GMT

@Tom Webpage which I developing using HTML code has many prompts in which few prompts are supposed to take values from SAS datasets.

Once I identified (with the help our community) the solution to access SAS tables in HTML, I want to incorporate it in my HTML code. I'm using SAS Viya to execute the SAS programs

Re: SAS access in HTML

AhmedAl_Attar — Fri, 21 Apr 2023 09:23:30 GMT

Hi @Babloo

Have a look at this article Create a SAS Viya Job with a prompt using HTML Prompts

Re: SAS access in HTML

Kurt_Bremser — Fri, 21 Apr 2023 15:24:37 GMT

You need to create the whole page in your SAS program, and use the method I showed to populate the prompt selection in the HTML form, instead of populating a table object.

Re: SAS access in HTML

Babloo — Sat, 22 Apr 2023 08:46:53 GMT

@AhmedAl_Attar Article which you shared is really helpful. However I'd like to give the little backgroud where I need the help. We already have prompts in SAS Viya Job execution. In order to improve the performance and for better UI I was asked to create the standalone webpage using HTML and CSS.

I wrote the HTML code for the prompts where the drop down values are not dependent on the SAS datasets. For few prompts we have numerous values and it is fetching values from SAS datasets. Now I need some help to tackle this scenario?

Re: SAS access in HTML

Kurt_Bremser — Sat, 22 Apr 2023 09:22:59 GMT

Write the HTML code manually first, then look how you can populate it from the dataset. To get help, show the manually written HTML, and post the dataset as a data step with datalines, both in code boxes.

Re: SAS access in HTML

Babloo — Sat, 22 Apr 2023 09:47:49 GMT

@Kurt_Bremser I don't know how to populate the SAS datsaet values in HTML code, hence this post. Hopefully someone of you can help me to move forward. Here is the code snippet of my HTML code which I wrote manually. Please ignore the silly errors as this is only a snippet for you to undertand.

<!DOCTYPE html>
<script type="text/javascript">
  function show_div() {
    document.getElementById('_division_lbl').hidden = false;
    document.getElementById('_division_sel').hidden = false;
  }
  function show_tts() {
    document.getElementById('_dentype_lbl').hidden = false;
    document.getElementById('_dentype_sel').hidden = false;
  }
</script>
<html lang="en">
  <head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>SAS Job</title>
    <link rel="stylesheet" href="css/library.css">
  </head>
  <body role="main" class="jobexec_body">
    <script src="index.js"></script>
    <div class="jobexec_header">Management System</div>
    <form class="jobexec_form" action="/SASJobExecution/" target="_tab">
      <input type="hidden" name="_program" value="$PROGRAM$"/>
      <input type="hidden" name="_action" value="execute"/>
      <input type="hidden" name="_output_type" value="ods_html5"/>
      <div class="jobexec_header_2">SAS<sup>®</sup> Job Execution</div>
      <br />
        <div class="divTableHeading">
          <div class="divTableBody">
            <div class="divTableRow">
              <div class="divTableCell"><label for="_rawdata">Raw Data Required:<span class="required-field"></span></label></div>
              <div class="divTableCell"><label for="_demgroup">Group:</label></div>
              <div class="divTableCell"><label for="_division_sel" id="_division_lbl" hidden>Division:<span class="required-field"></span></label></div>
              <div class="divTableCell"><label for="_dentype_sel" id="_dentype_lbl" hidden>Type:<span class="required-field"></span></label></div>
            </div>
          </div>
          <div class="divTableBody">
            <div class="divTableRow">
              <div class="divTableCell">
                <select name="_rawdata" id="_rawdata" class="jobexec_select">
                  <option value="yes" selected>Yes</option>
                  <option value="no">No</option>
                </select>
              </div>
              <div class="divTableCell">
                <select name="_demgroup" id="_demgroup" class="jobexec_select" onchange="show_div()">
                  <option value="crm" selected>CRM</option>
                  <option value="tts">Sales</option>
                </select>
              </div> 
              <div class="divTableCell">
                <select name="_division" id="_division_sel" class="jobexec_select" onchange="show_tts()" multiple hidden>
                  <option value="ep">sample1</option>
                  <option value="es">sample2</option>
                  <option value="ic">sample3</option>                  
                </select>
              </div>
              <div class="divTableCell">
                <select name="_dentype_sel" id="_dentype_sel" class="jobexec_select" hidden>
                  <option value="tts" selected>Sales</option>
                </select>
              </div>
            </div>
          </div>
        </div>
        <br />	  
    <label for="_odsstyle" >ODS style:</label>
    <select name="_odsstyle" id="_odsstyle" class="jobexec_select">
      [More values here]
      <option value="HTMLBlue" selected>HTMLBlue</option>
      [More values here]
    </select>
  
  <!--<input type="checkbox" name="blanks" id="blanks" value="ExcludeBlanks"
    class="jobexec_input_checkbox"/>
  <label for="blanks">Exclude blank macro variables from the report.</label>-->  
      <br/>
      <hr size="1"/>
      <input type="submit" value="Run Job" class="jobexec_input_submit"/>
      <input type="checkbox" name="_debug" id="_debug" value="log" 
        class="jobexec_input_checkbox"/>
      <label for="_debug">Show SAS Log</label>
    </form>
  </body>
</html>

Now assume I want to introduce some prompts (e.g. product, model) in this HTML code which takes values from SAS dataset, then how to do this? My dataset looks like this.

If I choose one product from the 'product' prompt, then corresponding model number should display in next prompt, 'model'.

Product	Model
Electronics	1
Electronics	2
Electronics	3
Electrical	7
Electrical	9
Medical	6
Medical	10

P.S. I'm sorry for not sending the datastep with datalines and it is due to weekend SAS outage for license renewal.

Re: SAS access in HTML

Kurt_Bremser — Sat, 22 Apr 2023 09:53:29 GMT

So how would the "Product" selection look in your HTML when you write it yourself?