Web Development With Sas by Example

361 Pages·2006·9.544 MB·English

by  Frederick E. Pratter

Web Development

with SAS
®
by Example
Second Edition
Frederick E. Pratter
The correct bibliographic citation for this manual is as follows: Pratter, Frederick E. 2006. Web Development with
SAS® by Example, Second Edition. Cary, NC: SAS Institute Inc.
Web Development with SAS® by Example, Second Edition
Copyright © 2006, SAS Institute Inc., Cary, NC, USA
ISBN-13: 978-1-59047-501-0
ISBN-10: 1-59047-501-1
All rights reserved. Produced in the United States of America.
For a hard-copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in
any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission
of the publisher, SAS Institute Inc.
For a Web download or e-book: Your use of this publication shall be governed by the terms established by the
vendor at the time you acquire this publication.
U.S. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related
documentation by the U.S. government is subject to the Agreement with SAS Institute and the restrictions set forth in
FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987).
SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.
1st printing, August 2006
SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software
to its fullest potential. For more information about our e-books, e-learning products, CDs, and hard-copy books, visit
the SAS Publishing Web site at support.sas.com/pubs or call 1-800-727-3228.
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS
Institute Inc. in the USA and other countries. DataFlux and all other DataFlux Corporation product or service names
are registered trademarks or trademarks of, or licensed to, DataFlux Corporation in the USA and other countries.
® indicates USA registration.
Other brand and product names are registered trademarks or trademarks of their respective companies.
Contents

Preface ix
Acknowledgments xiii

Part 1 Getting Started with Web
Programming
Chapter 1 SAS and the Internet 3
Introduction 3
TCP/IP and the Internet 5
Markup Languages 7
Deploying Content on the Web Server 8
Using the Apache Web Server on Windows 10
Using the Apache Web Server on UNIX/Linux 11
Using Microsoft Internet Information Server 12
References 12

Chapter 2 Introduction to HTML 15
Hypertext Markup Language 15
HTML vs. XHTML 19
Formatting HTML Using Style Sheets 22
Including User-supplied Information with Forms 25
References 29

Chapter 3 Creating Static HTML Output 31
Introduction 31
Creating Static HTML Output with SAS Tools 34
Displaying Preformatted Text 34
DATA Step Programming for Web Output 36
Macros for HTML Formatting 38
Using the Output Delivery System to Create HTML 48
The ODS HTML Statement in SAS®9 53
Creating Multiple Pages with a Single Program 54
Creating a Table of Contents for Procedure Output 57
Listing the Contents of a Data Set 59
Using Styles to Format ODS Output 60
Using the ODS Markup Statement to Create XHTML 64
PROC TEMPLATE: Not Just for Geeks Anymore 67
References 70
iv Contents
Part 2 Access to SAS with SAS/IntrNet
Software
Chapter 4 Remote Access to SAS 75
Client/Server Computing 75
Remote Data Services with SAS/SHARE 77
Editing the TCP Services File 77
Configuring TCP Security 78
Starting and Stopping the SAS/SHARE Server 79
Managing SAS/SHARE as a Windows Service 81
SAS AppDev Studio Service Manager 83
Managing Servers with SAS Management Console 83
Access to Remote Library Services 84
Remote SQL Pass-Through (RSPT) 85
Remote Compute Services with SAS/CONNECT 86
Distributed Computing with the Integrated Object Model 89
References 90

Chapter 5 Web Applications Programming 91
Server-Side or Client-Side? 91
The Common Gateway Interface 92
A CGI Example 94
Passing Parameter Values to Web Applications 96
References 100

Chapter 6 SAS/IntrNet: the Application Dispatcher 101
Overview 101
Installing the Application Broker 102
Creating an Application Dispatcher Service 106
Defining an Application Dispatcher Service for UNIX or
Linux 106
Defining an Application Dispatcher Service for
Windows 108
Configuring the Default Application Service 109
Starting and Stopping the Application Server 110
Testing the Application Service 112
Defining Application Server Libraries 117
Debugging SAS Output 119
Generating Dynamic Output with the Output Delivery System 122
References 125
Contents v

Chapter 7 SAS/IntrNet: htmSQL 127
SAS/IntrNet Data Services 127
htmSQL Directives 128
Generating Tables with htmSQL 130
Creating Forms with htmSQL 133
Issues with CGI Applications 134
References 135

Part 3 Server-Side Java Programming
Chapter 8 Java Servlets and JavaServer Pages 139
Introduction 140
Java Servlets 140
A Hill of Beans 141
Servlet Example 142
Deploying Servlets 144
Creating a JavaServer Page 145
Scripting Elements 146
Predefined Variables 147
A Simple JSP Example 149
JSP Custom Tag Libraries 151
Tag Handlers 151
Tag Library Descriptors 152
JSP with Custom Tags 153
Deploying Tag Libraries 154
Database Access Using JDBC and JavaServer Pages 154
JDBC Overview 154
Using SQL with JSP Custom Tags 157
Web Archive Files 163
Building a Web Archive File 164
Web Application Manager 164
References 166
vi Contents
Chapter 9 Developing Java Server-Side Applications with
webAF Software 169
Getting Started with webAF Software 170
Installing SAS AppDev Studio 171
The webAF Integrated Development Environment 173
Creating a JSP Project 176
A Simple JSP Example 182
Building Forms with webAF Software 183
Creating a New JavaServer Page 184
Adding Styles to JavaServer Pages 185
Writing the Java Scriptlet 185
Building the XHTML Form 186
Attributes and Models 190
Connecting to SAS Data 192
Registering Connections 193
Using the Model-View-Controller Architecture in
webAF Software 195
Modifying the Controller Servlet 197
Creating the JavaServer Page 198
Testing the Application 198
Deploying the Web Application 200
Using SAS Remote Compute Services 201
Remote Computing Using SubmitInterface 201
Using the DataSetInfo Interface 204
Using the DataBeanWizard 209
Conclusion 211
References 211

Part 4 SAS Integration Technologies
Chapter 10 Using the SAS Open Metadata Architecture
with the Integrated Object Model 215
Overview: SAS Integration Technologies 215
The Integrated Object Model 216
IOM Servers 218
The SAS Metadata Server 220
The SAS Workspace Server 220
The SAS Stored Process Server 221
IOM Client Applications 222
Windows Client Interface – Visual Basic Example 222
Visual C++ Interface 225
Java Client Interface 226
Contents vii

Conclusion 230
References 230

Chapter 11 Building Web Applications with SAS
and Java 233
Overview: Java Web Applications and SAS Stored Processes 234
Using the SAS Stored Process Web Application as a
Replacement for SAS/IntrNet 235
The SAS Stored Process Web Application 235
Installing the SAS Web Infrastructure Kit 235
Configuring the Server 239
High-Level Overview of the Steps 240
Using SAS Stored Processes 242
Creating a Stored Process Repository with SAS Management
Console 9.1 242
Using the Java Foundation Services Stored Process Service 251
Managing Configuration Issues 251
Creating a SAS Stored Process Web Application with
Foundation Services 251
Deploying a SAS Stored Process Web Application 256
Conclusion 258
References 258

Part 5 Appendixes
Appendix A DHTML: Dynamic Programming on the Web
Client with JavaScript 261

Appendix B Client-Side Programming with Java
Applets 269
Using Java Applets 269
Getting Into the Swing 274
Getting Plugged In 277
Creating Java Applets with webAF Software 279
A Simple Applet Example 279
Creating a New Applet in webAF Software 281
The webAF Code Generator 286
Access to Remote Data with webAF Software 289
Access to Remote Data 290
viii Contents
Java Security 292
Under the Hood: Deploying the Resulting Web Page 294
Using the Package Wizard to Deploy Applets 295

Appendix C SAS/IntrNet: Design-Time Controls 297
Introduction 297
Installing and Configuring the Design-Time Controls 299
Adding a SAS Table to an HTML Page 301
Microsoft FrontPage 301
Macromedia Dreamweaver 307
webAF Software 308
Adding Dynamic SAS Content with the Design-Time Controls 310
Embedding DTC in a JavaServer Page 310
Embedding DTC in an Active Server Page 311
References 312

Appendix D Online Analytic Processing with webEIS
Software 313
Introduction 313
Creating a webEIS Document 314
Creating a webEIS Connection 315
Creating a webEIS Table 316
Displaying webEIS Documents 321
Applets 322
JavaServer Pages 324
Additional webEIS Controls 325

Index 329
Preface

SAS Web Technologies provide a comprehensive set of tools for creating and deploying Web
applications. This book is an attempt to bring together in one volume a set of examples to
illustrate the major issues in Web development, using the tools available from SAS as the building
blocks. It is intended both as a general introduction to Web programming and a guide to using
SAS Web tools. As such, it is aimed at least three different audiences.
The first group includes experienced SAS users who want to get started delivering content on the
Web. These are the attendees at SUGI and the regional conferences who fill lecture rooms and
workshops for sessions with SAS/IntrNet, SAS Integration Technologies or SAS AppDev Studio
in the title. The second, complementary group includes of Web developers who are interested in
access to SAS data and who appreciate the ease and simplicity of the solutions SAS has provided.
The third group includes those project managers, students, and others who want to learn about
Web development and who are not well served by the current proliferation of specialized texts.
Clearly it is not possible to cover this entire topic comprehensively in a reasonably sized volume.
On the other hand, introductory users are often baffled by the wide variety of options available
and the blizzard of confusing Web terminology.
This book, then, attempts to achieve two goals: first, to organize the options for Web
programming into an understandable framework, and second, to show how the available SAS
tools fit into this framework. The strength of SAS is its ability to make difficult data analysis and
presentation tasks straightforward, if not simple. With SAS Web Technologies, users can leverage
their substantive experience without having to learn a whole new specialized set of tools. In
addition, the full power of SAS is available for data exploration, analysis, and reporting.
A Note to the Reader
A new version of SAS AppDev Studio (3.2) is planned for release later in 2006. The webAF and
webEIS components will be going away in the new version of SAS AppDev Studio; instead SAS
is moving to Eclipse, an industry standard, open source development platform (see
http://www.eclipse.org/ for more information). Since many of the examples in this volume use
webAF, initially SAS Press considered delaying the new edition a year or so to update it with the
new version of SAS AppDev Studio. Finally, however, the benefits to users from getting the book
out as scheduled outweighed the disadvantages, so it was decided to proceed as planned. The
material covered in this volume is up-to-date for SAS 9.1.3 and SAS AppDev Studio 3.1.4, and it
should serve as a comprehensive introduction to SAS Web Technologies as of the date of
publication. The good news is that plans for the third edition are in the works.
What Is Covered in This Book: Changes in the 2nd Edition
Every example in the book has been reviewed to make sure it works with the most recent versions
of the software. All of the material from the first edition is still included, though discussion of
some of the deprecated products has been moved to the appendixes. In addition, a substantial
amount of new material has been added—in particular, an entirely new section on features
introduced or enhanced in SAS 9.1.