HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

SUGI 1986 Papers - Index

181 papers. Source: SAS Users Group International conference proceedings.

# Title
×
Authors
×
Abstract
×
Keywords
×
Extras Pages
1 A Computer-based Multi-currency Short-term Funds Management Exercise Alex Anckonie III deposit rate, interest rate source 4
2 A Computerized System for the Preparation of Data Entry Instructions Ruth F. Quah crf, input statement, dataset, proc step source 5
3 A Consumer Credit Portfolio Trend Analysis System in the Information Center Environment Marshall Constantino,
Richard D. Heberlee
credit portfolio, delinquency source 5
4 A Generalized Full Screen System Used to Monitor Pharmaceutical Product Development Maribeth Mercker,
Joseph B. Quinn
SAS code has many structured features wh; ch lend themselves to fill-in-the-b1ank menus for the naive user which, when processed, create SAS code for a specif;c task. In a work environment where information is cont;nually updated, a flexible system which enables the management and use of such informat;on in a Ume1y and efndent manner enables the user to keep abreast of the implication of such changes. We have found that the SAS full screen editor, available through PROC FSEDIT in SAS/FSP, provides the capabi1 ity of a menu-driven system which has the added advantage of placing the user d;rectly ;nto the SAS environment. In th;s paper we discuss our system of monitoring pharmaceutical product development using interactive techn;ques of PROC FSEDIT which apply to both the TSO and CMS environ ments and make use of both the DATA and PROCEDURES steps of SAS proc step, put statement source 6
5 A Generalized Growth Curve Procedure for the Analysis of Incomplete Longitudinal Data Kenneth O. Story,
Edward F. Vonesh
The GGCMAOV (Generalized Growth Curve Multivariate Analysis of Variance) procedure analyzes a class of polynomial growth curve models that commonly arise from longitudinal or repeated measurements studies. The program is written in the MACRO language of the version 5 release of SAS and follows closely the REPREG program written by Love and Carter (1984). The GGCMAOV program performs estimated generalized least squares (EGLS) estimation of random coef ficient growth curve models (RCGCM's). Option ally. the program can perform tests of hypothe ses as well as pairwise comparisons for com pari ng mean growth 'curves between two or more groups. A primary feature of the program is that it allows for incomplete and/or unbalanced longitudinal data macro variable, manova, anova, generalized least squares, regression analysis, sample, class variable, confidence interval, response variable, longitudinal data, multivariate analysis, proc step, proc reg, outlier, predictor variable source 6
6 A Generalized SAS Algorithm Including Error Diagnostics for the Switchback Experimental Design with Three or More Treatments Nancy K. Keith,
George D. Williams
PROCEDURE SWITCH is a user written SAS algorithm which calculates the analysis of variance, treatment means, standard deviation, R-square, and coefficient of variation for switchback experimental designs with three or more treatments. The switchback experimental design is useful for controlling period effects due to changes in environmental conditions and variation between subjects' response levels. The switchback design is described by H. L. Lucas (2). PROe SWITCH includes options to specify a blocking factor and a data set name. Parameters which must be specified are period, treatment, and subject variable names. A variable statement must be present which specifies the response variable proc step, missing value, standard deviation, response variable, variable, sample source 3
7 A Macro for Conditional Ordinary Least Squares and Weighted Least Squares Analysis of Repeated Measures Data Margaret Burchinal by Margaret Burchinal. Chapel Hill ilLS Rl't is _a -PEOC MATRIX m.acro that performs variol1s types of analyses of repeated m.easures data that cannot be easily done with PRoe GLff, even wit. the REPEATED statement. These methods for analyzing repeated measures data often will be more powerful than the tests parLormed by PBOC GLK ~hen the model assumptions are met. The four types of analyses condl1cted by WL5_BM involve fitting a truncated polynomial growth curve (PGC) model through ordinary leas~ squares (OL5) estilD.ation~ weighted least squares (WLst estimation, and conditional OLS estimation.. The order of the PGC fit to the data is either specified by the user or, ~nder condl tional OL5 estimation, is determined through series of top-down analyses of the data. Y,LS_RIS pro1fides point estimates of -the parameters, longitudinal data, repeated measures, covariance, main effect, proc calis, if-then-else, sample, rank test, response variable, macro conditional source 6
8 A Macro Library for Classical and Robust Multivariate Modeling Kathryn S. Fletcher,
E. James Harner
This paper describes a macro library for modeling multivariate data. Currently, three statistical macros are available: REG, for regression modeling; PCA, for principal components analysis; DISC, for discriminant modeling. Each of these allows a number of options, including robust analyses and validation techniques. The macros are geared toward interactive modeling. The commands for invoking the macros are easy to use and are brief. The output displayed at the terminal is carefully selected. Additional output -- depending on the number of observations, e.g., residuals -- is output to a SAS data set which can be printed by the PRINT utility macro. dataset, covariance, regression analysis, data cleaning, proc step, correlation, proc princomp, bootstrap, robust estimator, discriminant analysis, response variable, proc robustreg source 3
9 A Macro-driven Forecasting System for Evaluating Forecast Model Performance Bryan Sellers residual, data step, regression analysis source 5
10 A Menu-driven Method of Copying SAS Data Sets Nat H. Wooding Jr. proc step, proc copy, dataset, libname statement, proc contents, select source 3
11 A SAS Based System for Calculating and Tracking Data Processing Error Rate Estimates Ellen Gilkerson,
Virginia Ozer
An interactive SAS based system was developed by the data compliance group in the Biostatistics and Clinical Information Processing (BIOCLIP) department to cal culate and track data processing error rates for clinical trial data. This system permits tracking and reporting of error rate information across project, study, or form type. In addition to saving time and improving accuracy as compared to previous hand-calculation methods, the system provides detailed feedback on pre- and post-QA error rates to data processing management sample, data wrangling, crf, clinical trial, proc step source 4
12 A SAS Based System for Utility Rate Analysis Eugene Y. Ho The SAS sys tern has experi enced phenomena 1 growth in application since its introduction. The power and versatility of SAS macro facility allows user to develop and build flexible as well as user-friendly softwares. Thi s paper descri bes a SAS-based system used at the Revenue Requirements department of Southern California Edison Company for rate analysis. The system is menu-driven to allow rate design analysts to perform 'what if' type analyses due to changes in rate components, to perform customer impact studies in different climatic regions, and to make recommendations on implementing new baseline rates. Furthermore the system is designed for use and maintenance by non-programmer macro definition, proc step source 4
13 A SAS Macro Which Computes Upper Confidence Limits of the Number of Defective Units in a Lot Melvin T. Alexander confidence interval, sample, confidence level, quality control, binomial distribution, sample size source 4
14 A SAS Procedure Used as a DBMS Update Machine Linda A. Smith This paper describes a SAS procedure. written in PL/I. that was developed as an update machine for the Consumer Price and Consumption Studies (CPCS) Branch of the Bureau of Labor Stat; sti cs. Thi s procedure updates a fi 1 e stored as a relation in the RAPID Data Base Management System. The input transaction records are stored in a SAS data set. The procedure is executed in one of three mutually exclusive update modes: ADD. for adding rows (records) to a RAPID relation; DELETE. for deleting rows; and CHANGE for modifying the values of variables on existing rows. The procedure is also executed in one of four incremental levels of processing: SCAN, for scanning the userls PROC UPDATE statement; EDIT~ for scanning and then editing the user's SAS variables; TEST, for scanning~ editing~ and accessing RAPID rows; and UPDATE, for scanning~ editing, testing and actually updating the RAPID relation proc step, dataset source 3
15 A SAS Program for ANOVA When the Input Data are Group Means Aloha E. Bryson covariance, anova, sample, main effect, proc step source 6
16 A SAS/AF Software Based Clinical Data Review System Richard E. Raftery,
Martin J. Rosenberg,
James F. Sattler
sample, clinical data source 3
17 A SAS/FSP Software and CLIST System for Easy Management of a Macroinvertebrate Reference Collection Todd C. Folsom proc step, proc contents, proc append, permanent dataset, dataset source 5
18 A Simple Documentation Indexing System Reina B. Cobb,
Gwendolyn B. Crawford,
James M. DeYoung Jr.
sas library, macro facility source 2
19 A Simplistic Approach to Tabulating and Summarizing Clinical Laboratory Data Carol A. Bogardus,
Les Pennelly
When summarizing human safety data for new drug applications in the U.S. and foreign countries it is necessary to pool laboratory dat~ across all studies conducted with the new drug. Data management in clinical trials ;s complicated by the fact that multiple service laboratories are used, even with1n each study. In addition. these laboratories often do not have the same normal ranges and may even report the same lab oratory test results in terms of different units. Manipulation of safety data can be sim plified by the organization of SAS laboratory data files into individual records identified by study. service laboratory, patient 10 and visit date. Summarization or tabulation of the data may be performed by concatenating the ap propriate records in any of a mUltitude of ways using the standard file-handling featUres of SAS. In this way, a pooled data set across studies may be processed by the same laboratory data analysis system that handles individual study analyses laboratory data, data science, clinical trial, dataset, proc step, proc freq, proc rank source 3
20 A System for the Analysis of Cohort Mortality Data Edward L. Frome,
Richard W. McLain
A system is developed for the analysis of cohort mortality data. This Mortality Analysis System (MAS) is designed as a research tool in epidemiologic studies. The system allows a re searcher to investigate the effect of one or more factors on the mortality of a study cohort. Variables can be categorized as fac tors to allow for stratification in the analy sis. DATA. steps and PROC MATRIX are incor porated in the system to produce the output. Person-years, observed deaths, and expected deaths are calculated and cross-classified by the levels of the factors. The resulting data set can be used to compute the standardized mortality ratios (SMR) for each stratum level. Poisson regression models can then be used for further statistical analysis calendar year, data science source 3
21 A Tool to Manage End-user Computing (Rapport) Karl McSheffrey Rapport is a tool for the end users that will permit them to create report speci fications and produce reports using an management reporting, proc sql source 6
22 A VM/CMS SAS Based DB Query Application Employed as a Function of a Contracted Business DMS Michael L. Confer,
David S. Septoff
In the course of developing a SAS based data management system (OMS), an end user require ment was uncovered which had not been identified d~ring preliminary analysis or addressed by base l1ne system design. This requirement comprised the capabi 1 ity to "cut" a segmented database whi~h documented business activity over a broad var1et~ of contracted and in-house (eg: overhead) tasks.l~ order to augment offline data analysis. A declslon was made to execute this "cut" in the VM/CMS environment based on the availability of resources already dedicated to OMS development and comp~rative.familiarity of end users with this op eratlng e~vlronment. Ou~pu~ (report) requirements and key f1elds/character1st1cs upon which to base meanlngful data extraction were identified through analysis and user interview and work commenced as described herein proc print, proc step, proc means source 4
23 Advanced Macro Programming Lynn Hannah macro variable, macro quoting function, macro facility, macro put, macro definition, %if-%then-%else, macro call source 3
24 An Access Language Retrieval Class for End-users at CONOCO Thomas E. Ikard order by, where statement source 2
25 An Alternative Technique for Analyzing System Paging Workloads H. Pat Artis The presentaflon of paging data to management in an easily understood form has been a persistent problem. This paper examines a graphical technique for-presenting paging data activity as a relative fraction of the system's total I/O activity. This technique will also be used to comment on the benefits of paging into Expanded Storage on the new IBM 3090 series of processors. 1.0 Introduction Paging is acomplex activity that can consume a significant portion of a system's overall capacity. As such, paging is a significant factor in system performance that must be included in any management reporting scheme. Historically, most analysts have chosen to report paging rate as an indicator of system paging activity, The use of paging rate as a management reporting indicator makes the implicit assumption that the reader of the report is aware of some range of paging values that are ideal for the reported system sample, if-then-else source 4
26 An Estimation System for the End-user Rick Marrie,
Samuel M. Slowinski
An IBM ISPF menu-driven dialog provides the foreground for SAS programs that generate demand deposit ownership estimates from survey data~ The input screens are fully documented with tu torials and easy for the end-user to eXecute. The programs retrieve micro data, trace an IMS data base for mergers and acquisitions, resolve structure changes, produce data analysis diagnostics, generate strata summaries with esti mates and standard errors, and table the results. DDOS Survey The Demand Deposit Ownership Survey (DDOS) provides estima.tes of the components of demand deposits held by individuals, partnerships and corporations at commercial banks~ Five de pos i tor ccmponents are identified in the Survey: financial business, nonfinancial business, con sumer, foreign, and all other. Based on data reported by a sample of banks, Board staff con structs national estimates quarterly (March, June, September, and December) for two target populations : a sample, dataset source 4
27 An Integrated Approach to Clinical Data Entry &Management Using Personal Computers and SAS Software Robert W. Heinemeyer data science, clinical data source 6
28 An Introduction to SAS/QC Software Robert N. Rodriguez The improvement of product quality is a top priority for industry during the 1980's, and many companies are applying statistical quality control methods on an unprecedented large scale. SASiQC software provides a set of tools for a wide variety of statistical quality control applications. These tools include PROC SHEWHART for producing Shewhart control charts, PROC CUSUM for producing cumulative sum control charts, and PROC CAPABILITY for process capability analysis. I ntraduction SASiQC software, a recent addition to Version 5 of the SAS System, provides graphical and statistical tools for improving product quality by analyzing data obtained from the production process. Products with which these methods are applicable include services as well as finished manufactured items and components used in manufacturing. Section 1 of this paper briefly describes the history and role of statistical quality control proc step, quality control, dataset, sample, proc means, sample size, standard deviation, histogram source 11
29 Analyzing Survey Data in the Electric Utility Industry Using Several SAS Procedures Mary Lynn Spada proc step, proc freq, correlation, regression analysis, proc glm, proc reg, sample, predictor variable, proc corr, proc factor, proc univariate, proc genmod source 4
30 Application and Evolution of SAS Software and SAS/FSP Software in a Personnel Environment Michael J. Hons This paper describes the application of SAS software in a personnel division of a 2000 emp 1 oyee energy corporat i on. Base SAS* software was first introduced into the personnel department in 1981 to provide simple ad hoc reports of HAY job eva1uati.on for compensation. Almost immediately, the flexibility and versatility of SAS software allowed it to be used, in conjunction with the payro 11 software package, as a self-contained personnel system to support not only all areas of personnel but also other divisions of the corporation. Explanation is given concerning the personnel system design, the SAS software data sets, and SAS software procedures used. The paper al so examines reports typically produced, and the benefits gained by establishing an independent personnel system using SAS software sas base, proc step source 4
31 Assessing Relationships Among Multivariate Data Points by Transforming Them into 2-D Curves Calvin D. Croy confidence interval, box plot, proc step source 6
32 Automatic Generating of Simple Repetitive SAS Code Marianne Cumming,
H. Ian Whitlock
A technique for generating repetitious SAS code (such as format, label, and rename lists) is presented through three examples of inereas ing complexity. The more experienced macro program mer will recognize the wide applicability of the proc step, macro variable, call symput, proc contents, correlation, proc corr, dataset, macro definition, data step, macro loop source 6
33 Batch Processing and Advanced Topics Using PROC FSCALC Patti McAlister This paper covers using the FSCALC procedure, a feature of SAS/FSP software, in batch mode. I neluded is a guideline of when and how to set up a batch FSCALC job. Also covered is a description of how to set up a spreadsheet to be used for calculations and sending reports. Using the special macro variables associated with some of the screens, such as the FETCH screen, to facilitate working in a batch environment is also discussed. When should you use FSCALC in batch? You should consider using FSCALC .in batch when you have a job that must be done repetitively over small periods of time. For instance, you would probably want to set up batch execution of FSCALC because you need to consolidate several spreadsheets every month. Any program that must be done every few days or even monthly that requires the same action every time is a prime candidate for batch processing. Another consideration is whether what-if analysis needs to be done macro variable, batch processing, call symput, batch job source 6
34 Building Efficient and Easy-to-Use Information Systems or What System Should an Information Center Have? Jimmy A. DeFoor problem solving, macro facility source 6
35 Capturing and Reporting Primos System Usage Data Toby Trott usage data source 12
36 Checking for Autocorrelation in Regression Residuals John C. Brocklebank,
David A. Dickey
regression analysis, proc step, proc calis, proc reg, proc autoreg, time series analysis, correlation, predictor variable, likelihood function, proc arima source 7
37 Choosing Dummy Variables for a General Linear Model - Intelligently Stephan Arndt binary variable, proc genmod source 3
38 Collection and Retrieval of Utility Data with SAS Software and DB2 Thomas A. Calabro The user-friendliness ot SAS FSEDIT and the data manipulation features ot the SAS base product coupled with 082. a re lational database product. are tool s utilized to collect and retrieve data. Features ot the system provide data consistency and control in conjunction with a transparent and powerful data management tool macro variable, sysdate9, data step source 6
39 Combination Programming Blocks and Symbolic Variable Pools Robert H. Levy This article describes some of the design issues raised'in pro gramming batch report writers of 5,000 lines using the SAS* macro facility. The issues include logical program structuring, the relationship of macro code to SAS code, ~nd co ordination of referencing environ ments or symbolic pools with the program structure. Some "rules-of the-thumb" to simplify coding mac roes are suggested proc step, data step, macro variable, macro definition, macro facility, %if-%then-%else source 4
40 Comparing Parameter Estimates Between Linear Models John E. Teberg null hypothesis, f-test, proc reg, regression analysis, degrees of freedom, proc step, estimate, predictor variable, multiple regression source 7
41 COMPUSTAT Annual Bank Data: Accessed Using SAS Software Mary S. Hirsch The Compustat IIR annual bank data file distributed by Standard and Poor's Compustat Services~ Inc. is accessed using SAS software based on the macro SPYR described in SAS/ERS. The user has the option to select the companies, beginning and ending years, and the data .items to be included in the SAS data set. A second macro is outlined to serve as a model to transpose and present appropriate data items in a balance sheet or income statement for mat proc step, proc print source 4
42 Computerized Clinical Data Bank Networks Bruce Guthrie,
Christine L. Wolf
proc step, data validation rules, input statement, character variable source 5
43 Conducting CBT Reviews in an Organizational Setting Laura Yordy A critical part of any instructional development process is the cou rse review, whether it be called formative evaluation, instructional validation, or content and style review. It is particularly important for computer-based training (CST) I in which the final product is usually delivered to one user at a time, out of the developer's sight. 1 n theory I CST reviews encompass thorough evaluation of the instruction by content experts. as well as extensive testing of the course by potential users, both under ideal conditions. This paper will address the task of instituting a practical, yet beneficial, CST review process within the constraints of an organization--how to organize available time and personnel such _that your CBT course receives the best possible validation. The review process used by CST developers at SAS I nstitute will be discussed source 5
44 Creative Uses of PROC GREPLAY Mike Kalt This tutorial presents interesting and unusual uses of PROC GREPLAY that go beyond the examples supplied in the SAS/GRAPH- User's Guide, Version 5 Edition. Examples of the following types of applications will be discussed: Creative template designs Combining multiple graphs Effective and unusual presentation of data Combining text and graphics zooming and rotating with templates Adapting color to different media This is not meant to be an exhaustive summary of the capabilities of PROC GREPLAY, but rather an illustration of a few of its nonstandard uses source 7
45 Creative Uses of Standard Graphics Packages Julie A. LaBarr sample, dataset, standard deviation, bar chart source 6
46 Data Management of a Home Blood Pressure Monitoring Study Using SAS Software Irene Tekawa A research project was undertaken at the Kaiser Permanente Medical Center in Oakland to evaluate the effectiveness of home blood pressure (BP) monitoring in the management of hypertension. Physician-referred hypertensive patients were randomly assigned to either a home BP group or a usual care group. Patients in the home BP group were to record their BP regularly for one year and send in their readings at four-week inter vals. The study required a data management system that would support generation of indi vidualized interval reports for patients in the home BP group. SAS software offered the capabilities of band ling all aspects of the data management needs of the studyw This paper discusses how these needs were met as a SAS-based application that allowed for interactive data entry, file management and report generation, performed by study personnel with no background in programming. The SAS System will be used to perform all statistical analyses on the data from the study batch job, data governance, macro facility, proc step source 6
47 dBASE III to SAS PC DOS Software - A File Management System Robert Landon This presentation describes a corporate file management system which was converted from a manual filing system to a dBASE III menu driven record entry system and a SAS PC DOS statistical reporting system. The existing system was projected to grow rapidly and the requirements were to automate the system allowing for rapid searches through more than 10,000 records as well as provide for statistical reports and graphs for system i nforma ti on. The presenta t i on inc I udes dBASE III to SAS PC DOS conversion descriptions and examples of SAS analysis and reports. Advantages of this system include: 1.) Allows a PC standalone system for having the best of both worlds - relational database software and statistical reporting software. 2. ) Menu dr i ven so the user need not be familiar with SAS PC or dBASE III. 3.) SAS PC and dBASE III can easily handle a large number of records for fast analysis and quick searches proc step, batch processing source 7
48 DESRA-An Experimenter's Assistant Earl R. Westerlund Experiment design is a useful technique that helps researchers and engineers plan experiments that are effi cient and provide valid answers. We have taught experi ment design at ,Eastman Kodak Company for years, but few people actually used it. The computer tools to per form design and analysis were inadequate, hard to use, or nonexistent. DESRA is a menu-driven system, developed at Ko dak to manage the experimentation process from design specification through data collection and analysis. It is based on the SAS(R" system. DESRA is unusual in that it stores important information about experiments in SAS data sets, so that it can guide experimenters through the process. DESRA has some of the charac teristics of an expert system. Topics to be covered in this paper include: Structure of DESRA; Functions performed hy DESRA; Locally written extensions to the SAS system used by DESRA; Features that give DESRA its "elementary intelli gence." dataset, proc step, experimentation, proc glm, proc genmod, regression analysis source 6
49 Developing SAS/AF Software Front-Ends for SYSTEM 2000 DBMS Jim Nelson source 15
50 Development of a Menu-driven System for Software Acceptance Testing Patricia L. Berryman source 2
51 Development of a SAS Based Interactive System Used to Analyze Pharmaceutical Production Data M.W. Allee,
J.M. Sauer
An OS/MVS interactive system combining SAS/AF~, SAS/FSP, and SAS macros has been developed to aid pharmaceutical produc tion data analysis at Eli Lilly and Company. Users with no prior SAS experience can easily enter and/or extract production data and related Information. The core of the system is built around SAsl AF Menu and Program screens. In addi tion, many of the data-entering and system functions requiring user input are presented using SAS/FSEDIT screens. Each screen, whether AF or FSP based, is designed in a similar format to hasten the user's system familiarity. Finally, a majority of the back ground system work is performed using SAS macros. Several developed subroutines and modified SAS Procedures were incorporated to make up the main functions of the system label statement, master data management, sas library, proc step, macro variable, macro definition source 6
52 Development of an Expert System for DBMS Selection David A. Van Rossum final analysis, likelihood function source 6
53 Efficient Use of PROC SUMMARY Suzanne Clark,
Liz Konowal
Analyzing and manipulating large volumes of data can often result in the use of extensive programming as well as CPU time. It is therefore beneficial to not only be familiar with the various SAS PROCs but the extent to which the analyses they execute and the output they generate overlap. Concentrating primarily on summary statistics, an investigation was undertaken to compare the efficiency in terms of CPU time and the similarities with respect to output of using PROe SUMMARY as opposed to multiple other SAS PROes. The results of our investigation demonstrate that by becoming familiar with the -TYPE- variable and the values generated by SUMMARY numerous analyses can be completed efficiently with only one pass through the data eliminating a number of intermediate DATA steps and PROCs as well as reducing both programming and CPU time proc step, proc sort, cpu time, by group processing, proc means, proc univariate source 6
54 Efficient Use of Table Lookup Procedures Howard Levine,
Craig K. Ray
proc format, proc step, lookup, macro variable, set statement, put statement, macro definition source 6
55 Enhancing SAS/GRAPH Procedure Output with the ANNOTATE Facility Charles W. Kelly A powerful feature of the annotate facility is the capacity of using the system of coordinates generated by a graphics procedure to provide custom enhancements to the procedu re output. This paper explores the use of the DATA STEP and the macro facility to add data-dependent, user-defined modifications to graphics output from the GSLlDE, GPLOT, and GMAP p roced u res. General Capabilities of the Annotate Facility SAS/GRAPH software provides a powerful system of procedures for producing business graphics in a production environment. The graphics user can display information stored in a SAS data set by selecting a SAS/GRAPH procedure and providing appropriate statements and options. A fixed range of modifications are possible for each procedure when selected statements and options are used source 7
56 Evolution of a Multi-State Agency. SAS Users Group in Missouri Pamela Haverland data wrangling, macro facility source 3
57 Executive Information Systems Using SAS/AF Software Linda Sampey proc step, sample source 4
58 Facilities for Supporting the SAS System Applications to Zaps Margaret L. Adair sample, error message source 3
59 Financial Forecasting Through SAS Macro Processes Heydar Pourian macro definition, residual, correlation source 6
60 Generalized Information Requirements of Intelligent Decision-Making Systems Paul J. Werbos regression analysis, proc reg source 7
61 Getting More from PROC PRINT William R. MacHose proc step, proc print, proc transpose source 1
62 Helping You Select the Best Method for Training Employees UsingSAS Software Stephen A. Harper,
Keith Hovland
source 4
63 How a Lazy CMS SAS Software User Executes the SAS System Akos Felsovalyi The paper presents the eMS tool of exe cuting SAS by pressing only one key source 2
64 How to Transform Reams of Data Into a Clear Presentation or Mapping Beyond Counties with SAS/GRAPH Software Muriel M. Farrington SAS has historically offered State and County boundary files for thematic mapping with SAS/GRAPH. Many SAS users want to map at finer levels of geography~ and others are not familiar with the benefits of mapping. An extensive set of boundary files are available from commercial sources which cah expand the map analysis capabilities of SAS/GRAPH. An insurer, proc gmap source 4
65 How to Write SAS Procedures for Version 5 Ronald Parker A SAS procedure is a program usually written in a high-level language that performs a specific task. In this paper, we will aid a programmer in writing a SAS procedure for Version 5 by examining the parts of a procedure, explaining the steps involved in writing a procedure, and discussing areas in writing a procedure that are likely to give the programmer problems dataset, proc step, numeric variable, by group processing, missing value, sas log, sas programmer, variable list, macro definition, macro facility source 10
66 How Will SAS Software for the Microcomputer and Organizations Come to Grips with Each Other? Charles F. Hofacker,
Paul Hoffman
proc step, proc iml source 3
67 If It Were a Snake, It Would Have Bit Ya, or 101 Things on the SASware Ballot You Can Already Do Neil H. Howard,
Merry G. Rabb
proc format, proc step, missing value, put statement, do loop, dataset, macro definition source 4
68 Improving Binary Search Techniques Robert Virgile Binary search is an efficient method for locating a specific observation in a large, sorted master file. In a binary search program, each iteration through the DATA STEP (or through a portion of the DATA STEP) eliminates half the remaining master file observations from those that might be the sought after observation. With a master file of 2**n observations, a maximum of n+l iterations are required to locate any particular observation. This paper develops two improvements to binary search techniques applicable when a number of records must be located. The examples locate 200 to 1000 target records out of a SAS data set with 100,000 obserR vations. Sorting the targets before beginning the search makes possible two improvements over a standard binary search. First, since the targets are sorted, the kth target must be positioned in the master file after the k·l target. Therefore it is necessary to search the entire master file for the first target only cpu time, conditional do loop, set statement, credit card, if-then-else, sample source 6
69 Inference from the Incomplete Longitudinal Design: A Collection of SAS Macros James Rochon covariance, likelihood function, covariance structure, time series analysis, maximum likelihood estimation, repeated measures, proc step, missing value, hypothesis testing, sample, residual, macro definition source 6
70 Information Systems at the Soil Conservation Service M. Cassandra Smith Two information systems have been developed at the U.S. Department of Agri culture. Soil~nservation Service (SCS) using base SA~software. The two systems are the Equipment Management Information System (EMIS) and the Real Property Manage- ment Information System (RMIS). The EMIS system stores information about vehicles owned and leased by SCS. This information includes vehicle utilization data, operation data. and maintenance data. The RMIS system contains information about real property owned and leased by SCS. It is a centralized source of the real property holdings of the agency. The information stored in it affords the ability to.track space utilization; identify under-util~zed property; and provide a refer ence for answering inquiries from Congress and others. This paper will discuss the structure of the 'two systems and SAS language tools used in reporting from and updating the systems dataset, transaction data, update statement, master data management, data cleaning source 4
71 Insurance Industry Financial Data-Development Analysis and Production Robert R. Lorentzen put statement, standard deviation source 4
72 Integrating SYSTEM 2000 DBMS and the SAS System in the Information Center Vernon E. Kirchman,
Kirk Paul Lafler
Integrating the diversity of software and databases located on mainframe and personal com puters is a major problem con fronting many companies as they attempt to implement a success ful Information Center (IC). The Ie concept consists of a department which provides educa t i on. techn i ca 1 support." consistent and transparent access to data~ micro to main frame and mainframe to micro links? user computing tools and accessibility to computer systems. The single greatest challenge facing the Ie depends on its ability to provide responsive user support while integrating the diversity of software and databases. This paper ill ustrates a strategy for integrat inq SYSTEM 2000 DBMS and SAS {R) software to assist in the task of managing the company resource, informa tion source 3
73 Interfacing SAS Software with the B34S System Recursive Residual Option: A Brief Look at Theory and an Example Houston H. Stokes The recursive residual technique, developed by Brown-Durbin-Evans (1975) has proved to be a powerful tool to test for dynamic problems in OLS regression models. Code was initially developed to implement these pro cedures in the B34S system in the late 70s. The PROC CB34S allows the B34S system to run under the SAS software system. The use of the recursive residual procedure is illustrated by means of a sample dataset from the SAS/ETS manual. I. Introduction The B34S data analyses program,' developed by Houston H. Stokes, contains a number of statistical procedures, one of which is the recursive residual procedure that implements the equation specification suggestions of Brown Durbin-Evans (1975) and Dufour (1979).2 The sample, regression analysis, cross-sectional data, time series analysis, proc step source 6
74 Introduction to SAS/IML Software, an Interactive Matrix Language Alan Eaton SAS/IML is an interactive matrix language that is both powerful and flexible. The fundamental data object on which all commands operate is a row by column matrix. Therefore, single elementwise operators such as + and j can operate on many data values to produce many results. In addition, there are commands to reduce many values to a single desired value, for example, SUM and SSQ, subscript reduction operators to reduce rows and columns within a matrix, and special matrix operators such as matrix multiplication, transpose, and inverse. You can control the execution of operators and commands using SAS/IML programming statements. SAS/IML subroutines allow you to decompose a large application into modules. There is a rich set of data management commands to transfer data to and from SASdatasets and there is a set of primitive graphics commands to construct graphical displays while you remain in the SAS/IML environment source 8
75 Introduction to SYSTEM 2000 DBMS Barbara Springer SYSTEM 2000 DBMS is a user-oriented data base management system. It provides data management capabilities that serve the entire range of system users: the end user, the application developer, and the data base administrator. SYSTEM 2000 DBMS is controlled via an integrated data dictionary; uses multiple-indexed hierarchical data structures for fast retrieval and updates; allows the definition of complex network structures; features a programming language extension (PLEX) that allows data base access from COBOL, PLll, FORTRAN, and Assembler programs; provides a powerful, easy to-use query/update (QUEST) language; and includes an interactive report writer to accommodate tabular reports. SYSTEM 2000 DBMS currently runs on IBM 370 and compatible machines under OS, VM/CMS, and VSE; the Sperry 1100 series under OS 1100; and the CDC 600 and CYBER series under NOS and NOS/BE data dictionary, proc step source 3
76 Labor Manpower Requirement System in Hierarchical Tables Deborah White The Labor Manpower Requirement System (LMRS) is a tabulated display of descriptive statistics in hierarchical tables. This system utilizes the "PROC TABULATE" procedure, Full Scree,n Product (interactive menu-driven facil ities), and statistical analysis to achieve its end results. The system was developed to provide engineering functional managers and project managers with budget visibility and replanning control. The anticipated benefits of this system are improved planning capability and better manage ment of engineering budgets. The output of LMRS includes a tabulated hierarchical format which compares budgeted manpower with actual expended manpower. The output shows the budgeted labor, the actual labor expended to date, the variance between budget and actuals, and a replan line that can be modified monthly. Labor is expressed as equivalent people (headcount) proc tabulate, proc step source 5
77 Linking Medical and Research Data Bases with TMR and SAS Software Jean A. Dozier,
Lawrence H. Muhlbaier
Patient care data bases and clinical research data bases often share a large portion of data. An automatic transfer of data eliminates the duplicate entry process and increases consistency between the data bases. This paper provides a description of the different components necessary for the transfer between patient care records of TMR and the relational data base records of SAS: structure, selection, and interpretation. A TMR program extracts record components for selected patients and places them in a file for SAS to access. TMR creates a specification file that describes the contents of the data file. A SAS program reads the TMR specification file and generates the SAS program to then read the TMR data and create or update the SAS data base. We describe the SAS programming aspects of the transfer. See Dozier (1985) for details on the TMR aspects. The system is in use at Duke University Medical Center for Cardiology and Cardiac Surgery data bases dataset, clinical data source 4
78 Loading Health Benefits Into a New Claims Processing System Diane E. Brown Blue Cross & Blue Shield of Indiana evolved as a company by product. The products include Blue Cross (hospital). Blue Shield (medical/physician), Major Medical (catastrophic), Comprehensive Major Medical (catastrophic including hospital and medical/physician), Prescription Drug. Dental, and Vision. Because these products evolved at different -times and because each market had different requirements for these products, 13 claims processing systems were developed. These systems are very complex because they must interact in order to pay a single illness or accident. The situation was further complicated by the changing environment. The original systems were continually updated to meet new requirements. A single claims processing system was purchased and adapted to meet our specific needs. This paper will discuss the methodology used for loading account benefit coverages from the old system to the new system sas base, model validation source 6
79 Maintainable SAS Based Systems and the SAS Macro Language: A Catch-22? Peter Kretzman Clearly, the SAS macro language considerably increased the potential power of the SAS pack age. Yet macros provided more than just power. At the same time, they promoted the maintain ability of SAS-based systems by allowing those systems to be much more structured and modular than before. ·Chunking" an application into a set of clearly defined, interrelated macros facilitates later enhancements because any changes are module-specific, and each module can be tested and debugged independently of the system as a whole. Yet anyone who has struggled with writing and debugging macros of even intermediate sophistication can attest to their p~oblematic nature. One experienced SAS software consult ant told me he avoids macros because their maintainability is so difficult. Triple amper sands, quoting functions, and the often confus ing production of SAS code all contribute to making a complex macro virtually impossible to read' if-then-else, macro variable, macro definition, dataset, macro facility source 6
80 Making Information Systems a Strategic Issue Henry B. Edwards source 5
81 Management of Time Series SAS Data Bases William R. MacHose As SAS databases grow in size and impor tance. it is vital to provide some basic data management services. The services examined in this paper include backing up databases. archiving database files. and preparing indexes of database variables. The backup/archival fmlCtions can be performed on any SAS database. The variable index function is designed for time-series files proc step, proc print, proc sort, macro variable, macro definition, sample source 5
82 Managing VM/SP: An Analysis of the CP Nucleus Using SAS Software Stuart D. Guthrie Although SAS has long been popular with end-users and application development staffs, in the past few years more people in the technical support area have discovered that its ability to read and analyze any type of data make it particularly useful for many technical applications. Instead of installing it and forgetting it, we are using it for performance analysis and monitoring, for accounting, and for data conversion. Here is one technical application we have found very helpful in managing a VM installation data transformation, proc sort source 2
83 Maximum Likelihood Estimation for a Mixture of Larval Instars Richard L. Berg Field ~amples of insect larvae represent a mixture of populations, one for each instar in the development of the immature insect. Assuming normal distributions for measurements on the instars, maximum likelihood (ML) estimation procedures as developed by Hasselblad (1966) can be applied to the problem of*describing larval population structure. A SAS program to imple ment the ML approach is described and applied to data for larval moths of the genus Ancylis likelihood function, maximum likelihood estimation, proc freq, normal distribution source 5
84 Measuring Data Variability Fred Gehm proc step, histogram, sample, proc gchart, sample size source 3
85 Mechanized Spare/Repair Parts System Laura Donley The Northrop Corporation, ventura Division Logistics Group provides an organization for maintaining domestic and international provisioning parts list databases. The Mechanized Spare/Repair Parts System is designed to produce a tailored list of spare/repair parts to meet specific international program requirements. CUrrent applications for this system are jet-powered and propeller-driven target drones. The Mechanized Spare/Repair Parts System incorporates coded data elements in MIL-STD 1552/1561 format in order to util ize a system of SAS programs to manipulate the data. Discrete coding of the data enables the user to extract specially tailored part lists to satisfy program requirements based on customer requests. The System incorporates a series of menus that allow the user to select the criteria that will be used to meet specific program requirements. The user maintains part number databases through on-line transactions macro facility, sas base source 4
86 Microcomputers and SYSTEM 2000 DBMS Paul Kent This paper discusses the integration of PC-based applications with larger data bases stored on mainframes. It addresses features already available in the SAS System and SYSTEM 2000 DBMS, as well as future direction of the interface. The functional requirements of a micro-to-host link are discussed, and features of the SAS System that make it useful as a link vehicle are placed in context. The benefits of the SAS end-to-end protocol that transfers both output and data are explored and compared with other approaches. The SAS micro-to-host link supports a variety of communication protocols, with the SAS System, or SYSTEM 2000 DBMS executing on the (IBM, CDC or Sperry) host. The different methods of connecting to these host computers are discussed. Potential applications of the link technology are examined, showing how one can integrate the features of the SAS System on the PC, with traditionally mainframe-based applications source 4
87 Mirror, Mirror on the Wall: A SAS Software Methodology for Plotting Corporate Image Luanne M. Conley regression analysis, health insurance, proc step, predictor variable, response variable source 5
88 Mixed Model Analyses with the SAS System Ramon C. Littell proc mixed, anova, fixed effects, proc genmod, f-test, degrees of freedom, response variable, confidence interval, main effect, proc step, proc glm, p-value, residual source 8
89 New Developments in Alternating Least-Squares SAS Procedures Thomas C. Edds,
Douglas P. Kent,
Warren F. Kuhfeld,
Forrest W. Young
A SASI software development project is currently in progress at the University of North Carolina at Chapel Hill.8 One of the purposes of this project is the development of SAS procedures that perform a variety of descriptive multi variate analyses. Three of these procedures, PROe PRINQUAL (principal components of qualitative data), PROe CORRESP (simple correspondence analysis) and PROe CONJOINT (analysis of variance and regression with a nonlinearly trans£ormed dependent variable) will be described. PROC's CONJOINT and PRINQUAL zit a linear model to nonlinearly trans£ormed variables using an alterna ting least-squares algorithm. PROC CORRESP can be used to summarize the in£ormation in a contingency table. The design and current state o£ development oz these procedures will be discussed proc step, regression analysis source 6
90 New Developments in SAS/AF Software for Course Authoring John C. Boling source 5
91 One Degree of Freedom Test for Transformable Nonadditivity-A Generalized SAS Macro Daniel W. Griffin,
Shiferaw G. Mariam
macro definition, anova, proc glm source 8
92 Performance and Capacity Planning Considerations for the SAS System on Mainframes Daniel J. Squillace proc step, proc sort, cpu time, sas log, &variable, options statement source 5
93 Performance Evaluation of Microcomputers with Emphasis on the IBM PC AT Thomas E. Bell,
Wayne E. Bell
elapsed time, decimal source 6
94 Performing the X1 1ARIMA Seasonal Adjustment John C. Brocklebank,
David A. Dickey
seasonal adjustment, proc calis, time series analysis, proc step, regression analysis, moving average, proc arima, proc autoreg, estimate, seasonality, correlation source 10
95 PERSONYRS: A SAS Procedure for Person Year Analyses Glenn A. Augustine,
Erik J. Bergstralh,
Jon L. Kosanke,
Kenneth P. Offord
calendar year, numeric variable, proc step, dataset, confidence interval, missing value, poisson distribution, proc freq source 6
96 Power Analysis for Linear Models Ralph G. O'Brien sample, power analysis, sample size, main effect, anova, type i error, standard deviation, proc step, data science, f distribution, significance level, proc glm, proc genmod source 8
97 PROC COMPUTAB Macros for Survey Processing Applications Thomas E. Billings The of SAS* in processing surveys <questionnaires) is described. and the limitations of SAS for survey processing applications are discussed. use The first limitation" applies to numeric response questions. PROC UNIVARIATE should be run for th1S type of question. yet the resultant printout can be vol uminous. Potential solutions are discus sed. and the shortcomings of each solution are explained. The recommended solution consists of runn1ng PROC UNIVARIATE with the NOPRINT option (re ducing printout). saving the target statistics in a SAS data set. then using PROC COMPUTAB to print the statistics in a tabular format. Macros are described, which provide a general implementation of this solution. The second limit~tion is th~t PROC FREQ can process only single response quest ions. whereas multiple response quest ions are common in survey r~aearch. The existing solutions to. this limitation ~nvolve substantial labor. Macros are described which solve this problem proc step, proc univariate, dataset, response variable, sample, proc freq, proc means, title statement source 5
98 PROC Ellipse Charles G. Margolin,
Charles E. Shipp
proc step, standard deviation source 1
99 PROC FSLETTER Tutorial David A. Chouiniere proc step, dataset source 3
100 PROC IDPLOT: A New Plotting Procedure with Point Labeling Capabilities Warren F. Kuhfeld PROC IDPLOT is a Version 5, base product, line printer plotting procedure that allows points to be labeled with long point labels. PROC IDPLOT has four plotting methods, three of which can guarantee that no point labels will be hidden. This is accomplished by using varying amounts oX nonmetric rank and metric distance information when computing rOw and column point locations. The RANK method locates each point on a separate line of the plot so long point labels will not be obscured. The MODRANK method also locates each point on a separate line, but the number of lines separating points is a function of the differences between adjacent y coordinates. The GENRANK method computes the row number with a formula that uses a variable weighting of y coordinate and y rank information. The METRIC method produces ordinary scatterplots. PROC IDPLOT is currently documented in wIDPLOT and QPRINT Procedures, Preliminary Documentation" and "P-146 Changes and Enhancements to the Version 5 SAS System w* proc step, dataset source 5
101 PROC RSMCB: A Procedure for Ranking, Selection, and Multiple Comparisons with the Best James C. Aubuchon,
Shanti S. Gupta,
Jason C. Hsu
proc step, sample, confidence interval, treatment effect, confidence level, sample size, proc means source 5
102 PROC TABULATE as a Tool for Categorical Analysis Tamara R. Fischell,
Juliana M. Ma
proc step, proc tabulate, proc means, nominal variable source 5
103 PROC VISUALS: Experimental Software for Animated 3-D Graphics Using the IBM Professional Graphics Device Thomas C. Edds,
Douglas P. Kent,
Warren F. Kuhfeld,
Forrest W. Young
PROC VISUALS is the product OI recent developments in exploratory data analysis and computer graphics technology. The basic Iunction of PROC VISUALS is to display and let you interactively manipulate three dimensional images OI multidimensional data. The sOItware runs on the IBM ProIessional Graphics Device. The host computer is the IBM PC-AT with a Iloating point math chip. The IBM ProIessional Graphics Device supports a wide range OI high-level graphics Iunctions. Such hardware Iunctions take much of the computational load away Irom the host computer, making animation drawing speeds possible. PROC VISUALS' animation runs at 1-3 Irames per second, creating a 3D eIIect, but 10-30 Ira mea would create a much better 3D e££ect. We anticipate that computer graphics technology will advance in the near future to make such animation speeds more affordable proc step, exploratory data analysis source 4
104 Programs for the GMANOVA and Extended GMANOVA Models Vernon M. Chinchilli,
Ronald K. Elswick
null hypothesis, likelihood function, multivariate analysis, anova, manova, proc step, covariance, hypothesis testing, maximum likelihood estimation source 8
105 Progress Towards SAS/OR Software for the Microcomputer Marc-David Cohen odds ratio, bar chart, sensitivity analysis, proc step source 9
106 Project Management Using SAS/OR Software Radhika V. Kulkarni In this tutorial we discuss various aspects of project management and describe how the SAS and SAS/OR software can be used to address some of the problems that arise in this area. The SAS/OR Software contains two procedures, PRoe ePM and PROe GANTT designed specifically for project management. We shall present several examples illustrating features of the two procedures and show how some special situations can be handled fairly easily with a Jew programming steps in the SAS language proc step, proc sort, proc means source 12
107 RATS-The SAS Software Connection Caroline M. Bobik,
Arthur C. Singer
RATS (Rodent Activity and Thermogenesis System) is a completely automated computer controlled data collection system for drug studies. Oxygen consumption, carbon dioxide production, and motor activity in rodents are recorded. Drug-related changes in motor activ ity which affect oxygen consumption are of primary importance and present a complex problem in statistical model building. Data from 10- or 20-day experiments were transmitted by modem via an HP3QOO to an IBM 3033 mainframe. Approximately 30K successive unidentified numbers daily were stored in a fixed-pattern data file; identification of these numbers required modulo arithmetic. The data were formatted into observations on a time basis conditioning them for SAS procedures. An upgrade of RATS, using an HP98695A Coax Interface with appropriate software, now allows the HP9836C computer to emulate an IBM 3278 terminal with direct data transmission to the mainframe at 9600 baud proc step, response variable source 3
108 Refining Scales: Some Considerations When Using Factor Analysis and Guttman Scaling Matthew Schall factor analysis, correlation source 5
109 Repeated Application of a Generalized Logistic Model To Count Data Using PROC MATRIX Linda Williams Pickle dataset, likelihood function, proc step, estimate, maximum likelihood estimation, logistic distribution, predictor variable, covariance, logistic regression source 6
110 Sample Utility Macros Ross Merlin This presentation is a collection of general-purpose MACROs: ANY,NOTANY -- shorthand for multi-value I'IF" statements INDEXBLD -- build an index dataset and index functions (FORMATs) to facilitate direct access of a SAS dataset MAKEFHT -- make a SAS FORMAT from data in a SAS dataset OBS -- ascertain the number of observa-tions in a SAS dataset without counting SEARCH -- search a field for user specified values, display all obs that match TYPE -- determine the type (CHARACTER or NUMERIC) of a SAS variable USAGE -- access SAS Usage Notes VARNAHE -- display variable names and labels VALIDATE -- validate a response and generate a label for %GOTO WP -- reformat text for inclusion in SAS listings ANY and NOlANY are macros that allow for a shorter notation in multi-value "IF I ' statements. In COBOL, one can code: IF (CHANNEL=2 OR 11 OR 13 OR 45) ... but in SAS one must code: IF (CHANNEL=2 OR CHANNEL=ll OR CHANNEL=13 OR CHANNEL=45) dataset, index, macro definition, sample, proc step source 8
111 SAS Data Set Comparison: Overcoming the Limitations of PROC COMPARE Warren Repole Jr. proc compare, proc step, macro conditional, macro definition, macro loop, macro variable source 7
112 SAS Macros to Calculate the Full Set of Coefficients and Predicted Outcome Probabilities for a Polytomous Logit Model John W. Molyneaux,
Erika Mares Stone
The macros presented in this paper use output from PROe MLOGITl to generate (currently only for the polytomous logit model): 1) all pair wise combinations of the effects of explanatory variables on the relative probabilities of all outcomes, and 2) the predicted probabilities of each of the dependent variable outcomes, evalu ated at the means of the explanatory variables, or any user-specified values predictor variable, proc step source 6
113 SAS Program Generator for Statistical Quality Control Chris Potter This paper focuses on the use of an EXEC driven text editing language such as INTH RACT or WYLBUR to generate SAS- programs. This technique has been used to "write" SAS programs to provide a Statistical Quality Control System for the Quality Engineering Department at Syntex Laboratories. The system has been in use for two years to provide reports, plots, and statistical analyses of pharmaceutical data and has given us the ability to periodically review our products and check for trends in the data. The system is called the Quality Engineering Report and Plot Generator and was designed to allow personnel with no programming experience the ability to use SASe to generate summaries, plots, and reports using data from our Quality Assurance database. Although this EXEC has been written using the INTERACT language the basic approach will be useful to any EXEC driven text editing language such as ORVILLE or WYLBUR proc step, quality control, standard deviation, sample source 6
114 SAS Report Writing: Generation of Statistical Tables Using PROC PRINTTO and the DATA NULL_ Step Dorene M. Emmrich Often it is necessary to create tables of a more tailored design than can be achieved through conventional SAS report writing PROC edures such as PROC PRINT and PROC TABULATE. Further, when statistical tables are desired, the problem arises that many statistical PROC edures do not output SAS datasets. Combi ni ng PROC PRINTTO and the DATA_NULL_ step allows creation of SAS statistical datasets and sub sequent production of a tailored statistical report. An example is given of the use of PROC PRINTTO to obtain pairwise comparisons p-values from PROC GLM output. Once a SAS dataset is created, a statistical table is produced using report writing features in the DATA _NULL_ step proc step, proc printto, proc tabulate, proc genmod, dataset, proc glm, clinical trial source 5
115 SAS Software and the IBM Dialog Manager Chris E. Corcoran proc step, crf source 6
116 SAS Software Utilization by the Oklahoma Foundation for Peer Review Alan Davis proc format, sysdate9 source 1
117 SAS Software Windowing Applications on a PC Barbara H. Pendergrass,
Richard Roach
Base SAS software for Personal Computers can be used as a very efficient and flexible data editor. Within a SAS program, the DATA STEP is used to create windows through which tasks such as data entry, data validation, and query are performed. I ntraduction There are many ways within the SAS System to create data entry screens; however, using the WINDOW and DISPLAY statements within base SAS software, data validation and cross-checking are also easily accomplished. Some of the advantages of this technique include the ability to customize the editor to meet specific needs, the availability of efficient table look-up facilities at any time during an edit session, cross-checking of input values to any desired level of detail, and the ability to perform calculations at any time during a SAS session. This technique also offers efficient query for large data files via the binary search sas base, data cleaning source 2
118 SAS/AF Software Tutorial Philip James Busby proc step, macro variable source 5
119 SAS/OR Software - A Decision Support System Prototype for Network Problems Marc-David Cohen proc step, odds ratio, problem solving, output delivery system, network optimization source 10
120 SAS/SHARE Software: Concurrent Update of SAS Data Libraries Jack Wallace SAS/SHARE software allows multiple SAS users concurrent update access to SAS data libraries and members within the data libraries. The development project for this software was initiated in January of 1985. The product, which en hances the SAS System under MVS and CMS, is currently in alpha test status at several installations. This paper gives an overview of the historical needs and the conceptual model and then describes in detail the SAS/SHARE software product. Actually, the product appears differently to different SAS users. The SAS programmer sees the product' as another means of accessing a data library with new flexibility hut with a few new restrictions and concerns as well. The server administrator, who ensures that the product is used properly in the organization, works with the new procedures SERVER and OPERATE provided with the product. The paper concludes with a brief discussion of the implementation details proc step, libname statement, sas log, dataset, proc copy, proc contents, proc sort, set statement, access control, sas programmer source 9
121 Selecting Graphics Hard Copy Devices-What Is Best For Your Site? Roger L Chenoweth source 9
122 Self Serve System Enio Presutto by group processing, data wrangling source 6
123 Simulations to Compare Voting Rules: An Application of SAS Macros and a Fast Numerical Approximator Roger S. Cohen proc nlin, proc step source 7
124 SMF Data Integrity and Archival Jason G. Shane In most IBM installations SMF type data is heavily used in making decisions that may involve the spending or saving of thousands or even millions of dollars for a company. SMF data is also cri~i:al to the success of many other functions, such as chargeback systems and security auditing. These facts alone rank SMF type data right along side other types of corporate data in terms of importance of how the data can be used to effect the profitability of a corporation. Yet. in many installations SMF data is lost or duplicated and poorly archived; in short. SMF data is mismanaged. The author endeavors to illustrate why SMF data should be regarded as an important corporate asset and how it should be managed capacity planning, batch job source 4
125 Solving the IBM Graphics Problem The Saga Continues Bill Manos sas base, cpu time source 3
126 Some SAS Utility Macros Akos Felsovalyi The paper presents several SAS macros from the areas of distribution adjust ment, data transformation, randomization and macro writing. 1. Macro CUTTAIL and per or lower tail Thus the user can 'elude the extreme tribution. CTWTIE cut the up of a distribution. automatically ex values of a dis- 2. Macro LAG is a generalized version of the LAG function. It is able to de termine the lags of a range of the variables, the lags beyond the IOOth lag, the negative lags (leads) and the lags by a BY variable. 3. Macros HANDSEL, SHUFFLE, RANDGRP exe cute certain randomizations of the observations. Macro HANDSEL selects a random subset of the data set so that each observa tion has the same probability of being chosen. Macro SHUFFLE shuffles the observa tions. Macro RANDGRP randomly groups the ob servations into a giyen number of groups of equal size so that each observation has 'the same probability of being put into any group. 4 proc step, missing value, proc rank, macro variable, macro definition source 6
127 SPARES - An Interactive Estimating System Using SAS Software, CLISTs, ISPF, and COBOL Dan Magnuson,
Pamela Suchoski
macro variable, libname statement, macro definition, macro put, proc step, %if-%then-%else, dataset source 7
128 Spline Functions for Logistic Regression Modeling Thomas F. Devlin,
Barbara J. Weeks
Stone's additive spline aodels for regression functions are described. Me discuss their iapleaentation within our Itateaent aaero %"ACRO L6TRE6 for logistic regression aodeling and provide an illustrative application of their use regression analysis, logistic regression, logistic distribution, proc calis, data analyst, response variable, likelihood function, predictor variable source 6
129 Standardized Reporting of Clinical Laboratory Data Kay F. Baxter,
Anita G. Smith,
Kathryn R. Smith
Marion Laboratories, Inc. has developed a system to provide consistency and increase efficiency in the reporting of laboratory data from clinical trials. This system has the capability of tailoring programs to fit different trial data structures and different reporting requirements. The user may select from five report options with some options producing mUltiple layouts. The programs used by this system make effective use of the SAS macro language for both variable name substitution and selection of blocks of code for execution. This increases the efficiency of the system and minimizes the number of changes necessary before execution. The system is menu-driven with all macro variab.les and program options assigned from data provided through user prompts macro facility, input statement source 6
130 Starting to Use Macros-Simple SAS Macro Applications Debra L. Bingham-Barnes Learning to use macros can be an intimidating experience when one is faced with either very technical explanations or trying to decipher code written using the more advanced features of the SAS macro facility. This paper will present simple macro applications that have been used in designing standard programs. A focus will be on appropriate uses, as well as providing the inexperienced macro user with examples of SAS macro code and concepts that are easily understood macro variable, macro facility, proc print, macro definition, %if-%then-%else, proc step, macro loop, clinical trial, if-then-else, macro parameter, %macro parameters source 4
131 Structured Management of the Prototyping, Design, and Development of a SAS Decision Support System John C. Stuart credit card, temporary dataset source 5
132 Structured Programming in a Sperry Fortran PLEX Environment Sandra L. Fitch,
William R. Lee
proc step, order by source 5
133 Subsystems for Production for Version 5 SAS Graphics Eric M. Klusman,
Steven Langford
Using the well·developed structure of ISPF dialogs and the spe .iali.-.ed SAS interface functions provided by IlF, we have devel oped two interactive subsystems for producing SAS Version 5 graphics quickly and efficiently. With these subsystems, novice cumputer users can develop sophisticated graphs, and expert users can synergistically develop graphs per se and generate SAS code for ~ubsequent modification. We conLinue to de\dop new subsystems to incorporate new ideas and new products. Disclaim.er. Tht: opinions and findings discussed below are those of the authors, and do not reflect a position of the Federal Reserve Bank of Chicago or the Federal Reserve System. The need for quick. efficient subsystetns sas log, sas programming, proc step source 8
134 Supporting SAS Software on a PC Michael D. Rhoads infile statement source 6
135 Supporting SAS Software on a PC Network Tom Culver elapsed time, sas base source 2
136 Techniques for Interfacing SAS Software with Other Software John Merline This paper reflects my experiences in two areas: 1) Writing an interface to CINCOM SYSTEMS Data Base Management System, TOTAL. 2) Adding a Write To Operator (WTO) facility to the SAS DATA STEP. These techniques are applicable to interfacing SAS with any vendor's software. Topics covered include addressing SAS variables, using SAS Formats, reducing interface overhead and using SAS macros, along with general notes, references and a contact variable, macro definition, proc step, data step, dataset, decimal, format statement, macro variable, %if-%then-%else source 6
137 Techniques Used for Converting an On-Line Production System from a Prior Release to Version 5.08 of SAS Software Jerry J. Hosking,
Harriet Janes,
Barbara Kennedy,
Sharon Sanders
proc step, options statement, macro definition source 12
138 The Basics of SAS Software: The BY Statement, When You Need It and When You Don't Peter L. Rikard proc step, by group processing, proc sort source 2
139 The Creation of an Information Center to Replace a Paper Distribution Process Margaret F. Moschetto proc step, proc print, put statement source 3
140 The Curriculum Approach: Selecting Training Paths for All Users Jean Ussery sas base, regression analysis source 4
141 The Effect of Centering on the Condition Number of Polynomial Regression Models Robert B. Bendel It has been recognized that centering reduces the condition number of the in cidence matrix in ordinary linear re gression models. In polynomial models, centering can occur first (X_X)2 or last (x2 _X2 ). This paper determines condi tion numbers using simulated incidence matrices and the COLLIN option in SAS PROC REG. The results empirically veri fy that centering first dramatically reduces the condition number whereas centering last provides only a small improvement over no centering at all. The empirical evidence supports the theoretical discussion in Bradley and Srivastava (1979), Marquardt (1980) and Snee (1983) condition index, correlation, regression analysis, polynomial regression, proc reg, proc step source 5
142 The Effective Use of SAS Institute Technical Support David C. Brumitt This paper describes what those tools are and how they are used to provide efficient and effective technical support source 4
143 The Experiences of a Multi-State Agency Users Group in Developing a Series of Workshops on SAS Software Gail S. Olson data wrangling, proc step source 3
144 The Kodak Quality Package James L. Bossert,
Julie A. LaBarr
dataset, sample, inferential statistics, sas output, histogram, response variable, proc step source 6
145 The Macro Language in Foreign Exchange Financial Markets James K. Woods macro facility, proc step, macro definition, call symput, dataset, if-then-else, macro variable source 6
146 The Role of the SAS Macro Facility in Relation to SAS/AF Software Andrew J. L. Cary This paper discusses the role of SAS macros in SAS/AP. It briefly summarizes the ways macros can be used and then describes the role they play in SAS/AF. The relative benefits and disadvantages of a menu-driven application developed using macros alone and developed using Macros with SASjAF are compared in terms of programming effort and real costs macro variable, proc step, macro facility, dataset, macro definition source 6
147 The SAS System as a Tool for the Financial Systems Auditor Ferrell Drewry proc step, dataset, sample, macro definition, proc univariate, proc format, standard deviation, proc tabulate, macro loop, proc print, sample size, macro flow control, %if-%then-%else, proc freq, proc means, histogram source 20
148 The SAS System in Litigation Support Bernard Yancey data science, dataset source 8
149 The SAS System on the Apple Macintosh: What Should the Display Manager Look Like? Alvin M. Best III source 8
150 The Use of the Macro Facility in a System Development Environment Jeffrey Phillips macro facility, call symput, proc step, macro variable source 8
151 The Use of the SAS Macro Facility in the Development of a Clinical Information System Thomas R. Hoffman macro facility, dataset, macro definition, data validation rules source 8
152 The Use of the SAS System in the Development of the Production System for the Consumer Price Index (CPI) James E. Johnstone,
Merry G. Rabb,
Joshua Sharlin
Bureau of Labor Statistics produces the Consumer Price Index (Cpr), a major economic indicator, on a monthly basis. The systems and associated subsystems that support its calculation are being revised, with major components written using SAS{R) software. Experiences in using SAS software on a large system that processes high volume data are discussed. The paper addresses the problems encountered, along with a discussion of how th~ were addressed usinj the SAS System proc step, imputation, data wrangling, dataset, sample, structured data, macro facility, proc means source 5
153 Tukey-Kramer and Dunnett Procedures Based on the LSMEANS Statement John M. Koester,
Kathleen Mellars,
Harji I. Patel
Two SAS@ programs are presented for per forming the Tukey-Kramer and Dunnett multiple comparison procedures on the LSMEANS obtained from PROC GLM. These programs compute test statistics which can then be compared to tabled values of critical points for hypothesis test ing. A program for extracting the necessary variables from the GLM output and creating a SAS data set as input for these procedures is also presented. These procedures can be used for multiple comparisons of the levels of a given factor in a mUlti-way (fixed-effects) model with analysis of variance or covariance. Examples are given proc genmod, proc step, anova, covariance, dataset, proc glm, correlation, proc calis, proc printto, compound symmetry, sample source 6
154 Upgrading Information Center User Applications with New SAS Software Karen C. Patterson A review was made of the evolution of a payroll accounting application from a generalized menu-driven SAS system to PRoe FSCALC to the planned conversion to SAS/AF. A user written Federal and State withholding tax computation was originally designed to use FSEDIT and SAS DATA steps. The application was later migrated to FSCALC when that product became available. The installation of SAS/AF with Version 5 will allow further upgrading of the application operating under that product, with anticipated benefits to the user department libname statement, macro facility source 3
155 Uploading Large Data Files from Micros to Mainframes William M. Taylor MicrocoMputer technology provides excellent capability for bUilding. Modifying, and Maintaining large data files; but it is liaited in Meeting sophisticated statistical analysis and reporting requireaente in a responsive and flexible tiaefraae. For this reason, it becaae necessary to Move several large aicro-based data files to a aainfraae environ.ent. Two approaches were used. The first involved transaitting the records via 1200 baud co.munications lines fro. an IBM PC with a Tal1gras6 35 aeg hard disk to an IBM Mainfraae using PC TALK III or Crosstalk, dBASE II, WYLBUR and SAS 8S the software. This approach had ~any liMitations. A second approach directly coupled the IBM PC with Tallgrass disk to an HP 3000 through the serial port. Using CROSSTALK. the data was transaitted at 4800 baud to the HP hard disk and then converted to a 9-track 1600 bpi tape for transfer to the IBM ~ainfra.e. This approach resulted in the efficient and accurate transfer of the data delimited file, character functions source 3
156 Use and Misuse of PROC GLM Rudolf J. Freund proc glm, anova, proc genmod, proc step, regression analysis source 2
157 Use of Base SAS and SAS/FSP Software in the Development of a Tracking and Scheduling System for In-blouse Training John M. Plunkett This paper reviews the development efforts used to create a Tracking, Scheduling, and Reporting System to assist in the management of in-house training at Virginia Power proc report, sas base source 6
158 Use of SAS Software to Forecast Claims R. Choudary Hanumara,
Michael Salzillo
At present, forecast for four lines of busi ness at Blue Cross/Blue Shield of Rhode Island are generated using the standard regression methodology (SASlGLM). The current methodology is evaluated in an attempt to update and/or validate these methods. In addition, Box-Jenkins univariate ARlMA models are fitted to the four types of claim data sets using SAS/ETS software. Comparisons are made between the forecasting abilities of the regression methods and the ARlMA models. The results of this study show that ARlMA models did improve the forecasting considerably for some types of data. The SAS software has been a valuable tool in forecasting of the four lines of, business to aid in managerial decision making regression analysis, time series analysis, standard deviation, residual, proc genmod, seasonality source 6
159 User Standards: Who Needs Them? Roberta Armstrong data dictionary, sample, data wrangling source 10
160 Using AXIS and LEGEND Statements Jack Bulkley source 4
161 Using PROC COMPARE and PROC CONTENTS to Compare SAS Data Set Values and Characteristics Tim Lehman,
Ann Lehman
proc compare, proc contents, proc step source 9
162 Using PROC NLIN for Time Series Prediction Wayne Fuller The use of indicator variables with NLIN and SYSNLIN for the construction of predictions and the estimation of the variance of predictions is illustrated. Multiperiod predictions and multi variate autoregressive time series are considered time series analysis, proc calis, binary variable, proc nlin, regression analysis, estimate, sample, proc step source 6
163 Using SAS Software in the Design and Analysis of Two-Level Fractional Factorial Experiments Joanne R. Wendelberger main effect, regression analysis, proc step, response variable, proc calis, probt, sample, interaction effect, proc reg, outlier, randomization source 6
164 Using SAS Software to Generate Leave-One-Out Hit Rate Estimates for Group Classification Cathy A. Stawarski,
Joseph M. Wisenbaker
sample, covariance, proc step, regression analysis, macro quoting function, macro definition source 6
165 Using SAS Software to Provide Descriptive Statistics and Customized Report Writing for a Materials Management Function Bruce W. Eagle One of the major responsibilities of Ameritech Services, Inc. 's Information Systems Organiza tion (ISO) is to provide data processing application support and development for the purchasing and material management operations of the five Midwestern Bell Telecommunications Companies. As an Analyst within ISO, my functional area of concern is related to the Material Management And Distribution Systems for the warehouse Service Centers of the five Telecommunications Companies of primary interest here is Item Balance Integrity, or "IBI". The IBI System provides the user group with the information required to track measure ment results and to detect problem areas relating to accurate item balances. My recent SAS production application for IBI involves providing descriptive statistics and tailored report writing for balance adjustment historical data and for specific material stock identified as "attractive". The benefits derived from these developments include the following: 1 proc freq, sample, proc means, histogram source 7
166 Using SAS Software to Retrieve Data from IBM Data Base 2 and IBM SQL/DS Data Bases Robert A. Wilson PRoe GETSQL, a user-written SAS procedure, has been developed to retrieve data from IBM Database 2 and IBM Structured Query Language/Data System (SQLjDS) relational data bases. Users code a SAS PARMCARDS statement followed by a st'andard SQL SELECT statement proc sql, select, dataset, proc step, date variable, sysdate9, variable, proc print, sas log, order by, macro variable, macro definition source 5
167 Using SAS/AF Software to Build and Test End-users' SAS/AF Software Applications Janet C. Lind Janet C. Lind, San Diego Data Processing Corporation proc step, sample, sysdate9, sas library, call symput, date variable source 5
168 Using SAS/FSP Software and the Macro Facility to Create a Generic Report Writer J. Page Miller This paper describes the design and some of the coding concepts of a management information retrieval and reporting 'Toolbox,' focusing on the report generator. The system, which is written in the SAS macro language and SAS/FSP. is an interactive, menu-driven system designed for the non-technical user. Front-end files define valid users, the data libraries to which they have access, and the data sets with; n those 11 brari es. Users choose which file they wish to access; a PROC CONTENTS brings the variable descriptions to the screen, and, in the report generator, the user specifies which variables to include, as wen as 'sorting, subsett 109. co 1 urnn sequent i n9. tota 1; ng and title specifications. The system can be used on any SAS dataset which has variable labels and by any number of users. Its chief purpose is to allow users to access authorized data in ways that are useful to them, without programmer assistance proc step, binary variable, proc contents, macro variable, proc print, dataset, label statement, error message, macro call, macro definition, date variable, macro facility source 6
169 Using SAS/IMS-DL/I Software as a Development Tool in a COBOL-Based IMS-DC System Phil Brennan proc step, sysrc source 6
170 Using the DATASYS Option of PROC GANNO Jade Walker proc step, dataset source 13
171 Using the SAS System to Perform Power Analyses for Log-Linear Models Ralph G. O'Brien sample, sample size, type i error, power analysis, significance level, likelihood function, proc freq, proc step, data science, monte carlo source 7
172 Using the SYSTEM 2000 Query Language Sue Trueblood Rakes The basic SYSTEM 2000 software product provides solutions for the spectrum of Information Center needs. It features an integrated data dictionary, on-line query/update, report generator, relational data base access, and programming language interfaces. Integrated Data Dictionary The IDD (Integrated Data Dictionary) handles data base information and processes that are integral to data base management functions. The dictionary is at the core of SYSTEM 2000 DBMS and handles definition, communication, and control functions for SYSTEM 2000 data bases. All access to data bases through user views is authorized by dictionary security information. The dictionary can also store queries defined by the programmer or data base administrator for subsequent recall. English-like Language (QUEST) The SYSTEM 2000 query/update (QUEST) language is especially useful for those Who need ad hoc access to the data base and for applications developers Who need data base testing and proto typing tools proc step, data dictionary source 4
173 Utilizing Macro XMEDAGE to Obtain an Interpolated Median Age Frances N. Bari proc step, proc freq, cumulative frequency, proc univariate, proc print, proc delete, histogram source 6
174 Variable Selection and Case Analysis in Regression Gerald R. Hobbs Developments in the area of regression analysis over the last fifteen years have been qUite remarkable. In this paper we review some of those developments as they are reflected in PROC REG~ In the first section some of the relevent literature is reviewed and notation is fixed. In Section II some examples are provided to demonstrate the inadequacy of standard summaries such as R-sqare. In the third and fourth sections certain influence diagnostics are reviewed. In Section V collinearity measures are defined and explained. In Section VI partial regression leverage plots are exhibited and discussed. In the seventh section some comments on model building and vari8ble selection are given regression analysis, proc step, proc reg, condition index, feature selection, outlier, predictor variable source 6
175 Verifying Assumptions of the Cox Proportional Hazards Model Frank E. Harrell Jr.,
Kerry L. Lee
hazard ratio, proportional hazards assumption, predictor variable, proc phreg, regression analysis, time variable, time-dependent covariate, proc step, hazard function source 6
176 Visual Exploratory Data Analysis: PROC VISUALS, A User-Written Experimental SAS Procedure Thomas C. Edds,
Douglas P. Kent,
Warren F. Kuhfeld,
Forrest W. Young
proc step, run, exploratory data analysis, data science source 6
177 Visual Information Systems C. David Hardison sas model manager, structured data source 8
178 Weighted Ridge Estimation in a Collective Bargaining Context Teresa Ghilarducci,
Lawrence C. Marsh
The purpose of this paper is both substantive and methOlogical. The substantive regression analysis, predictor variable, ridge regression, proc step, proc reg, response variable, proc princomp, correlation, adjusted r-squared, residual source 6
179 What SAS Software Does and Doesn't Do: Things Your Mother Never Told You Calvin D. Croy missing value, proc step, character variable, proc reg, character functions, decimal, proc freq source 4
180 What's New? SAS, Institute Training in 1986 Herbert J. Kirk sas log, multivariate analysis, quality control, dataset, regression analysis source 5
181 Writing Custom Graphics Device Drivers Woody Middleton The purpose of this tutorial is to present a source 4

Back to Conf go 1987 go 1985

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.