MWSUG 1998 Papers - Index

52 papers. Source: MWSUG (Midwest SAS Users Group) conference proceedings.

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	A Bag of FSEDIT Tricks	Derek P. Morgan, Michael A. Province	For data entry applications, the `FSEDIT` procedure provides a good user interface. With reasonable care and knowledge, an FSEDIT screen will yield well-organized, reasonably clean data for analysis. However, what happens when that reasonable care and knowledge are not a given, especially when that application is to be remotely supported, and/or extensive training is not an option? How can you help improve the data quality while retaining that user-friendly, non-technical interface? Screen Control Language (SCl) makes it possible, but there are several non-obvious techniques that also help accomplish that end. In addition, there are other, non-SCl methods that will aid the FSEDIT screen programmer in eliminating data problems at entry. It is always easier to build an application for yourself than to build one for other people to use, because you know how everything is supposed to work. This paper details five solutions to problems that have been presented to us by our users	character variable, proc step, proc format, numeric variable	7
2	A Project Tracking and Analysis Application for Bioequivalence Trials	A. David Mundt	Pat O'Meara Associates, Inc. performs analysis of clinical trials for pharmaceutical companies. One of the standard tasks is the analysis and reporting of bioequivalence trials. The process of performing the analysis and generating a report involved numerous individual modifications of SAS programs to fit the specifics of a particular study. Directories and sub-directories to store the programs, data, output, and documents generated for the study were created and managed ad hoc. These process led to problems with consistency, completeness, efficiency, and was unwieldy. The application described is an effort to provide a consistent, efficient, and easy-to use system for creating project directories and performing efficient analyses and report generation. Extensive use of `SAS/AF`, Screen Control language, and the Macro Facility helped form a cohesive application	macro variable, pk parameter, quality control, macro facility	4
3	A Quick and Dirty Method for Delivering SAS Reports Via the World Wide Web	Mary A. Bednarski, Joel F. Achtenberg	We will describe the development of a system for providing rapid, up-to-date information from a SAS database supporting an ongoing nationwide research study to personnel at participating clinics. using only one SAS macro (OUT2HTMl, a few simple HTMl menu pages, and a SCheduling program to start the nightly updates, the system was easy and quick to implement, and is almost effortless to maintain. We will discuss our rationale for using the web, techniques and tools used in the imPlementation, and remaining issues and future development prospects	macro call, proc step, sas output	6
4	A Tour of UnifyPow: A SAS Module/Macro for Sample-Size Analysis	Ralph G. O'Brien	UnifyPow is a freeware SAS" module/macro that performs statistical power analysis and other matters related to sample-size choice. Its functionality covers an extensive set of methods, One-group tests include the t and Wilcoxon for Ho: Il = J.Io; the binomial and Z approximation for Ho: lt = lto; t and Wilcoxon for paired means; McNemar's for paired proportions; and Fishers's r-to-Z for Ho: P = Po' Two-group tests include t and Wilcoxon-Mann-Whitney for Ho: 1l1- III = lio: 7:, likelihood ratio (LR), and Fisher's exact for Ho: ltJ = "2 (association in 2 x 2 tables); r-to-Z for Ho: PJ = P2' J group tests include ANOVA via the cell-means model with general linear contrasts; Xl and LR tests for proportions (2 x J tables) with general linear contrasts on J logits. Also covered are the test of Ho: J3j = J3jO in a multiple regression model predicting Y from q X's ("Y I q X's") in which Xj has tolerance Tol(Xj ) = I - R2(Xj I other q - I X's); the	sample, binomial distribution, sample size, likelihood function, standard deviation, correlation, logistic distribution, power analysis, proc freq, anova, rank test, proc step, regression analysis, exact test, f-test, wilcoxon test, monte carlo	11
5	An Introduction to Binary Logistic Regression	Linda M. Quinn	Modeling the relationship between a binary response variable and one or more independent variables can be done within the SAS System using `PROC LOGISTIC`. This Motial will explain how to run a basic logistic model, will discuss the available options, and will review the output generated. A new feature of `PROC LOGISTIC` starting in version 6.10 is the ability to display ROC curves and to generate customized confidence intervals. Examples and coding will be provided	logistic distribution, proc step, proc logistic, odds ratio, regression analysis, logistic regression, estimate, confidence interval, response variable, goodness of fit, predictor variable, roc curve, likelihood function, proc reg	8
6	An Introduction to Macros	Linda M. Quinn	The Macro facility in SAS is one of the most powerful tools of the SAS System. This tutorial is designed for the SAS user that has never used macros or has used them without knowing what they do. Macros allow us to set session and program specific variables, do repetitive tasks, and process selectively. This tutorial will walk through the basic use of macros and allow you to begin using macros	macro variable, macro facility, proc step, proc print, macro definition, proc means, macro call, options statement, %if-%then-%else	6
7	An Introduction to PROC SQL	Pete Hansen	`PROC SQL` is a powerful Base SASS `PROC` which combines the functionality of the DATA and `PROC` Steps into a single procedure. `PROC SQL` in many cases can be a more efficient alternative to traditional SAS code. `PROC SQL` can be used to retrieve, update, and report on information from SAS data sets or other database products. This workshop will concentrate on SQl's syntax and how to access information from existing SAS data sets. Some of the topics covered include: Write SQl code using various styles of the SELECT statement Dynamically create new variables on the SELECT statement. Use SQl options to control the appearance of reports. Create multiple reports on a single `PROC SQL` statement. * Create reports containing percentages using	proc step, proc sql, select, group by, order by, proc sort, where statement	10
8	Building a GUI to a Sample Size Program using FRAME	Brian Mitchell		sample, sample size, proc step, proc tabulate, sas output, likelihood function	3
9	CATALOGER: An Applications Development Tool to View, Compare, and Document SAS Catalogs and Data Files	Christopher A. Roper, Michael Gilman	This paper will present an application written entirely in SAS that greatly enhances the developer's ability to develop, compare, and manage SAS catalog entries and datasets. This application has point and click capabilities for printing catalog entries, including images of frame entries and complete descriptions of associated widgets directly into Microsoft Word documents, creating publication quality documentation at the push of a button. The batch printing facility allows for printing of all catalog entries of virtually any type, including Program, Source, SCL, and Slist (including expanded sublists) entries. The text searching facility will search through all text-based entries for character strings and allow point and click access to the locations in any catalog entry containing the text string	catalog entry, catalog, dataset	6
10	Creating Dynamic Web Pages with Application Dispatcher: Getting Started with SAS/IntrNet Software	Mickey Waxman, Larry Hoyle	Getting Started with SASJlntrNefI'M Software Mickey Waxman, Academic Computing, University of Kansas Larry Hoyle, IPPBR, University of Kansas This 'virtual' hands-on workshop will give a basic	macro variable, error message, macro definition, proc step, %if-%then-%else	10
11	Custom Reports - Examples For a Table of Contents and Index	Deb Cassidy	Have you ever needed a report where none of the `PROC`'s gave you wanted? Then "DATA `_NULL_`" could be your answer. While some people will complain it takes too long or it is too complex, this method does give you great flexibility. In this case, I needed some "unusual" reports - a table of contents and a couple indices. In these examples, new variables are also being calculated. These examples not only show you how to use DATA `_NULL_` to create a custom report but also show the use of RETAIN and ARRAY statements, LAG, TRIM, LEFT, SUBSTR, MOD and PUT functions, concatenation, and "first-dotllast-dot" processing	sample, if-then-else	8
12	Data Tables: Highlighting Techniques	Christopher A. Roper	Data tables are arguably one of the best looking widgets in SAS. This makes them a popular choice for replacing the venerable Extended Table widget as a selection list, or front end to a data set. The model/viewer paradigm is an extremely flexible tool that gives the Data Table, and it's parent class the Table Editor, an extensive utility across a broad range of applications. Combined with the abundance of methods available to the Data Table class, this widget can add a very nice touch of polish to an application, giving it the professional, fmished appearance a client demands and deserves. This paper will illustrate five scenarios for using highlighting to make the Data Table object more attractive and functional for your information consumers	dataset, filtering	8
13	Development of a Multi-Year Population-Based Data Warehouse of Standardized Medical Costs: Methods and Results	Priscilla Van Grevenhof, Judith L. Wagner, James M. Naessens, Charles H. Darby, Jill M. Killian, Eva R. Helgeson, Roger W. Evans		imputation, bar chart	4
14	Dressing Up Your Version 6 Objects to be Version 7 Components	Glen R. Walker, Tammy L. Gagliano	Version 7 SASlAfi8 software exploits the SAS Component Object Model (SCOM) Architecture to provide application developers with a rapid application development tool for object oriented applications. All existing applications will continue to run under Version 7 with no changes; however, with minimal work, your legacy classes can be enhanced to fully exploit the new features. In this paper we will discuss the few simple steps you can take to make your existing classes work as SCaM components and what advantages this will bring		7
15	Efficient Analysis of Large Datasets	Kevin D. Brunson, Patricia Ledesma Liebana	This paper will describe experiences trying to analyze and store data in a combined NT and UNIX environment constrained by the total size and number of data files extracted from the 1990 Census of Population and Housing 5% Microdata Sample. The total space required exceeded local PC diskspace so that permanent storage of the data had to take place on AFS file servers. Therein, the total size was an encumbrance due to bandwidth limitations that impeded the transfer, in addition to the undesirability of manipulating files larger than about 100 Mb. in	proc step, proc reg	6
16	Enhancing SAS Output Tables with WordPerfect	Hugh Geary	Creating tables from SAS output may involve use of some rather detailed WordPerfect code. Once the ground has been broken by producing a few tables, future tables can often be done with only modifications. Titles can be put in large bold print, employ various font styles and be underlined. The body of the table can be enclosed in an array of vertical and horizontal lines. Shading can be used for emphasis in various elements of the array. Superscripts can be used for footnotes. In general, tables can be produced by taking the following steps. First prepare the SAS output by inserting tabs for creating columns and writing it to a text file. Next initiate a WordPerfect session and reset defaults to your specific needs. Then invoke WordPerfect menus to create the table, border, a heading with shading and shading for the array's diagonal elements. Finally record these actions into a macro. It can be edited to make changes and additions and can be replayed for similar text files	sas output, txt	5
17	Exporting SAS/GRAPH to Other Packages What Format Should I Choose? (Version 6 of the SAS System)	Peter Ruzsa		bar chart, batch job	5
18	Faster Data Extraction with Your Own Clustered Index	Zhuan (John) Xu	Large data warehouses and decision support systems are becoming more and more popular. They make fast data access more important than ever. With clustered index, data is sorted in clustered index order and thus provide very fast data access. Although SAS does not provide built in clustered index, user may create his own clustered index in a small SAS data set and use data set options (FIRSTOBS= and OBS=) to apply such index to extract data. This method provides a way to extract data faster than SAS index. A pair of SAS macro programs are presented to greatly simplify the process. They hide details from user yet flexible enough for user to perform other data processing	dataset, macro definition, sample, index, %if-%then-%else	5
19	From End User to SAS Software Programmer	Betty J. Anderson		where statement, data governance, sas log	10
20	From Raw Data to Web-Accessible Information: SAS Software Solutions for a State Health Data Agency	Chip Quade, Barbara A. Rudolph	This paper describes a SAS-based information system that supports the data management, analysis, and information disseIJrination needs of a state health data agency, with special emphasis on the use of SAS software in an interactive Web based query system. Wisconsin's Office of Health Care Information (OHa) collects data on inpatient hospital discharges, ambulatory surgeries, health care facilities, and health care providers. OHa cleans the raw data and produces standard reports, standard data products, and custom reports and data sets. In 1996, OHCI launched an interactive data query system on the Web. Internet customers can generate questions and quickly get answers from statewide patient-level databases containing up to 1.3 million records. OHCI uses base SAS software, SAS/~,	dataset, proc step	10
21	Get Hiper About Hiperspaces	Fred R. Forst	SAs"' offers the option of using hiperspaces as the standard WORK file under MVSIESA@ as a performance enhancement. This paper introduces hiperspaces under MVS, and the applicable SAS options to invoke hiperspace use. Also, attention is given to tuning the use of hiperspaces within MVS (i.e. MVS's SRM parameters). Performance gains can be aStonishing with little or no work. on the part of the user. Finally, specific case study results will be given	temporary dataset, proc step	6
22	Graphically Conquering the SF-36: A Tool for Illustrating Subscale by Group Over Time Using SAS/GRAPH Software	David Door, Mae O. Gordon	The widespread adoption of health related quality of life (QoL) surveys to measure patient outcomes in clinical practice as well as research has raised the issue of simple graphical display. Such surveys often have multiple sUbscales to quantify disparate dimensions in the QoL, induding emotional, physical, and others. When this is combined with the need to present longitudinal data for multiple groups, concise and accessible summarization of results becomes difficult. This paper presents a straightforward way to graph subscales by group over time, using one of the most common surveys, the Short Form - 36. The	macro variable, macro loop, macro conditional, proc step, proc gplot	8
23	Handling production macros in the FRAME system: A Tutorial in the use of the SAS/AF and FRAME Systems	Paul A. Thompson	A production macro is defined as one which is used frequently over time, to perform a well-defined task which is not modified often. Such macros must be maintained to retain compatibility. It is important to control the use of the macro from improper use by non-developers. SAS/ AF	macro call, macro variable, macro catalog, dataset, stored macro, macro loop	10
24	Harnessing the Power of SCL Lists	Lisa Ann Horwitz	SCL lists are ordered collections of data stored in memory, and are a powerful tool for applications developers. The sources of this data can include hard coded values, SAS data sets, information retrieved from interaction with the application user or the current SAS session, or the FRAME entry's objects themselves. This paper explores how to create and populate SCL lists, how to retrieve and utilize infonnation from lists, how to manipulate lists, and how to access some of the lists associated with FRAME entry objects. An assortment of ideas for using SCL lists will be suggested, as well	proc tabulate, catalog entry, dataset, sample, proc step	9
25	If There Is A Will, There Is A Way: Getting Around Defaults of PROC LOGISTIC	Chao-Ying Joanne Peng, Tak-Shing Harry So	Logistic regression modeling can be a powerful tool for analyzing data collected for social science research. Specifically, logistic regression is used to predict the likelihood of an odds ratio for a dichotomously scaled outcome measure from a series of explanatory variables. SASISTA-re software has a versatile procedure (LOGISTIC) for performing logistic regression, both for fitting a specific logistic regression model and for selecting the best model to fit the data. Despite the wide range of very useful options/features already implemented into `PROC LOGISTIC`, this procedure has certain defaults and syntax conventions which can pose difficulties tor social science researchers to deal with. In this paper, we identify six areas of `PROC LOGISTIC` for which alternative solutions may be needed in order to get around its limiting conventions	logistic distribution, proc step, proc logistic, logistic regression, regression analysis, response variable, proc freq, nominal variable, interaction effect, raw data, proc sort, proc print, binary variable, estimate, proc gplot, roc curve, correlation, proc genmod, predictor variable, macro definition	10
26	Including SAS Software Text Output into a Microsoft Word Document	A. David Mundt	It is often necessary to incorporate SAS system output into a report. Due to the extensive use of Microsoft software, Word has often become the document processor of choice in businesses. We will explore a couple of quick, easy techniques for generating SAS system output and incorporating it into a Word document	txt, put statement	2
27	Including SAS/GRAPH Software Output into a Microsoft Word Document	A. David Mundt	The SAs-' system provides powerful tools for the graphical visualization of information. What's a good way of incorporating these graphics into a report. Using the SAS system and Microsoft'/' Word, we will show how to generate a graph with specific protocols that allow quick, easy, and compatible incorporation into a Word document	title statement, proc sgplot	2
28	Just Give Me the File: The Power of PROC SQL with SAS/ACCESS to Pull Data from Various Files and Calculate Actionable Results	John Standefer	In today's business environment, companies are highly sensitive to efficiency ratings, such as return on investment (ROI). One of the mainstays of the SAS System is its ability to read data from nearly all sources. This presentation will discuss one example of how to use the power of `PROC SQL` and `SAS/ACCESS` to pull data from three various sources and calculate the ROI for a sales promotion. The source files used for this presentation are the following: I - MS Access database tables from Sales 2 - Lotus spreadsheetS from Accounting 3 - SAS data sets from Marketing	proc step, proc sql, create view	6
29	Less Well Known Features of SAS PROC SQL	Timothy J. Harrington	This paper discusses the less well known features and options of `PROC SQL` all of which are listed in SAS HELP	proc sql, macro variable, create table, proc step, missing value, order by, character variable, input statement, where statement	10
30	Leveraging Resources to Maximize SAS and JMP Support	John M. LaBore, Janette E. Thomas, Eric A. Slinkard	Individuals serving as the SAS representative, SAS consultant, or SAS training coordinator for a client organization have to deal with a variety of tasks, including licensing, installation and upgrading of software, resolution of technical problems, training issues, and dissemination of appropriate information to various individuals and groups. To provide better support to the 2500+ users of the SAS system and/or JMP software within our organization, we found and leveraged various resources to help us accomplish these tasks. This paper provides an overview of both the in-house and extemal resources that we use. Resources and processes which appear to be "keys" to successful support are highlighted	sas consultant, traffic data	6
31	Maximizing SAS Software Performance Under the UNIX Operating System	Daniel McLaren, George W. Divine	The Unix operating system has gained widespread acceptance in recent years. Unix provides a fast, secure, and reliable platform for running the SAS System. This paper will describe how to maximize SAS software performance on your Unix system using techniques that apply to most variants of the Unix operating system. Topics covered include performance benchmarks, configuring memory, swap space and tmpfs, maximizing disk subsystem performance, enhancing multiuser performance, reducing disk space requirements, setting SAS system options, setting process priorities, eliminating unnecessary system processes, and monitOring performance	batch job, options statement	6
32	MidWest SAS User Group, Inc. - FAQ	Linda M. Quinn	This paper discusses MWSUG activities. The main purposes are to (1) disseminate information to users in the area, (2) develop interest and volunteers, and (3) obtain feedback from users.' Some of the topics for		6
33	ODBC: Transferring Data Between SAS Software and Other Applications Using ODBC	Randall Cates	ODBC is a powerful tool available to programmers who need to move data between different software applications. Originally pioneered by Microsoft, ODBC has become a standard method of data transfer for many software applications including the SAS software. ODBC has three primary components. The ODBC Drivers identify a specific type and location of data. Drivers are defined through the ODBC Administrator, a program that resides and is a part of the underlying Windows operating system. The ODBC Administrator accesses the ODBC Driver Managers for information needed to create the various specific drivers. ODBC Driver Managers are specific to the different software applications. This presentation will demonstrate how to configure different OOBC drivers, and show how to use the configured OOBC drivers to obtain SAS datasets from Microsoft Access 97, and Microsoft Access datasets with SAS `PROC` SOL code	dataset, sas base	8
34	ODS for Data Analysis: Output As-You-Like-It in Version 7	Christopher R. Olinger, Randall D. Tobias	Christopher R. Olinger Randall D. Tobias SAS Institute Inc., Cary NC This paper discusses advances made in the output generated by all Version 7 SAS Software procedures. New features provided by the Output Delivery System (`ODS`) include automatic rendering of procedure output in HTMl for the web, rich-text, Postscript or pel format, output data sets from any printed output, and the ability to edit the look and feel of most output. `ODS` also supports all legacy line-mode printing and supports a document feature to allow post-procedure replaying of output. This talk introduces `ODS` features to be delivered in Version 7 and provides some concrete examples of how data analysts and statisticians can take advantage of the feawre set provided by `ODS`. Motivation Every SAS user knows and loves the listing file, the vehicle for all printed SAS output for more than two decades. While familiar, the listing file has its limitations. For starters, output is restricted to monospace fonts only		21
35	Producing ROC Curves For Discriminant Analysis Using PROC LOGISTIC	Keith Dunnigan		logistic distribution, proc logistic, proc step, type i error, roc curve, logistic regression, sample, regression analysis, type ii error, response variable	7
36	SAS as a "Gateway" to OLAP-Case Study	Michele R. Rushing, Ronald D. Hickman		data mart, proof of concept	6
37	SAS/CONNECT - Trials and Triumphs of Migrating from Batch to Interactive Processingin an IBM Mainframe Environment	Joseph M. Braun, Michael S. Hines, Shawn L. Williams	Easy. direct access to data by users is a key business requirement. With windows-based Graphical User Interface (GUI) tools being the norm, batch-processing tools do not meet today's expectations of the non-programmer user. However, there is no reason that 'power users' shouldn't have easy to use tools as well. SAS System for personal computers (PC/SAS) coupled with SASfCONNECT is a powerful pair of tools for gaining interactive access to mainframe data. This presentation will identify the challenges and rewards involved in introducing interactive processing into a primarily batch MVS reporting environment. The challenges included securing approval for licensing, and installation, configuration and testing of SASfCONNECT. Additionally, the SASfCONNECT tearn re created, in the TSO environment, many of the standard utilities that existed in the batch wo~d. The project team also prepared training resources to educate users in the basic techniques of the new tools	dataset, management reporting, sample	7
38	SEGLINK: A SAS System MACRO for Variance-components genetic linkage analysis	Jennifer H. Lin, Michael A. Province	The variance components approach to linkage analysis is one of the most powerful and robust	macro variable, covariance, proc freq	4
39	SQL Query Window Classes: How to Incorporate the SQL Column Expression Builder Class In Custom SAS/AF Applications	Christopher A. Roper	SQL (Structured Query Language) is the standard language used for querying all major databases, including SAP!R3, SYBASE, ORACLE, RED BRICK, DB2, and others. The SAS Query window creates SQL expressions using SAS! AF Classes that are available to the SAS!AF developer. One of these class entries is the Column Expression Builder Class, QWCLEXPR.CLASS in the SASHELP.SQL catalog. This is the class used by the Query window to build columns in SQL. This class may be called by any SAS! AF entry to present the same interface the SAS Query window uses as a column expression builder. This paper will cover what the Column Expression Builder Class is, how to incorporate it into a SAS! AF application, and the nuances of using this class effectively	proc sql, proc step	6
40	SQL Query Window Classes: How To Incorporate The SQL Where Expression Builder Class In Custom SAS/AF Applications	Christopher A. Roper	SQL (Structured Query Language) is the standard language used for querying all major databases, including SYBASE, ORACLE, RED BRICK, DB2, and others. The SAS Query window creates SQL expressions using SAS! AF Classes that are available to the SAS!AF developer. One of these class entries is the Where Clause Builder Class, QWWHERE.CLASS in the SASHELP.SQL catalog. This is the class used by the Query window to build SQL where clauses. This class may be called by any SASIAF entry to present the same interface the SAS Query window uses to build where clauses for SQL queries. This paper will cover what the Where Clause Builder Class is, how to incorporate it into a SAS!AF application, and the nuances of using this class effectively	where statement, proc sql	6
41	Transparent Macros - A Simple Way to Add-in Personalized High Quality Re-Usable SAS Macros in Any Operating System	Paul D. McDonald	By Paul D. McDonald, SPIKEware, Inc. This paper shows how to take macros that you have written and integrate them direcUy into the SAS Software System lM so that they look, act, and feel like part of SAS. Included in this paper are several macro utilities that allow you to do this. Audience This paper is written for experienced SAS programmers who are well versed in the SAS Macro Language. System Administrators will also find this paper useful as a reference guide to integrating site-specific utilities to the SAS Software System. Trademarks and Copyright Notices The SAS Software System, SAS Maao Language, and other references to SAS products are trademarks 01 the SAS Institute, Cary, North Carolina. Microsoft and Microsoft W0rd97 are trademarks 01 Microsoft, Inc., Redmond, Washington. All SAS source code shown in this paper is property 01 by SPIKEware, Inc	proc step, macro variable, sas log, macro definition, %if-%then-%else	11
42	Unlocking SAP AG R/3 data with the SAS System!!! The SAS Intelligent Warehousing Solution for R/3	Eric Hunley			7
43	Using Desktop OLAP Tool in Easy Interface for SAS	Zhuan (John) Xu	Online Analytic Processing (OLAP) is a popular front end for data warehousing. It provides an easy way to 'slice and dice' and 'drill down'. Therefore, it is a very important tool in data exploration. A SAS OLAP application can be built with SAS fMDDB and SASIEIS. In the desktop environment, a more portable OLAP is desired. This paper describes the concept of OLAP and demonstrates Easy Interface for SAS (El), a desktop OLAP application. It uses SASIBASE to generate		4
44	Using Embedded HTML in SAS/Intrnet Output	Bill Dvorak	`SAS/LNTRNET` developers can improve the navigation and the usability of their web sites by embedding HTML in the output created by HTML formatting macros. These improvements aid the transition of applications from static printed reports to dynamic systems. This paper will discuss using `PROC TABULATE` to create a table of contents page that serves as an HTML form to call another SAS program. Using this technique, the developer can create drill-down capabilities for users	proc tabulate, proc step, macro variable, footnote statement, proc print, where statement, phase ii, phase iii	5
45	Using JMP for Design of Experiments and Variability Analysis for Semiconductors	William R. Gjertsen	JMP@ is an interactive statistical analysis program that promotes the visualization and discovery of important patterns and outliers in your data. It accomplishes this through unique graphics and the dynamic linking of points. This paper will address two aspects of a quality certification process namely an initial variability analysis of the measurement tool and a final response surface analysis for simultaneous optimization of multiple responses	standard deviation, proc calis	7
46	Using PROC MIXED To Analyze a Repeated Measures Design	Keith Dunnigan		proc mixed, proc step, covariance, proc genmod, repeated measures, correlation, proc glm, covariance structure, class variable, likelihood function	6
47	Using SAS PROC GENMOD for Log-linear Association Models of Ordinal Data	James R. Hershey	This paper illustrates the use of the GENMOD pro cedure to analyze ordinal data. Models which take into account the ordinal nature of one or both vari ables in a two-way table are discussed. The SAS `DATA STEP` is used to obtain the right structure in the data, and the code for several models fit with `PROC GENMOD` is shown. An example illustrates one way to extract information about the associa, tion between two variables that would be missed with ordinary contingency table analysis	proc genmod, proc step, ordinal variable, proc freq	4
48	Various Ways to Link SAS Programs and Microsoft Excel	Peter K. Harrison, Gary B. Wagner	Many applications today are written in Microsoft `EXCEL`, then need to use the SASe System to obtain accurate statistical reporting. This paper will discuss ways to pass data and control back and forth between `EXCEL` and SAS sessions. The use of Dynamic Data Exchange (DDE) will be compared to using `SAS/ACCESS`· Software for PC File Formats or the `SQL` Procedure Pass-Through facility. The techniques of using the SAS system as an OLE automation server or as a shelled process will be discussed. The problems of synchronizing separate processes will be addressed. Keywords: OLE AUTOMATION DDE ODBC PCFF	excel, proc step, proc sql, name range list, xls, data step	8
49	Web Enabled Graphics with a SAS Data Warehouse	Diane E. Brown	A Provider Profiling system for Saint John's Health System in Anderson, Indiana was developed using a SAS data warehouse which is used to generate graphical reports through a SASlIntrNet based interface. This paper reviews the design and creation of the data warehouse, the SASlIntrNet interface, and the macro driven `SAS/GRAPH` plots and bar charts. The data warehouse is built and stored on a Windows NT server which can be accessed by the hospital administrative staff as well as the physicianS. SAS products used include Base SAS, `SAS/GRAPH`, and SASlIntrNet	bar chart, unique key	6
50	Web-Enabling a Scientific Laboratory Using SAS/IntrNet	Thomas H. Burger, Richard W. Tucker, John M. LaBore	Industry research and development increasingly relies on global operations. IT divisions now more than ever are challenged with developing an infrastructure capable of providing business solutions at this scale. SASIIntrNet offers the ability to couple powerful analysis and reporting tools with global information delivery using the Internet. Speed-to-market initiatives demand rapid implementation of this capability. We describe web enablement of a scientific laboratory providing end-users the ability to generate dynamic reports and graphics	macro definition, proc step, macro facility, data wrangling, macro variable, proc sql	7
51	Working with Large Data Sets: How, Why and Why Not	Andrew H. Karp		dataset, character variable, where statement, numeric variable, proc step, length statement	6
52	Your BASE Dollars at Work	SAS Institute (a company)	The BASE procedures group (a.k.a. Information Products) at SAS Institute has been hard at work adding new and useful features to the heart of the SAS System. This talk describes this work and uses generic "business oriented" examples to place these features in a context that demonstrates their use in everyday programming. Covered are: . General additions to SAS Software that should make the programmers life an easier one. New SUMMARVfTABULATE options like percentiles, independent ordering of class variables, and the pre loading of the class-variable space using formats and/or a data sets of desired class level values. The `ODS` statement for producing output data sets and HTMl output from all SAS procedures, High Fidelity Printing and more. `ODS` is an acronym for Output Delivery ~ystem. `ODS` specific additions to `PROC REPORT`, `PROC TABULATE` and the `SAS/GRAPH` Procedures. General Improvements SAS Software (finally!) permits table and column names to be up to 32 characters long		10

Back to Conf go 1999 go 1997

This site serves as a convenient hosting location and does not work as a publisher. All copyrights belong to their respective owners.

The information on this site is provided for general reference purposes only. Whilst every effort is made to ensure that the site is up to date and accurate, no warrant, nor any responsibility or liability for, the accuracy or completeness of the content or for any loss which may arise from reliance on information contained in this site is provided. Links to other sites are provided for your convenience but no responsibility or liability for the content of those sites or of any external site which links to this site is accepted. References to any specific commercial product, process, service, or corporation are also for information only, and do not constitute endorsement, recommendation or favoring.

SAS is a registered trademark of SAS Institute Inc. SAS, Statistical Analysis System, 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. ® indicates USA registration.