SCSUG 1994 Papers - Index

27 papers. Source: SCSUG (South-Central SAS Users Group) conference proceedings.

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	A Development Environment for Applications Based on SAS Software	Donna Martinez	Data structures, desl!1l methodologies, and programming tools are the foundation components of an application development environment. This paper describes these components using a SAS software perspective. Specifically, the paper covers design methodologies, management of application components, preparation and maintenance of parallel test and production environments, and reusable code libraries. A sample SAS application that uses the described techniques concludes the paper	libname statement, catalog, sample	4
2	A One-Size-Fits-All Macro to Reduce Repetitive Coding	Mark Lindsey		macro variable, macro facility, macro definition, %if-%then-%else, proc means, macro quoting function, proc step	12
3	Comparing Patient Quality of Care Scoring Methods with SAS-Produced Paired Boxplots	Joel A. Dubin, Carol M. Ashton	A program using both SAS Macro Language and `SAS/GRAPH` was developed to communicate 2 types of patient quality of care (i.e., adherence to process of care) scores to 12 hospitals. The object of the program was to present each hospital the spread of their unweighted and weighted adherence scores compared to the other II hospitals (via boxplots). These scores were calculated for every combination of 3 different diseases (i.e., congestive heart failure, chronic obstructive lung disease, and diabetes mellitus) and 3 separate portions of the patient stay at the hospital (i.e., admission workup, treatment regimen, preparation for discharge) thereby creating 9 graphs. The convenience ofkeeping all the boxplots (for a given graph) on a single page was important. To accomplish this goal, SAS code was created to place the 2 distinct boxplots for any hospital side-by-side	box plot, macro facility, macro variable, macro definition	9
4	Coping with SAS Error Messages	Stella Wang		error message, sas log, automatic variable, error, proc step	3
5	Creating 'Variable Name' Data Sets with CALL VNAME and PROC TRANSPOSE	David Swift		raw data, proc transpose, proc step, call symput, do loop, macro variable, macro loop	8
6	Creating an Autocall Macro to Convert SAS Datasets to Text Delimited Files	Doyle McDonald		dataset, character variable, numeric variable, macro variable, data step, autocall macro, macro call, txt, proc sql, date variable, macro definition, proc step, proc contents	9
7	Debugging SAS Macros	Thomas J. Winn Jr.	The SAS macro facility is a powerful tool which greatly enhances the functionality and flexibility of the SAS programming language. However, the complexity of programming code which utilizes SAS macro language statements sometimes also makes it difficult to debug. The SAS System includes some programming statements and options which can be used in the process of correcting code that is not working properly. This tutorial will describe a strategy for using the MPRINT, MLOGIC and SYMBOLGEN options, as well as OfoPUT statements, for debugging purposes, including examples of the interpretation of diagnostic messages pertaining to the macro facility	macro variable, macro facility, sas log, options statement, error message, proc step, macro call, macro definition, put statement, &variable, macro debugging, proc print, macro put, macro parameter, dataset, proc sort, if-then-else, %macro parameters, macro loop, proc options, %if-%then-%else	18
8	Exploring Data Using Base SAS Software	Thomas J. Winn Jr.	Statistical methods are tools which are used to summarize and analyze data. Exploratory data analysis is the application of graphical and statistical techniques to discover the structure of data. The goal of exploratory data analysis is to characterize the data and to reveal fundamental relationships among them. It is quick, dynamic, and highly interactive. Furthermore, exploratory data analysis is not just for use by professional statisticians - the methods also are used by scientists, engineers and many other types of researchers. This paper explains how to produce and to interpret scatter plots, histograms, stern-and-Ieaf plots, box-and-whisker plots, and various descriptive statistics, using Base SAS software. Introdyctlon Originally, the SAS System was a combination of programs for performing statistical analysis on data	proc step, proc univariate, central tendency, exploratory data analysis, data science, correlation, interquartile range, numeric variable, standard deviation, sas base, data analyst, cv, proc freq, proc corr, proc means, bar chart, box plot, raw data, dataset, sample, histogram	6
9	Exporting SAS/GRAPH Output to Other Applications	Mike Kalt, Peter Ruzsa		filename statement, catalog	7
10	Flexibility of SCL Lists	Scott Groussman, Robin Yeldell	SCL . Usts, a new data strudure implemented in SAS. version 6.07, provide many new programming techniques to SeL programmers. Through examination of a classic problem, the following list techniques and flexibility will be discussed: Array Altemative - SCL lists can effedlvely replace single and multi-dimensional arrays Dynamic Strudure - List items can be dynamically added, deleted, and rearranged Dired Access - Ust items can be accessed by an index value or by a name . Argument PaSSing - Lists can greatly simplify the passing of a large number of arguments Data Set Alternative - lists make convenient tables and can be ac:cessed faster than data sets Data Sharing - List items can be stored In an environment list and made common to other routines * Storage Option - Lists can be saved to disk for later retrieval	dataset, macro variable	5
11	From Optical Scan Sheets or Databases to Output: How SAS Takes Us There	Christine A. Stroup-Benham, Laura A. Ray		input statement, proc step	16
12	Intelligent Query Tools for Querying and Reporting	Beverly Wells, Henrietta Cummings	The SAse System Is contfnually expanding to offer additional functionality for users. Recent product development has focused on our cusfomers who need to easily access and query data. The SAS System provides a variety of methods that allow you to access and query your data, ranging from SOL (Structured Query Language) editors to GUI-based query tools to natural language tools-you choosa the tool thafs right for your users. In this paper. we'll focus on two query tools-the SQl Query Window and Query and Reporting from DB2 (Q&R). We'll also brlelly describe a third query tool. SASJENGlISH- software. that can be used to query data through the use of SAS views. The Intent of this paper Is to Introduce these query tools-the Information Is not comprehensive of all features	proc sql, proc report, view, dataset	4
13	Intervention Analysis in Vocational Rehabilitation	David B. Cohen	Rehabilitation outcomes are an important aspect of state vocational rehabilitation agencies operations because funding must be determined by what positive out comes (26's) can be achieved, on a lag basis each year. To gage this, managers look at monthly productions (26's) to determine where they were at the same time the previous year and how much production they deem to meet their goals for the end of the year. Although productions growth has been driven by the increase and population and result in hiring of new counselors at the Texas Rehabilitation Commission (TRC), decreases in budget will likely drive those 26's down	regression analysis, moving average, trend analysis, proc reg, correlation	12
14	Lead Time to Return	Harriet Bricha	Lead Time to Return by Harriet Brichta Which came first, the chicken or the egg? This question has challenged the brightest minds. and was probably the motivation behind the development of the Cross Lag Panel design, a statistical methodology utilized to infer causality from correlation data. This paper presents one practical application of the Cross Lag Panel design in business. Lead time to return is a procurement analysis tool that is based in 'just in time" processing. Specifically, correlations between purchases and revenues are used to identify whether acquisitions are reactive., proactive, or just in time. When coupled with independent profitability measures, optimal procurement strategies may be identified	correlation, sample	6
15	New Tricks for an Old Tool: Using Custom Formats for Data Validation and Program Efficiency	S. David Riba	`PROC FORMAT` Is one of the old standards among SAS- Procedures, yet many programmers often fail to understand how custom formats can be used to Improve their SAS programs. This paper will examine some ways user defined custom formats can be used for data validatiOn, for developing more flexible SAS program code, and for other programming efficiency techniques. It will Illustrate how the SAS programmer can avoid hard-coding conditional logic chains in a program, how data can be grouped for analysis. how the appearance of report output can be enhanced, and how SAS data can be recoded for more efficient storage. The paper will also review recent enhancements to `PROC FORMAT` such as Control data sats, format reports. and the ability to define and use format libraries	proc format, proc step, user-defined format, dataset, if-then-else, input statement, data cleaning, sas programmer, character variable, where statement, sysdate9, format statement	8
16	On A More Efficient Use of Quadratic Logistic Discrimination	Dean M. Young, Samuel L. Seaman	"On a More Efficient Use of Quadratic Logistic Discrimination" Dean M. Young and Samuel L. Seaman Baylor University Waco. Texas Quadratic logistic discrimination has often been avoided in applied statistical discrimination research, in part, because a large number of parameters must be estimated whenever there are more than just a few predictor variables under study. A dimension reduction procedure derived by Peters, Redner, and Decell, and made applicable by Tubbs, Young, and Odell, can be used to combat the ill effects of dimensionality in the quadratic logistic discrimination problem. We demonstrate that, under certain population configurations, the technique is theoretically correct	logistic distribution, dimensionality reduction	3
17	Plotting Confidence Intervals and Prediction Bands With SAS/GRAPH	Huixing Tang, David Swift, Kerril S. Bauerly	This poster presents a method for generating a regression plot using `SAS/GRAPH` shading (`SAS/GRAPH` Software, Volumes 1 and 2, Version· 6 (SAS Institute, 1990). The information displayed on the graph includes the following: -Predicted value -Observed mean -Observed individual value -Confidence interval -Prediction band A step by step description of the procedure will be provided using a simulated data set of science and mathematics test scores. For this illustration, scores on the mathematics test, MATH, are used as the dependent variable, and the scores on the science test, SCIENCE, are used as the independent or predictor variable in a simple linear regression analysis. Both variables are stored in the data set INPUTDAT. The resulting regression plot will show how well science performance predicts math performance at both the group mean and the individual score level. Step 1	confidence interval, proc step, regression analysis, proc reg	5
18	Predicting Managed Care Hospital Discharges and Bed Days	Marsha S. Weston, Darlene M. Reinhard		insurance claims, dataset	17
19	SAS and DB2: Making the Connection	Kathe Richards		proc sql, sas programmer, proc step, dataset, where statement, sas library	9
20	The Reports Management System (RMS) -- Meeting Agencies' Reporting and Querying Needs	Chris Greene, Dan Laredo		sas base, dataset	8
21	The SAS System as an Information Database in a Client/Server Environment	T. Randall Betancourt	In implementing a successful data access strategy, it is important to recognize there are appropriate and inappropriate ways to access data depending on the nature and distribution of that data and the types of applications requiring access to the data. In some cases it may be appropriate to give users access to the data through views. But, if the views are to a production or transaction-oriented database, the prospect of having 300 users making ill timed and ill-framed queries can quickly lose its appeal as the database performance grinds to a slow crawl. In such a case, giving users access to separate extract files organized in an information database might be more appropriate. This paper will examine the role of the information database in enterprise computing, and database features of the SAS System that allow it to be a cost-effective alternative to a commercial DBMS as a source for data required by ad-hoc query and reporting, and decision support applications		7
22	Two Macros for Calculating Often Used Statistics of Symmetry and Agreement in the Biopharmaceutical Industry	Jeff Heckathorn, Mark F. Munsell	When interest lies in measuring symmetry between two categorical variables, statistics such as those proposed by Stuart [1955], Maxwell [1970] and McNemar [1947] are often employed. When interest lies in determining the extent of agreement (or correlation) between two or more raters or measuring devices, the concordance rate or the kappa statistic proposed by Cohen [1960] may be employed. When interest lies in describing the relationship between a screening test (or symptom) and the disease to which it relates, statistics such as sensitivity, specificity, positive predictive value (pV+), and negative predictive value (PV -) are generally employed. This poster presents two (2) macros which are actively used in the· biopharmaceutical industry to calculate and present the above statistics with appropriate confidence intervals (binomial [1973] or normal) and p-vaIues	proc step, data step, confidence interval, binomial distribution, cohen's kappa, sample, proc freq, proc print, baseline, macro variable, temporary dataset, missing value	12
23	Up to 50 x SAS Performance Gains on Large Data Volumes Using Scalable Parallel Computing	Jesse Davis, Helen Spade	Turning large volumes of historical data into valuable information to support the decision making process of management is a growing need of corporations in the 90's. However. the ability to perform fast data reduction on large data volumes is limited by IIaditional computer systems which can take hours of CPU time and days of elapsed time to process multi-gigabyte datasets. This paper describes how one of my customers in the health care industry addressed the volume issue in health decision support processing and improved the end user's toolsets. The paper describes the problems encountered while trying to achieve their business goals, and the hardware and software solution implemented to resolve these problems. Actual performance numbers are given for Tabulate, Select, 3-way Join. Nested Select Queries and a multiple user test. With up to 50 X faster query tum-around times on large data volumes	data science, elapsed time, output delivery system, proc sql	6
24	Using PROC SQL Effectively With SAS Data Sets	Jimmy A. DeFoor		proc sql, proc step, where statement, having, create table, key=	12
25	Using the SAS System in an Integrated Survey Application	Paul E. Pope	This paper describes how the SAS System's file format conversion tools were exploited to create an application that integrates various software to analyze, query, afld present survey data	proc step, proc cimport	6
26	Using the SAS System to Help Manage Data	Clarence W. Jackson	This paper describes how the SAS System can be used to help manage data. Actions such as adding, deleting, and updating of data requires a data manager to be alert in the management of data in order to insure data integrity, especially when that data is being used in reports, graphs, and other displays of the data to an organization operational and management staff	data governance, proc step, proc freq	4
27	Your Map to the Sea of GUIs: A Primer on Moving SAS Applications Across Graphical Operating Systems	James D. Hefner	Currently, most SAS Software application developers have only one or two graphical operating systems (such as Microsoft WindowsTM, or OSF/Motif") to support. However, the pending release of the SAS System for the Apple Macintosh, and the introduction of new hardware and software such as the PowerPC, PowerMac, and Wabi, means that application developers may have to support two or more graphical operating systems. This paper is intended to assist application developers, both in the teaching of the fundamentals of graphical operating systems, and in the moving of `SAS/AF` and `SAS/EIS` applications from one operating system to another	by group processing, independent qc	7

Back to Conf go 1995 go 1993

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.