White Papers

A Quick and Dirty Query System Using HTML, Proc SQL, and SAS IntrNet

Overview Every SAS programmer needs ad hoc queries to help with debugging or to give results to others. Usually programmers will either write a new program or take an existing program and modify it to generate the report or data they need. This is time consuming and can lead to errors. The system described in this paper allows any user to query a database or SAS dataset without writing a SAS program. The system uses basic HTML, proc sql, SAS Macros, and SAS IntrNet to provide programmers and end users with an interactive web page that allows them to enter various parameters to query a database or dataset. The output format can be raw data, data listings or frequency counts.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
Constella Group
File Format
PDF
Date Published
Dec 4, 2008
Format
White Papers
Topics
HTML, Programming Languages, Database Management