The ASP scripting for this site stores these components in the ROS database. At the Development Site, the real work begins as statisticians define and fill out the content. To assemble a new chapter in the publication or compile a new study and fill it with specific SAS-extracted data, such as tables, illustrations, and cited publications, and information regarding research committees, the developers built an ActiveX control called ExecuteSAS using Microsoft Visual Basic version 5.0. ExecuteSAS operates as part of the Development Site's server script. With ExecuteSAS, the site pulls data from the research database, and presents it in the research studies.
Statisticians specify data using forms with drop-down menus, textboxes, and radio buttons.
ExecuteSAS requests data as needed, instead of running a complete batch of every stored procedure. This minimizes the system's data processing while presenting the most current data for the study. The Development Site's ASP scripting combines components from the ROS database and data requested from the research database. The scripting grabs the component from the SQL Server database to add the table to the study, then uses ExecuteSAS to request the necessary data. To demonstrate the complex forms of the data and the functions statisticians perform, a map of the Development Site follows in Figure 3.