NESUG 1992 Papers - Index

90 papers. Source: NESUG (Northeast SAS Users Group) conference proceedings.

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	"Zooming In" on SAS/GRAPH Plots Using Proc GREPLAY Templates	Earl R. Westerlund			2
2	%WRAP Macro to Output Text During Report Writing	Robert Musterer	Often a desired report layout does not allow for sufficient space to print out a long text string. The %WRAP macro was written to accommodate this. This macro wraps text within the confines of a defined width. Whenever pOSSible, a clean break point Is used to go to the next line, and all wrapped lines are indented two spaces. Three required parameters are: variable name, starting output column,and output width. Remaining parameters are all optional and Include: name of variable for current line setting, additional variables to concatenate with required variable, formats for all variables, break point delimiters, variable name for end of file flag, and justification (overrides wrapping - cannot Justify and wrap same text). Return of pointer control is handled by two variables, one Indicates the starting or return line and the other Indicates the last or next line	data step, pointer control	2
3	A Few FORMCHAR= Option Sets for Different Printers	Earl R. Westerlund		proc freq, proc step	2
4	A Powerful Double-key Entry/Verification System in the SAS System for Clinical Trials Data	Barry R. Cohen	The SAS System's ability to support data capture now rivals the best data capture tools on the market, particularly because of version 6 with Screen Control Language (SCL). Important improvements over version 5 are discussed. Three approaches to double-key entry/verification are described. A powerful double-key data entry/verification system developed using the SAS System version 6.06 is. presented. The system has many advanced features desired by pharmaceutical com panies for data verification during the case report form (CRF) data capture process. Significant improvements in data entry staff time and in disk storage requirements compared with use of version 5 SAS-based implementations are discussed. Field and record nags used in the system to track and control the verification process are discussed, including their expansion to add an automated data validation and query tracking component to the system	clinical data, data cleaning	8
5	A SAS Program for Determing Distribution-Free Confidence Intervals for Medians	Willard Carl Losinger	A SAS program for determining confidence intervals for population medians from a simple ran dom sample (without replacement) from the popula tion is presented. The population size is assumed to be known. The background of the problem is discussed. An application of the PROBHYPR func tion is revealed	sample, confidence interval, probhypr, sample size	4
6	A Tutorial on the SAS Macro Language	John J. Cohen		macro facility, macro variable, macro definition	6
7	Addressing a Problem: A Functional Approach	Alan Dickson		sas function, max	2
8	An Application of the SAS ANOVA/DUNCAN Procedure in Quality Control	Edward Daniel		proc step, anova	4
9	An In-Depth Look at the PHREG Procedures	Peter P. Gaccione		proc phreg, proc step, regression analysis, likelihood function, missing value, predictor variable, maximum likelihood estimation, null hypothesis, response variable, estimate, time variable, covariance	9
10	An Interactive System for the Analysis of Analgesic Trials	Tracey Millander, Ronald Fitzmartin	Single-dose analgesic trials provide an excellent model for a SAS/ AF review, analysis and display application. This application uti1izing SCL provides the statistician with a comprehensive menu-driven system. The system will allow the user to review data for aberrant or outlying values and subsequently select either parametric or non parametric statistical techniques as well as the Capability of generating standardized report-ready tables and graphs. Statisticians can choose a single protocol or pool data across protocols. Once the data is defined a series of menus will be presented to the user. At that point, the use can choose from various options, including: data review, statistical analysis, report and listing generation. Each option contains sub-menus which provide the user with the capability of customizing the reports to their needs	proc sql, conditional do loop	7
11	Automatic Update of Date-Related Titles and Labels for Programs Executed on a Monthly Basis	Helen-Jean Talbott	Programs generating monthly reports usually require monthly modification of date-related titles, labels, and data selection statements. For efficiency and accuracy, automate this process using the SAS macro language and automatic macro variables. While it is a simple exercise to	macro variable, if-then-else, sysdate9, sample	4
12	Blind Dates and Other Lapses of Reason; Handling Dates in SAS	Alan Dickson		proc print, proc step	7
13	Building Data Driven Applications Using the SAS System: Selected Techniques	David S. Septoff	ThiS tutorial describes a system architecture by which an application can be maintained and enhanced through changes to data and parameter files. An application designed this way allows for more flexibility and lower maintenance than one in which code is written to perform specific functions. The generalized COde in a data-driven system performs under the direction of parameters. allowing any changes to be implemented by altering values in parameter files instead of changing the source code. Examples indude such cases as adding new reports changing or reordering menu items * controlling user access and security. Sample programs that make use of SASJAF" and SASIFSP" soft ware using Screen Control Language(SCl). the `SQL` procedure. and the SAS macro facility are presented and described in detail. Because the data-driven approach can be adapted to a wide variety of data-processing taskS involving varying degrees of complexity	sample, proc step, proc sql, proc format, macro loop, macro variable, macro definition, macro facility	7
14	Counting Observations in a PROC FSEDIT Subset	John P. Elrod		proc step, conditional do loop	2
15	Creating an Animated Progress Bar	Rick Aster			1
16	Creating Character Collating Sequences Using the Translate Function	Gary L. Katsanis		translate, proc step	2
17	Creating Numberic Collating Sequences Using the NOBS Data Set Option	Gary L. Katsanis		missing value, numeric variable	2
18	Creating Organizational Charts with SAS and XEDIT	Robert Lillich		sas base, sample	4
19	Creating Range Variables & Range Labels for PROC RANK Quantiles	Rhena Seidman		proc rank, proc step	1
20	Customizing PMENUs for a SAS/AF Application	Michael Bretz	Every window in the SAS windowing environment has a predefined set of commands that are recognized by that window. The SAS System provides several	sas output, proc step	4
21	Data/Variables Reduction by Principal Componets, Battery Reduction and Variable Clustering	Joseph Massoro, Zhini Zhang		cluster analysis, correlation, proc step, proc princomp, macro loop, outlier, macro call, proc varclus, macro definition, missing value	11
22	Developing Applications for Enterprise Information Delivery with SAS/EIS Software	Barbara H. Pendergrass		dataset, flat file	3
23	Excellent Maps Using SAS/Graph - The Latest Tools and Techniques	Jay Jacob Wind, Bernard Bauum		proc step, proc gmap	5
24	Getting to Know Your Data Using SAS	Felicia Borglum	Before you begin any data analysis, you need to know the overall structure, content, and COntext of the data. At a minimum, this requires an in-depth look at variable definitions and ranges of values, an understanding of the underlying probability density functions, and a strategy to handle missing values. Basic simple descriptive statistics can display data in an easy to UJlderstand manner. This paper is intended for those with a minimal background in statistics with a desire to "get their hands dirty" using SAS procedures to perform exploratory data analysis	proc step, correlation, proc freq, proc means, data science, anova, pearson correlation, proc corr, proc univariate, standard deviation, outlier, central tendency	7
25	Graphic Reporting for '1 to 5' Reponses	Donald T. Gantz	Graphics are usually the most effective mode for reporting. When the graphic presents a pattern which corroborates experience, the desired information Is almost instantly conveyed to an audience. SA$' provides the capability to produce graphics for free via PRoes as well as with effort via report writing capabilities and `SAS/GRAP`~. This paper presents examples of the effective use of each of these tools. Many surveys elicit responses using a 1 (Strongly Agree) to 5 (Strongly Disagree) scale. Social scientists generally refer to this as a Ukert scale. This paper discusses strategies for reporting 1 to 5 data and provides examples of graphic reporting styles. The various graphics are created using PROe TABULATE, SAS report writing capabilities, and `SAS/GRAPH`. Often the population being surveyed is split on the survey items. This situation forces the adoption of a reporting philosophy which either suppresses or sharpens the focus on dichotomies	proc step	6
26	Have Your Cake and Eat It, Too: A Macro for Left-, Center-, and Right-Aligned Titles	Jim Hepner	The SAS TITLE statement allows centered or left justified text to be printed conveniently, according to the OPTIONS CENTER / NOCENTER. Many installations require standard information to be printed in the heading of each report that would compete with the descriptive titles. This requirement may be the sole reason for using a	title statement, macro variable	7
27	Helful Hints Using the Diplay Manager with SAS PC	Kimberly A. Mitchell	using the Display Manager in SAS PC can be challenging for novice users. In addition to learning proper coding syntax, the user must also be aware of program editor and line commands. The purpose of this paper is to explain various "editing" commands that will make life much easier when using the Display Manager	catalog, title statement	5
28	How to "RETAIN" Your Sanity: Some Annotated Examples	Ronald P. Cody, Ray Pass		retain, lag function, sum	8
29	Intere-Platform SAS Computing Without SAS/CONNECT	Jack N. Shoemaker	In a fully-integrated, totally-interoperable computing environment, a distributed data manager decides where to process instructions and where to store data. Many of us do not use SAS in this type of environment. so we must make these choices every day if SAS is available on more than one platform. In these environments, SAS code and datasets are transported across platforms using some protocol like TCPIIP. To effectively manage this type of data system, it helps to have one set of SAS code which operates unaltered across these platforms. This paper discusses the programming techniques and procedures we use at Real Decisions to accomplish this goal. The paper discusses an MS-DOS to VMS environment explicitly; however, the underlying concepts apply to all types of inter platform SAS computing. At Real Decisions, we operate functionally parallel data systems on our MS-DOS and VMS platforms primarily to ensure that we have constant access to our proprietary database	libname statement, sas log, macro catalog, macro definition, batch processing, macro call, proc step, proc sql	6
30	Interfacing SAS with Batch Code, ANSI.SYS, and Assembly Language Routines	Jimmy Thomas Efird		sysrc, macro variable, macro definition, %if-%then-%else, proc step	9
31	Introduction to Release 6.08 SAS/INSIGHT and SAS/LAB Software	Mark Brown	Recent trends in data analysis techniques are now available to SAS software users with `SAS/LA8` and SASIINSIGHT software, two key components of a data analysis strategy that are part of the SAS System for Information Defivery. `SAS/LAB` software is a data anaiy sis advisor for users without an extensive statistical backgrOUnd. As an analysis proceeds. SASILAB software offers explanations of the results and suggestions for further analysis. SASlINSIGHT soft ware is a graphical data analysis too that offers interactive statistical graphics combined with traditional statistical techniques. This paper provides an intrOduction to SASlLA8 and SASiINSIGHT software	scatter plot, regression analysis, box plot, response variable, histogram, data science, proc glm, by group processing	6
32	Liberating Data Imprisoned in a VSAM Gulag	George P. Sharrard	VSAM files fill a well defined and well under stood niche in the data processing world. VSAM files are the place all important corporate data is sent, never to be seen again! The dreaded 'data police' will see to it that every bit of data your marketing, advertising and strate gic planning department could ever want is - euphemistically speaking - saved. Should you ever ask for some of it back your name will be entered into a file (generally called "the systems enhancement request list') and you will be monitored in the future. Repeated requests to get your data back will only produce blank stares and reference to some 'COPYUB" some where or, worse yet, to a particular CICS screen. Somewhere along the way you will be interro gated as to why the hundreds of standard reports the current system provides will not meet your needs	conditional do loop, infile statement	6
33	Living in Two Worlds: Supporting SAS on CMS and MVS	David M. Clayton		filename statement, proc step	6
34	Manipulating Large Highway and Crash Datasets	Elizabeth G. Hamilton, Carolyn Williams	Large data file manipulation using PC SAS under DOS can appear to be impossible. However, using various techniques, many large file manipulations can be successful. Some of the techniques to be discussed include restricting size of variables with explicit length, limiting variables for a particular analysis with KEEP or DROP, pre-processing with `PROC SUMMARY` before `PROC FREQ` or `PROC TABULATE`, using S,:!,OP effectively while testing, using `PROC DATASETS` to delete intermediate work datasets, using BY option effectively, using `PROC SORT` only when necessary, and knowing when to use a tag sort. This paper will detail these techniques and their advantages and how the University of North Carolina Highway Safety Research Center uses them in processing accident, vehicle, roadway sections and curve data	proc step, proc sort, sample, data step, numeric variable, proc contents, proc print, dataset, sample size, proc freq	6
35	Mapping With SAS/GRAPH	Christina Herman		proc freq, proc step	2
36	Methods to Display a Y*X=Z/OVERLAY Picture	Jessica Chan, Julie A. Smith		proc greplay, proc step, proc gplot, design effect, proc calis	5
37	More Complex Data Structures in SAS Macro: Modeling Arrays of Records	Irene Mendelson		macro variable, dataset, macro definition, sample, call symput, standard deviation, macro loop	6
38	More on Business Forecasting With SAS	Jeffrey Jarrett		time series analysis, proc step, mse, residual, regression analysis, sample, proc print, proc reg, correlation	5
39	Moving SAS Transport Files Across Different Hardware Platforms - An Advanced Tutorial	Tamara R. Fischell	The availability of numerous hardware platforms due to the growing affordability of computer equip ment and the essential need to use the most efficient tool, has propagated a multi-hardware architecture in the workplace. Not only are programmers forced to program on many systems in-house, but they must also port data to clients, who mayor may not have compatible systems. Moving information across different platforms, consequently, becomes key to ensuring interconnec tivity. `SAS/CONNECT` is one way to move SAS datasets, but when versions 6.06 (and higher) replace lower SAS versions, CONNECT must be licensed to use PROCs UPLOAD/DOWNLOAD. Transport files, another way to move datasets, will then rival CONNECT; not only because they will be more eco nomical, but also because they are now the only way to move SAS data across PC Local Area Networks (LANs). 1 Presently, there exists little integrated documenta tion on the total process of creating transport files	proc step, dataset, proc copy, proc cport, proc contents, sas library, select, sas syntax	8
40	New Technology - Transforming a Mainframe System to the PC Using SAS/AF Software	Beth A. Schlaline, Henry F. DeLong Jr., Valerie J. Martin	The PC has become an almost indispensable tool in the workplace today. It has only been recently, however, that PCs have become large and/or powerful enough to take over processing tasks previously slated for the less convenient mainframe environments. This paper will outline the steps necessary to successfully convert a mainframe processing system to a PC environment capable of handling data from a variety of sources including ASCII, EBCDIC, dBASE, and Lotus 1-2-3~. Certain questions need to be answered whenever changes are made to an existing production system. Will the changes save valuable resources? Will the changes enhance the reliability of the data? How will the user adapt to the changes? These questions become even more important since our available technology is changing so rapidly. Examples of converted code will be given as well as suggestions for integrating the existing procedures into a menu driven system using SASI ~	proc step, data wrangling, proc sort, proc univariate, cpu time	6
41	Obtaining P-Values for Clinical Research Efficacy Reports	Denis Michel		proc step, proc genmod, character variable, proc means, proc glm, sample, proc printto, macro variable, %if-%then-%else	6
42	Principles of Logistic Regression in Radiation Oncology	J. Efird, F. Pardo, P. Okunieff, D. Shoenfeld, H. Aronen		logistic distribution, logistic regression, sample, regression analysis, odds ratio, covariance, likelihood function, predictor variable, roc curve	10
43	PROC FORMAT	Jack N. Shoemaker	Although SAS stores and processes data intemally as either characters or numbers, you can control the external view of the data using explicit formats. SAS provides a generous supply of general	proc format, proc step, user-defined format, put statement, catalog, numeric variable, char., options statement, format statement, proc freq, insurance claims, if-then-else	6
44	PROC REPORT: An Introduction to the Batch Language	Ray Pass		proc report, proc step, proc print, sample, proc means, class variable	10
45	PROC SUMMARY: Enhancing Output with _TYPE_, Formats and Data Steps	August V. Treff	`PROC SUMMARY` is used to compute descriptive statistics on numeric variables. These statistics can be calculated for subgroups through a CLASS or a BY statement. This paper explores features of the `SUMMARY` procedure, emphasizing ways that printed output may be enhanced. The `_TYPE_` variable is explained and its usefulness in labeling subgroup statistics is discussed. Methods of reformating raw `PROC SUMMARY` output are explored. Using the NWAY feature to achieve storage efficiency is highlighted. The use of the RETAIN statement in a subsequent `DATA STEP` to pass divisors to later observations is explained. The paper also examines using binary values for a variable to compute N, rates, and proportions. :INTRODtJCT:ION The task is to calculate attendance rates by school and grade. Each record in your data set contains a student identification number, record number, school, grade, section, days of absence (ABS), and days on roll (DOR)	proc step, proc means, class variable, data step, missing value	6
46	Project ad Budget Tracking System	Aiman M. Zeid		dataset, macro definition	6
47	Reading Several One-Digit Variables from a Single Field	Adeline J. Wilcox		if-then-else, mod	2
48	Reducing I/O Operations Using PROC TRANSPOSE	Susan Repole		proc transpose, proc step	2
49	Report Writing on a Budget: Using PERL	Hallett German		filename statement, put statement	5
50	Restructuring Data Sets Using Arrays of the TRANSPOSE Procedure	Paula B. Podolnick		proc transpose, do loop, array, variable list, proc step, sample, by group processing, proc format	6
51	SAS Applications Programming with DB2/SQL	David J. Adamson		dataset, proc step, proc sql, variable, batch processing, select, relational database	6
52	SAS Macro Language Features for Application Development	Earl R. Westerlund	The SAS macro language has many uses. One use is 10 facilitate development of applications and systems. This talk will discuss some features of the SAS macro lan guage that are useful 10 application developers. Topics 10 be addressed include: Application development features such as windows, statement style macros, and the autocall facility The bows, wbys and whens of macro quoting * Options and statements that aid in macro debugging 1bis talk assumes a basic knowledge of SAS macros and macro variables	macro facility, macro variable, macro definition, dataset, proc step, macro quoting function, call execute, &variable, variable, options statement, %if-%then-%else	5
53	SAS Macro Library: An Easy Way to Increas the Productivity and Improve the Quality of the SAS Programming	Lu Xu		macro definition, run, macro variable, quality assurance, proc print, proc step, %if-%then-%else	5
54	SAS Macros in Biostatistics: Creating Life Tables for the National Longitudinal Mortality Study	Julia L. Bienias		life table, cpu time, proc step	4
55	SAS Problem-Solving Looks East	Hallett German		sample, run	4
56	SAS Processing Efficiency	Carol Kelejian		proc step, output delivery system	8
57	SAS Screen Control Language: A Gentle Introduction	Jean Hardy	SAS users that become acquainted with SAS Screen Control Language are often discouraged. What appears as a formidable task, namely learning this new language and its intricacies, can be made easier by concentrating on the fundamental statements and features. This paper is a tutorial to the Screen Control Language. We don't like to teach SCL in the context of SASIAF, intimidating by itself. We prefer to see it from within SASIFSP, disregarding details about `PROC FSEDIT`. Topics covered include the use of labels, field statements and functions, error trapping, use of dataset and observa tion functions, and useful programming and debugging tips. This paper is aimed toward intermediate level SAS users, new or novice in their knowledge of SCL. Those that are discouraged, disenchanted or skeptical about SCL are especially welcomed	dataset, data cleaning, character variable, sysrc, return, proc step	6
58	SAS System Alternatives	SherriJoyce King		proc step, sas base, regression analysis, correlation, proc means, proc freq, proc sql	7
59	SAS System Supervison - A Version 6 Update	Merry G. Rabb, Donald J. Henderson, Jeffrey Polzin	This tutorial updates a talk given at previous SUGls that discussed the functions of the SAS' System supervlsorduringthe compilation and execution of a SAS `DATA STEP` program. Under Version 6 of the SAS System, tha SAS System supervisor provides interlace ser vices at a higher level than before, and its primary activity in this context is to determine whether a DATA or `PROC STEP` is being invoked. Once invoked, the `DATA STEP` controls its own environ ment during both compile and execution phases. This tutorial pres ents a logical model describing both the compile and executlon time actions of the `DATA STEP` processor	by group processing, dataset, set statement, merge statement, update statement, keep statement, missing value, where statement, sample, drop statement, output, data standard, sas programmer, proc step, index	8
60	Settling Up Batch Procedures to Edit and Update Survey Research Databases with Large Numbers of Variables	John A. Wenston		dataset, proc step, txt, label statement, do over	6
61	Simplified Selecting: A Comparison of SCL Selection List Techniques	Frank C. DiIorio		catalog entry, dataset, if-then-else	7
62	Simplifying Report Generation Using Data Step Reporting	Prabhakar Jain	At Wyman-Gordon Company, the SAS system is used to produce a variety of reports. Generally, large amounts of information are summarized into an easily understood report format. Since management response is frequently spurred by these reports, they become an effective tool for conveying information. However, as a result of this response, the need for information to be presented in an expanded format beyond what may be possible with a single SAS procedure, may arise. Using `DATA STEP` reporting, this need may be accommodated efficiently. To augment current information, SAS functions such as REPEAT and INTCK are utilized within the `DATA STEP` to generate a single report. This	proc step, data step, proc print	6
63	Sources of SAS Information in the MVS Environment	Michael A. Raithel		cpu time, sas library, options statement, batch job, dataset, proc contents, elapsed time, sas programmer, proc step, proc options	10
64	Starting Out with SAS/GRAPH from the Scientist's Perspective	Irene Mendelson	This paper will give a quick introduction to `SAS/GRAPH` with an emphasis on preparing graphics for a scientific presentation. This is illustrated using three basic graphic types of particular interest to scientists: an introductory page of text, a bar chart, and an X-Y plot or line graph. All of these examples use the strategy of starting out simple using all of the defaults and then enhancing this ugly graph with several key options. The paper concludes with a short discussion of how to produce hardcopy output on several popular output devices and has been updated with some useful items new with SAS 6.06 and 6.07	bar chart, title statement, proc step, proc gchart, proc gplot	6
65	The Determination of Causal Factors Related to Fatigue Life and Multiple Site Damage in Aircraft Structures	Thomas Doerfler	The U.S. commercial airline fleet includes a high proportion of aging aircraft. Several cases of multiple site fatigue damage have been reported, including the 1988 Aloha Airlines accident. To determine the influence of fuselage design factors on fatigue life, a fractional factorial plan was used in laboratory testing of various panel configurations. Since not all panels were tested to failure, it was necessary to incorporate censored observations in the statistical analysis of a designed experiment	main effect, response variable	7
66	The Full Power of Screen Control Language in Your Interactive Application	Daryl R. Hoffman		sample, audit trail	5
67	The Laboratory Review Systems: A SAS-based Graphical and Statistical Tool Developed for a CANDA Submission	Russell R. Holmes, David A. Bright	The Laboratory Review System is a user-friendly graphical and statistical tool developed primarily for the review of laboratory data. This SAS-based information system is a part of a much larger system that is presented to the Food and Drug Administration in the form of a Computer-Assisted New Drug Application (CANDA) submission. The Laboratory Review System utilizes a wide variety of innovative uses ofSAS Institute software products. The primary strengths of the system are the custom graphical representation of laboratory data generated from clinical trials, the identification and "drill-down" mechanisms for patient outlier information, and the ability to perform ad-hoc descriptive statistics across many clinical variables. The major graphical component of the Laboratory Review System is a custom, data-driven algorithm which produces symmetrical scatter plots of patients pretreatment (baseline) values versus posttreatment laboratory values	time series analysis, laboratory data, proc means, proc calis, concomitant medications, series plot, outlier	6
68	The SAS System Under Windows 3.0 and OS/2.0	Wanda Thomas	Microsoft WINDOWS 3.0 and OS/2 2.0 offer alternatives to running the SAS system on the PC platform. Microsoft WINDOWS, a DOS-based environment, features multitasking, virtual memory capabBities, and other enhancements to conventional DOS processing. OS/2 2.0, another operating system, can process DOS, WINDOWS, and OS/2 applications. OS/2 also offers some major technological breakthroughs for PC-based processing including 32-bit addressing and a flat memory model that can provide users with more power and flexibility than what is available under DOS. The SAS Support Staff conducted benchmarks on Base SAS software that U1ustrate SAS performance under these environments	proc step, proc means, sas base, proc sort, where statement	3
69	The Statistical Provider Utilixation Review System (SPURS): A SAS Based System for Health Care Provider Profiling	Drew Thraen, Lawrence Kane, Peter An	'lhree responsibilities of the managed care division of Blue Cross Blue Shield of New Jersey (BCBSNJ), the state's largest health insurer, are to ensure that BCBSNJ' I s subscribers are receiving quality care, not being subjected to arr:/ medically unnecessary procedures, an:i not being victllnized by any unfair billing practices. Identifying aberrant health care providers is thus extremely llIlportant. Although outside referrals are an llIlportant catpJnet'lt in this effort, the utilization review staff would be ImlCh less effective if this was its only source of infonnation. Using its cla:il!ls database, statistics, an:i SAS software, BC8SNJ was able to develop SRJRS, the statistical Provider Utilization Review System, an effective tool for identifying potentially aberrant health care providers	outlier, sas base	5
70	The Virtues of Variable Validation	Kathryn Acciari		proc print, proc step	2
71	Three Methods for Creating One Observation from Multiple Observations	Adeline J. Wilcox		proc step, proc transpose, proc print	2
72	Use of a Centralized Data Dictionary in Designing an Occupational Health Information System	Anne Stocum		data cleaning, data dictionary, data validation rules, dataset, proc step	6
73	Use of Code Generation in a Standard Edit Check Facility	Robert Musterer	Quality assurance of clinical trial data bases Includes the specification, coding, running, and tracking of numerous edit checks. To facilitate this process, a system was created to allow users to easily enter edit specifications, generate SAS code, run edits against the data base, and maintain a log of all data questions. This system Is based on the data base's data dictionary and requires only minimal SAS knowledge on the part of the users. Users enter edit specifications which are converted Into SAS code by a code generator. Specifications may use constants, existing variables, or any valid SAS expression; and may Include the following checks: required field, minimum values, maximum values, expected values, subsetting criteria, and format look ups. The code generation program reads in the specifications and data dictionary to create appropriate SAS code for running the edits and updating the log of data questions	data validation rules, variable list, data dictionary, numeric functions, clinical data, concomitant medications	4
74	Use of SAS/SQL and LATEX to Create Automatiically Regenerating Statistical Reports	David Schoenfield, Felicia Borglum	David A. Schoenfeld Massachusetts General Hospital, Fruit Street Boston, Massachusetts 02114 * August 13, 1992	proc sql, select, dataset, proc step	14
75	Useful Complexity: An Introduction to Multi-Platform Development in SAS	Paul Dalberth, Frank C. DiIorio		macro variable, macro facility, &variable, macro loop, macro definition, %if-%then-%else, proc step, proc sql, proc sort	6
76	Using Annotate Datasets to Enhance Contour Graphic Output	Shi-Tao Yeh		macro definition, macro loop	7
77	Using Macros to Create Parameter Driven Procedures that Summarize and Present Statistical Output in Tabular form	John Wenston, Ralph D'Agostino Jr., Kimbery Dukes		proc step, logistic distribution, proc print, regression analysis, predictor variable, proc logistic, proc calis, macro loop, response variable, odds ratio, proc printto, %if-%then-%else, macro variable, macro definition	6
78	Using SAS ADX Menu System for Continuous Quality Improvement	Melissa A. Durfee	Utilizing the SAS ADX menu system, process optimization through identification of significant variables and examination of sources of variation is r;ea!ized. This system, included with `SAS/QC` M software, facilitates design and analysis of experiments by providing a full-screen front end. For the novice user and experimenter, prompting menus are provided which guide one through building the design, printing data collection forms, and performing standard statistical analyses. However, designs may be customized by turning off the prompts, yielding a wide variety of statistical options	standard deviation, main effect, anova	6
79	Using SAS Character and List Functions to Extend the SAS Systems: Macro-Programming of Useful Functions	Sigurd W. Hermansen		data step, macro function, macro variable, character variable, sample, data statement, character functions, macro definition	8
80	Using SAS Dataset Options to Improve Efficiency	Clinton S. Rickards	SAS is designed to automatically keep and process all obselVations and variables in DATA and `PROC` steps. Although this makes coding easy it can result in spectacularly inefficient programs. Using a few simple dataset options (specifically DROP=. KEEP=. RENAME= and WHERE=). programs can be made simpler and much more efficient. A brief review of the dataset options and their effect will be followed by a series of real life examples to illustrate their usage	proc step, out=	2
81	Using SAS to Create Secondary Merge Files for Wordperfect 5.1	Charles A. DePascale, Jim H. Jagielski		sample, character variable	2
82	Using SAS to Generate Reports to Evaluate the Output of Virus Scans	Debbie Hoppe		macro variable, life insurance	7
83	Using SAS/FSP and SCL to Manage the Interaction Between End Users and the Application	Felix G. Meale, Nancy Mae Bonney		error message, missing value	3
84	Using SAS/Graph for Mapping Physical Features Throughout the United States	Mitchell Karpman		proc step, proc gmap, dataset	6
85	Using SAS/Graph Output in Non-SAS Programs	Michael S. Zdeb		proc step, filename statement	6
86	Using the PUT Functions to Recode Variables	Ronald P. Cody		character variable, put statement, proc step, proc freq	2
87	Using the SAS DATA Step Language to Read dBASE III Files	Michael C. Harris	The dBASE III file fannat is arguably the most enduring in the PCIMS-DOS world. Originated by Ashton-Tate in the 19805, it has won widespread support among third party vendors of both end user products and application development tools. The tenn "xBase" has been coined to describe third-party products supporting the dBASE file fonnat. Today, specialized research databases are available in the dBASE .DBF tbnnat. They may contain many tens of thousands ofrecords and occupy multiple megabytes of disk space. This paper discusses a tech nique for reading DBF files into SAS data sets in the PCIMS-DOS and UNIX Sun-OS environments. The concepts may be applicable to other operating systems as well	dataset, data step, character variable, numeric variable, proc step	7
88	Using the SAS System for Remote Data Access and Distributed Computing	John McIntyre			4
89	Utilizing SAS/AF and Screen Control Langage: A Census Bureau Application	Steve Proudfoot, Kimberly Pressley	The Enterprise Statistics Branch at the Census Bureau conducts the Surveys of Minority-Owned Business Enterprises (SMOBE) and Women-Owned Businesses (WOB) every five years. The data are collected, tabulated, and released In various formats such as publication, CD-ROM, etc. MicrCHIata are stored for analytical purposes and requests for special tabulations. In the past, special tabulation requests were referred to a programming division to be performed on a mainframe - a very costly and time consuming procedure. For the 1987 surveys, the branch was able to download the data to an IBM-compatible 486 PC. Custom tabulations were prepared within the office on a request basis utilizing the SAS system. The majority of these requests were for number of businesses at the 4-digit Standard Industrial Classification code level. The custom programming on the PC was more efficient than on the mainframe; however, due to the number of requests for 4-digit SIC information	proc sort, sas output	5
90	Working with Arrays: Doing More with Less Code	Ralph W. Leighton	; Arrays are a SAS Basic Language OAT A-step feature useful for organizing. manipulating. and performing calculations on groups of data elements. Arrays have been an important feature of other more traditional procedural "scientific' programming languages. such as FORTRAN, PLl1 and PASCAL A key pointto remember at the outset is that arrays are a processing tool within the `DATA STEP`: they are not, in and of themselves. data on SAS Oatasets. Often one needs to perform the same calculation on a series of SAS variables, as for example the tax calculations below	calendar year, proc step, input statement, array, proc print, dataset, temporary array, proc transpose, sum	11

Back to Conf go 1993 go 1991

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.