MWSUG 2002 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	%X_Ray Macro to Explore Any SAS Dataset	Kinwah Fung, Douglas Zirbel	This paper presents a SAS macro which 1) shows `PROC CONTENTS` type information, and 2) prints examples of each variable's values alongside the Format and length information. This makes ~ easy to see at a glance what an entire input dataset looks like - without having to read pages of `PROC PRINT` output. This will help you identify the distinct values of the variables before you proceed to further data management procedures. By showing outliers and missing values tt can also help you to spot data problems in moments rather than hours	proc step, proc sql, dataset, sample, proc contents, put statement, sas log, create table, %if-%then-%else, macro definition	7
2	10 Things Experienced SAS Programmers Don't Know - But Should	Douglas Zirbel	Many SAS programmers have years of experience, but sometimes within only a narrow set of procedures and techniques. Numerous SAS professionals were asked for their views on an essential skill set, an industry-specific skill set, and the best means to learn it. These are their recommendations. The list covers SAS Version 6 as well as Version 8. Base SAS products listed as a part of this are `ODS`, `PROC` SOL dictionary tables, `DATA STEP`, macro language, and `PROC REPORT`	proc step, sas programmer, proc report, data step, proc sql, proc freq, proc transpose, macro facility, proc means, proc tabulate, sas base, excel, sas programming	10
3	A Macro to Assess the Key Drivers of Overall Product Acceptance using SAS System	George J. Hurley, David Hengehold	Factor Analysis is a multivariate technique that is useful for data reduction and eases interpretability of responses when the number of response variables is excessive. In particular, the Principal Components method for the Orthogonal Factor Model with m Common Factors (Johnson and Wichern, 2002) is used to obtain Principal Factors. Using these Principal Factors, a mu~iple or simple linear regression model can be fit to determine how these factors and/or the responses they "summarize" together or individually "drive" the growth of a particular overall response variable. Analogously logistic regression is used for binary responses. In the field of prodUcts research, this technique is often referred to as "Driver's Analysis" or factor regression. A SAS" macro has been developed to automate these analyses for most cases	response variable, proc step, logistic regression, logistic distribution, factor analysis, regression analysis, predictor variable, sample, proc factor, factor loading, txt, proc genmod, correlation, estimate, scree plot, proc reg	7
4	A Macro to Help with Accurate Output Documentation	Bruce Spotts	Accurately documenting the program and data library on output as well as the mode of operation is extremely important in order to manage programs and output. To assist with this task I have developed a macro that provides 4 macro variables to be used in titles or footnotes to accurately describe the program, data library, and the mode of operation for SAS programs running on MVS SAS versions 6.09-8.1. This macro is designed to work on MVS but can be modified to run on PC SAS. The macro is provided and the benefits and limitations are discussed	macro variable, %if-%then-%else, macro call, macro definition	2
5	A Missing is a Missing is a Missing ... Unless Your're a Project Manager	Martin Barron	By necessity, even beginning SAS users are familiar with the use of missing values in SAS. However, even more advanced users may be unfamiliar with the variety of ways in which special missing values can be assigned and used with SAS. This presentation explores the "mysteries of missings" and provides tips for working with missing values in common SAS tasks. Our overall focus will be on special missing values and their uses in project management. We will also explore the basics of missing values, SAS'S handling of missing values in updates, and SAS's handling of missing values in a few example procedures	missing value, numeric variable, proc freq, character variable, update statement, proc sort	4
6	A Preview of SAS/STAT Version 9: Moving in New Directions and Building on Old Favorites	Maura E. Stokes, Robert N. Rodriguez, Randy Tobias	Version 9 of `SAS/STAT` software brings you a vari ety of new tools for your statistical computing needs. The Power and Sample Size Application (PSS) pro vides sample size and power computations for a vari ety of analyses through a web interface. Experimen tal software in Version 9 moves `SAS/STAT` in new di rections, including robust regression, which is sup ported by the `ROBUSTREG` procedure, and logis tic regression for sample survey data, available with the `SURVEYLOGISTIC` procedure. In response to user requests, a number of procedures have been en hanced significantly. Conditional logistic regression is available in the `LOGISTIC` procedure through the new STRATA statement, and scoring of data sets is avail able through the new SCORE statement. New fea tures in several other procedures are also discussed		6
7	Advanced Macros	Destiny Corporation (a company)		macro variable, call symput, proc step, symbol table, proc sql, proc append, dataset, macro loop	9
8	An Example of ODS, FTP, PROC FORMAT with HTML Linked to Excel, then the output Emailed via PCSAS. PS-it's automated.	Zeke Torres	I will review a variety of popular SAS components. The concept is to obtain SAS Data (transport) file from a remote host. Use FTP (not `SAS/CONNECT`). Perform a `PROC TABULATE` or `PROC PRINT` etc. I get a little fancy with `ODS` and `PROC FORMAT` adding HTML to it allowing links to the `EXCEL` output which is also generated from this code. Finally I have my PCSAS Session email all of the output to "end users" and then PAGE myself with a message telling me it all worked. All from my PC SAS Session. And its automated using MS Win98 Schedule Task Manager. So when I am having breakfast at home my PC at work is actually working! When I finally do get to the office I have a custom `SASLOG` I can review since I set up the SAS CONFIG file to be specific for th is code	proc format, proc step, excel	10
9	Automate Large Volume Client-Specific Report Production using Nested SAS Macros, Excel VBA, and DDE	Joshua Chang	Techniques for exporting data from SAS to `EXCEL` using Dynamic Data Exchange (DOE) have been around since late 1990's. Executing Visual Basic for Applications (VBA) programs (a.k.a. macros) stored in an `EXCEL` workbook file directly from a SAS application had also been reported in -recent years. However, little to no literature was available as to how a SAS developer may export large volume of client-specific SAS data to multiple `EXCEL` worksheets (one sheet per client). Furthermore, users of `EXCEL` 97 - still a popular business application - reportedly will encounter a memory error when some 30 worksheets embedded with tables and graphs are created within a workbook file. Because of which, it is necessary to produce multiple workbooks within each only about 30 formatted worksheets (reports) are stored. This paper will demonstrate a technique for automating the above-described process using nested SAS macros, `EXCEL` VBA and DOE	excel, xls, macro variable, macro definition	3
10	Automotive Warranty Data Analysis on the World Wide Web	Stephanos Antoniades, Ed Barker, Lyle Dodge, Bruce Reading, Mike Senger, Sandy Walters	Trillium Teamologies assembled a team possessing SAS and Java expertise to create a warranty analysis web application for an automotive OEM. This paper discusses development strategies considered in building the application, including architectural and security considerations. Criteria are provided for deciding among client load models that range from thin (webAt='" model) through integrated object (Enterprise Guide" model) to full client (`SAS/AF` modeO approaches. This paper includes some of the development considerations and decisions made in web-enabling an enterprise wide application: choice of web technology (CGI v. Java) applet v. servlet methodology development environment (AppDevStudio" v. Forte) populating list box controls (on-demand access v. server page caching) processing large tasks through a batch queue facility using `ODS` to deliver reports In ".pdf form Choice of model is dependent on cost, complexity, control, and response time requirements	sas enterprise guide, sas base	6
11	Beginning Macros	Destiny Corporation (a company)		macro variable, macro facility, &variable, macro call, proc step, macro definition, macro put, automatic macro variable, symbol table, keyword parameter, %macro parameters, macro quoting function	6
12	Customization to the SAS Multidimensional Report Viewer	Karl Schaefer, Steve Wagar, Sarah L. Mitchell, Alan Leach	The SAS Multidimensional Report Viewer (MRV) is a web-based tool that provides a way to create reports from multidimensional data bases (MDDBs). It is great out-of-Ihe-box solution that allows users to quickly provide web-reports to an organization. However, we had client needs that required us to go inside the MRV, to dramatically change its appearance and functionality. The ability to customize the MRV through object-oriented techniques has been described by previous authors .. In this paper we present specific customizations to the MRV that we made for various clients. First we describe simple external changes made that alter the general appearance of the MRV. Next, we describe how, using method overrides and instance variables, to make further customizations. For example, we construct syntactically correct WHERE clauses based on the current status of the MRV and show how this can be used to query SAS tables	where statement, proc step, proc tabulate, class variable, macro variable, raw data, temporary dataset, proc sql, dataset, ods html	8
13	Data Quality - The Fuel that Drives the Business Engine	Tony Fisher	In today's information age companies will live and die by information. This information is the fuel that drives the business engine. As more and more data is collected, the reality of a multi channel world that includes e-commerce, direct sales, call centers and existing systems sets in. Bad data is affecting companies at an alarming rate and the dilemma is clear: how can a company ensure that it is getting the most out of every application, every system and every database to maximize the use of corporate data throughout the enterprise? In the end, the companies with the most complete, accurate and reliable information will gain and retain market share. Recognizing that you have a data quality problem is just the start. The real question is how to fix the problem. In this session you will learn how to determine if incomplete, inaccurate and unreliable data is affecting your business	data cleaning, business intelligence, data validation rules, data integration	5
14	Easy Interface for SAS --A SAS Applciation on the Windows Platform	Zhuan (John) Xu	Easy Interface for SAS is a Windows application that provides a user-friendly graphical user interface to the SAS system. Users are provided with a main screen styled after Windows Explorer. EI allows users to summarize data, calculate correlations, and perform sample size estimation, random sampling, T-tests, ANOVA and regression. In addition, EI supports the viewing, subsetting, sorting, merging, importing and exporting of SAS data sets. Its DOLAP (Desktop Online Analytic Processing) function is powerful yet quite easy to use for slicing and diCing and drilling down. Another nice feature is EIS Ad Hoc Application, which allows most SAS programs to be integrated into Easy Interface for SAS by creating a dynamic GUI	sample, format statement, proc step, dataset, txt, where statement, sas output, sample size, excel, data governance, random sampling, delimited file, variable list, proc freq, sas programming, correlation, regression analysis, anova	9
15	Exploiting Health Care Data Through Hybrid OLAP	Rush Daugene	Using the Hybrid OLAP architecture to present and analyze health care data can provide several benefits. One is the ability to partition claims of different types into multiple physical MDDBs that can appear as one to the end-user. This type of partitioning is known as racking. Another benefit of Hybrid OLAP (HOLAP) is the ability to use tables within the data model that may have special aggregation rules, such as can occur in enrollment data. This technique is called stacking. This paper will present a hypothetical health care OLAP data model that uses both racking and stacking. This will include an overview of the model desigo, definition of the HOLAP Data Group and exploitation of the fmal proxy MDDB using multidimensional reports created in SASIwebEIS. SAS products used include Base SAS, SASlEIS, SAStMDDB Server, SAS OLAP Server and AppDev Studio	proc step, data warehouse	6
16	Get the Data without SAS/CONNECT? And the PC SAS user does HOW LITTLE? With a shoestring budget?	Zeke Torres	Distribute SAS (almost any data) not only to your own machine but various users you may support throughout your organization even if `SAS/CONNECT` is available or not. `SAS/CONNECT` was available as in this case, however the client specifically requested to stop giving PC SAS users access to `SAS/CONNECT` and the Host CPU. The main intent was to keep the ad-hoc SAS report(s) submitted by PC SAS users from draining the CPU resources but not put constraints on their ability to produce reports their departments required. I was able to come up wnh a solution for my client by using simple tools available with PC SAS and FTP	proc step, sas log, proc contents, proc copy, dataset, data step	6
17	Introducing Variability to your SAS MACROS: Programmers Guide to Implement Varying Number of Parameters	Michael P.D. Bramley	This paper describes the components of a SAS MACRO catalog that allows SAS programmers to implement SAS MACROS with a varying number of parameters using the PARMBUFF option. Two methods of extracting parameters from such a macro invocation are examined along wnh their benefits and drawbacks, along with how they are implemented in the catalog. In addition to using a variable number of parameters in the SAS System, this paper illustrates MACRO programming techniques, such as, the use of the %SYSFUNC, %SYSEVALF and other macro functions. Finally, a solution to a speCific problem is provided as an example to provide readers with a springboard for creating their own macros of this type. This paper does not assume any advanced SAS MACRO knowledge on the part of the reader	macro function, macro variable, keyword parameter, %macro parameters, macro definition, macro conditional, macro loop, macro put, macro parameter, macro catalog, macro call, sas programmer, macro quoting function, variable, macro facility	6
18	JMP Density Ellipse Script Code Made Easy	Charles E. Shipp, Kirk Paul Lafler	We show the use of scripts to meet two useful	correlation, interval variable, predictor variable	2
19	JMP Density Ellipses for Pharmaceutical Analysis	Charles E. Shipp, Kirk Paul Lafler	JMP is a data discovery tool used in both (1) the exploratory phase and (2) the analysis phase, of experimental and theoretical work. The density ellipse shows the extent of data, the center of mass, the least squares fit line, and the degree of correlation between a selected dependent variable and a selected independent variable. When superimposed, the ellipses of similar variables for different classes show and contrast their sameness and differences. The example used is pharmaceutical dummy data in the area of cancer research	predictor variable, response variable, correlation, class variable, proc sgplot	5
20	MARKUP: The Power of Choice and Change	Eric A. Gebhart	When it comes to markup languages, there are lots of choices. If you are keeping up with the web, you might say XML is your choice. XML alone is full of choices. But XML is just the latest craze. There are lots of other markup languages out there. Using the `ODS` MARKU P output destination the ability to create these types of output are within your grasp	proc step, output delivery system, proc template, put statement	10
21	Navigating Between Data Levels: A Tutorial to Working with Unit of Analysis Difference in Survey Research Data	Chris Becker	Working with multiple data sets can be a challenge when the data are not all on the same lev~1. For example, imagine two data sets, the first one containing information about households and the second one containing information about persons in those households. Because households may be comprised of more than one person, a household record may have several person records associated with~. Thus, the relationship between the household data and the person data is one-to-many. Extracting data from one data set with the intent of combining it with the other data set can be tricky in this situation. Valuable information can be lost in the process. This paper highlights how SAS maKes the naVigation from one level to the other possible. A variable in the person-level data set can be converted to a household level variable by first creating a subset, sorting the subset on the appropriate variables, and then using the special SAS first. dot or last.dot variables	by group processing, keep statement, proc step	3
22	ODS (Output Delivery System)	Destiny Corporation (a company)		proc step, proc tabulate, output delivery system	8
23	Positioning SAS Software for Corporate Effectiveness	John M. LaBore, Thomas H. Burger	Accelerated research and development has increased industry reliance on Infonnation Technology (IT). ~iophannaceutical IT divisions increasingly require an infrastructure capable of providing global enterprise-wide business solutions. However, when the application of IT innovation to business solutions occurs at an insufficient rate, business needs go unfulfilled. Of particular importance to accelerating research is the implementation of application software for decision making. SAS so~are provides powerful tools for data warehousing, deciSion support and presentation, but their effectiveness is directly proportional to an understanding of business issues and how SAS can solve them. A strategy for the integration of these tools into the business streamlines and accelerates critical processes	sas programmer, data cleaning	6
24	PROC TABULATE Basics	Destiny Corporation (a company)		proc tabulate, proc step, label statement	21
25	Random Coefficient Model for Hazard Analysis Critical Control Points (HACCP) A Pilot Study	Xinpeng (Tom) Wang, Yating Sun, Julie Caswell		covariance, proc mixed, proc step, likelihood function, missing value, fixed effects, proc genmod	3
26	Random, Repeated or Both? Analyzing a Repeated Measures Design using PROC MIXED	Keith Dunnigan		proc mixed, repeated measures, proc step, repeated measures anova, covariance, likelihood function	7
27	Repeat Purchas Factor - Applied Analytic to Understand and Manage Repeat Purchase in Information Driven Markets	Kishore Nath	The knowledge and application of statistical theory or probability has made the simple buying/selling exercise into an Information driven Marketing Process. The important aspect of the second transaction is consumers' independent assessment of the product meeting their expectations. In fact this second transaction is a realistic assessment of the market as it clearly communicates - from the COnsumers side - a product's acceptance in a real market. As all do not make this second purchase - a measure of acceptance is possible using the right statistical tools. This paper makes an effort using SAS to develop and define a statistic called REPEAT PURCHASE FACTOR (RPF). This RPF provides knowledge to measure and manage second purchases. Subsequent or more than two purchases are excluded from this paper. A new set of concepts - TIME BUCKETS, WAIT TIME, PRODUCT LIFE and ONE TIME BUYER - are introduced. These concepts are used to generate the RPF	sas function, likelihood function	7
28	Shouldn't Clinical Reporting be EZ! A Pharmacia approach to clinical reporting	Rod Kamphorst		macro definition, dataset	3
29	Simplifying SAS Security	Derek P. Morgan, Michael A. Province	An increased emphasis on the security of data within the organization has led to the use of the security built into the SAS System. The encryption and passwording of the datasets used for this project was relatively easy to accomplish. However, day-to-day uses of this data range from analysis to data entry to ad hoc query. How do we allow all the different users access without hard coding the passwords, or forcing them to continually type in passwords? By using macro variables to carry the passwords. The Method Creating a SAS system table with the built in security is easy. There are three levels of password protection: read, write, and alter. You can employ one, two, or all three on any given dataset. In addition, you can encrypt a dataset with the simple dataset option ENCRYPT=YES. The datasets for this project are encrypted, and use all three levels of passwords	macro variable, proc step, dataset	5
30	SQL Basics	Destiny Corporation (a company)		order by, proc step, proc sql, select, proc sort	5
31	The Smart Reporter for Healthcare	Diane E. Brown		where statement, business intelligence, data warehouse	5
32	The Wealth of JMP Final Reports	Charles E. Shipp, Kirk Paul Lafler	Once you have discovered the nature of your data and its relationships using JMP, it is important to communicate with statistical graphics and tables to (1) your co-workers and management; (2) business partners; (3) review agencies; and/or (4) customers. By looking at the complete range of JMP reports and explaining their richness, we shoW an overview of JMP. We also show how to produce these reports and how to store a library of scripts to generate them and their joumal files which can go into MS Word and PowerPoint final reports	correlation, cluster analysis	5
33	This Club Doesn't Need a Secret Handshake: Establish an In-House SAS User Group	Francine Cannarozzi		sas programmer, data wrangling	3
34	Using Model Fitting Information and PROC PLOT to Select the Type of Varianc-Covariance Structur	Radhi Abdulnabi	The statistical analysis of repeated measures data must address the issue of covariation between measures on the same unit, because it is usually plausible to assume that observations on the same unit are correlated. The selection of an appropriate type of covariance structure can substantially improve the effICiency of inferences made about the mean structure and provide better estimates of standard errors of estimated mean parameters. The REPEATED statement in the `MIXED` procedure provides a rich selection of covariance structures. Selecting the appropriate covariance structure is a major hurdle in the use of `PROC`	covariance, covariance structure, repeated measures, proc step, likelihood function, proc mixed, longitudinal data, proc calis, correlation, ar(1), macro variable, sample, macro definition	7
35	Using ODS to Create User Defined Reports Without Proc Template	Nicolle Mode	The Output Delivery System (`ODS`) for SAS version 8.2 offers users the ability to create high quality reports in a variety of fonnats, from a variety of procedures. There are currently many well written and comprehensive tutorials for using `ODS`, especially from the SUGI conferences. These advanced level tutorials include many options for creating and customizing output including the array of style choices within `PROC TEMPLATE`. Unfortunately `PROC TEMPLATE` can be daunting to a novice user, and the majority of examples are written with HTMl output in mind. In this presentation I outline several ways to customize reports without the use of `PROC TEMPLATE` with postscript, pdf, and rtf output. Specifically I review several `PROC REPORT` options, in line formatting (for printer destinations), and user-defined column, row, and cell style attributes. The user-defined style attributes provide the ability to create reports with dynamic attributes that change based on the reported values	proc step, proc report, proc template, output delivery system, proc format, adverse events, ods rtf	4
36	Using SAS Data to Drive Microsoft Office	Darren Key, David Shamlin	Microsoft Office provides tools for integrating its suite of programs with other vendors' data sources. There are a variety of ways to do this using various ActiveX components and VBA scripting techniques. While the number of choices available can add to the complexity of creating a customized solution, the basiCS of integrating with SAS data sources can be simplified wHh some basic code patterns for migrating data and reports between Microsoft Office and SAS. We will outline basic pattems for importing SAS data into Microsoft Office documents as well as exporting data back to SAS. The paper gives Implementations ofthese patterns in the form of Visual Basic code that can be customized for site-specific usage scenarios. We will demonstrate the application of these techniques to tasks involving the migration of data between SAS data sets and Microsoft Office and Outlook applications	advanced sas, structured data	8
37	Using SAS DDE/ODS Together with SAS Access and % Windows to Automate Campaign	Traci Milholen, Joshua Smith	This paper discusses the automation of a campaign analysis procedure that, when done manually requires about two weeks of analyst work, yet with the fusion of several SAS operations, can be completed in a matter of hours. The union of SAS Access, SAS Output Delivery System (`ODS`), SAS Dynamic Data Exchange (DDE), and % WINDOW enables SAS to function as the central hub bringing together several components of a complex analysis process, essentially replacing the analyst role by automating the process	excel, proc step, proc sql	3
38	Using SAS System to Geneerate Customized Kaplan-Meieer Curves and its Applciation to Presentation in Clinical Research	Daojun Mo, Yiyong Fu		proc step, clinical trial, p-value, macro definition, randomization, excel	14
39	Using the FILEVAR= Option for Input and Output	Derek P. Morgan	The ~roblem of handling multiple flat or ASCII files with the SAS System has been one that has been solved many times with macros. However, there is an easier way, one that saves resources, time, and programmer frustration. The FILEVAR= option on the infile statement takes care of switching among multiple ASCII files, and it works for both input and output. Working from production examples, this short paper will explain how to use it, and the advantages over traditional macro methods of handling this problem. Old-time SAS System programmers like me used to use macros to handle multiple files for input or output. We'd read one file, create a SAS System data table, append it to the master template, and process the next file in the same fashion. The file name information would be stored in a macro variable, and the macro variable would change with each iteration ofthe loop. While this does have its place, you are no longer forced to do it this way	infile statement, input statement, dataset, output, end= option, flat file	4
40	V9 OLAP - An Architectural Overview	Duane E. Ressler	What's new in V9 SAS OLAP ServerlM software? Just about everything. Completely rewritten for Version 9, SAS OLAP Server software uses the SAS scalable architecture to support high performance scalable multidimensional analysis. Our experience with HOLAP and Access Control has been integrated into a completely new package designed as a mu~i user, scalable server component that natively supports industry standards such as OLE DB for OLAP and the MDX query language. That means that open clients can access OLAP information quickly and easily. A basic knowledge of the intemals of this new implementation can be helpful in getting the best performance out of SAS OLAP Server software by designing the cubes and sizing the hardware to support growing data sources	data standard, parallel processing	5
41	Version 9 Changes and Enhancements	Dana Rafiee, Destiny Corporation (a company)		output delivery system, sas management console	16
42	Wireless SAS Apllications for iPAQ% using SAS/IntrNet%	David W. Yeung, Thomas H. Burger, Glen J. Dalrymple	Personal digital assistants (PDAs) and SAS software can provide mobile, real-time data access. It is no longer acceptable for analysis and delivery to be completed in days or weeks but rather, seconds. Just as cell phones traosformed telecommunications, wireless PDAs will revolutionize data access. Integrating SAS with wireless devices can yield remote, powerful, data entry, retrieval, and analysis. We discuss a	data integrity, sas base	5

Back to Conf go 2003 go 2001

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.