{*--------------------------------------------------------------------*}
{* Note: You do not need to save this file from your Web browser. *}
{* This file is available in the htmSQL "samples" subdirectory. *}
{* *}
{* This input file produces a Web page that lists sales information *}
{* that is stored in the 'retail' SAS data set of the SASHELP library.*}
{*--------------------------------------------------------------------*}
htmSQL: Retail Data
{*--------------------------------------------------------------------*}
{* The following section queries the SAS server that is identified by *}
{* the data source and dynamically generates the sales information. *}
{*--------------------------------------------------------------------*}
{query datasrc="retail"}
{sql}
select sales,date,year,month,day
from sashelp.retail where
year = {&PARAM}
{/sql}
{*--------------------------------------------------------------------*}
{* We use a table to show the sales information. *}
{*--------------------------------------------------------------------*}
| Sales |
Date |
Year |
Month |
Day |
{*--------------------------------------------------------------------*}
{* Each row of our results set corresponds to a row in the table *}
{*--------------------------------------------------------------------*}
{eachrow}
| {&sales} |
{&date} |
{&year} |
{&month} |
{&day} |
{/eachrow}
{*--------------------------------------------------------------------*}
{* End the query section. *}
{*--------------------------------------------------------------------*}
{/query}