• Print |
• E-mail  |
• Bookmark

This FAQ creates a database application and then customizes it with two variations.

Creating a database application that displays the HTML file one record at a time

You can create a simple database application by using the Data Source Object (DSO). This example creates a data island by using PROC TEMPLATE and the XML engine. The data island is an HTML file with XML data banded by the DATASRC and the DATAFLD elements. The DATASRC element takes the ID of the XML document from which the data is banded, and the DATAFLD element takes the name of the field that is banded. This resolves the field to the value of the field. If the underlying data changes, so does the banded value.

To take this application one step further, use the DATAPAGESIZE=1 tag, so that the data is displayed on the page one record at a time. This example modifies the tagset SASXMOG, which is the default tagset used when generating an XML file with the XML engine. View output. View SAS code.

Creating a database application that displays the data one record at a time and also allows editing of the data

This example is an extension of the above application, and it allows the modification the XML file. View output. View SAS code.

Creating a database application that allows real-time sorting and filtering of data

This example is a combination of the prior example, using the Data Source Object (DSO) and XSL and JavaScript. Using the LIBNAME statement and the XML engine, the XML file is generated. The tagset is modified to generate a data island, which is simply XML data within an HTML file. The DSO formats the XML file into the HTML format. XSL in conjunction with JavaScript provides the real-time data management. View output. View SAS code.

See also the full PROC TEMPLATE FAQ and Concepts.

Operating System and Release Information