SCSUG 2003 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	%ARRAY: Construction and Usage of Arrays of Macro Variables	Ronald J. Fehd	3. subscript: required, either of 3: number supplied for creation of a series of variables *: asterisk indicating subscript is determined by SAS software by counting the supplied array- elements The SAS software `DATA STEP` statement array V 3 $ V1-V3 ('A' 'B' 'C'); produces three character variables named V1, V2, and V3 with corresponding initial values, 'A', 'B', and 'C' and a function, dim(V), which returns a value of 3. Programmers can write simple macro tools for use in larger macro procedures. These tools can duplicate SAS software `DATA STEP` constructions that the programmer is comfortable using and 4. array-elements: an optional list of variable names The dimension function has two commonly used phrases: make reading and comprehension easier. The macro statement %ARRAY(V,A B C) produces three macro variables, V1, V2, and V3, with corresponding values: A, B, and C and macro variable DIM V with the value 3	macro variable, data step, array, macro facility, macro loop	6
2	A Beginner's Guide to Incorporating SAS Output in Microsoft Office Applications	Vincent DelGobbo	This paper provides techniques for incorporating the output from SAS software, regardless of the install platform, in Microsoft `EXCEL` and Word (versions 2000 and later). The paper focuses on the use of the Output Delivery System (`ODS`) and SAS servers	excel, proc step, ods html, proc tabulate, sample, sas output, proc print, output delivery system, macro variable	8
3	A Beginner's Guide to Simulation Studies	Barbara Foster		sample, sample size, normal distribution	10
4	A Journeyman's Reference: The Writing for Reading SAS Style Sheet: Tricks, Traps, Tips, and Templates, from SAS-L's Macro Maven	Ronald J. Fehd	A program is a form of communication that occurs in two distinct and vastly different events: the first event is immediate, when the program is submitted to the language processor for execution; the second event takes place at a later time, when the writer or another programmer returns to read that program for maintenance. A good style sheet can facilitate program maintenance. This is especially important when simultaneously writing in two languages: SAS and its macro language. This paper discusses elements of a style sheet for SAS programmers. The intended audiences are intermediate SAS programmers and beginning macro programmers	macro facility, macro variable, macro definition, %if-%then-%else, proc step, macro loop	7
5	Building Drill-Down SAS Applications	Kirk Paul Lafler, Charles E. Shipp		output delivery system, ods html, ods pdf	4
6	Coding Genetic Algorithm for Cluster Analysis Through Basic Programming Techniques and the SAS Macro	Kaveephong Lertwachara	This paper describes an alternative approach in coding a genetic algorithm. The genetic algorithm is implemented for a cluster analysis using basic programming techniques and the SAS macro. The main code performs a single iteration of cluster analysis. Simple statements such as IF, THEN, ELSE are used at this stage. Then, the SAS macro is used for create global loops and specify some variables	cluster analysis, macro definition	17
7	Data Management, Statistics and Dog Bones???	O. M. Little		crf, dataset	6
8	Documentation and Accountability: Why Your SAS Programming Projects Can Benefit from Implementing a System Development Life Cycle (SDLC)	Jennifer K. Fulton, Stephen Black		sas programming, data science, data cleaning	5
9	Elementary Statistics Using Base SAS	Deborah B. Buck	the math test score. Also, th ey would like to de monstrate a greater improvement in the new meth od than in the standard method. However, since they are unsure of the potential r esults, all tests will be two-sided. Base SAS includes a numbe r of procedures that will allow you to perform element ary statistical analy ses. Most of these PR OCs produce descriptive statistics, but there a re some capabilities for inferential statisti cs (h ypothesis t esting) as well. This paper will discuss which Base SAS PROCs will provide you with the desired statistics and show examples of code and out put for a research study. The out put sho wn was g enerated using SAS Version 8, however, the code is also valid for SAS Version 6.12. These researchers only have access to Base SA S, therefore som e frequently used inferential statistics, su ch as ana lysis of variance, are not available to them	proc step, correlation, sas base, proc corr, inferential statistics, standard deviation, change from baseline, proc freq, proc means, pearson correlation, anova, sample, sample size, proc univariate, normality test, spearman correlation	9
10	FUZZY MERGES: Examples and Techniques	Malachy J. Foley	Frequently SAS programmers must merge files where the values of the key variables are only approximately the same. M erging o n names wi th app roximately t he sam e spelling, or merging on t imes th at are with in three minutes of ea ch other are examples of t hese kinds of merges. T hese m erges are often called fuzzy m erges. This tu torial ex amines th e realm of fuzz y merges. It looks at relevant techniques and gives examples of actual programs that produce fuzzy merges	missing value, retain	10
11	Getting Familiar with SAS Version 8.2 and 9.0 Enhancements	Sunil Kumar Gupta	Concatenating Libraries and Catalogs Are you just getting around to realizing what SAS version 8.2 has to offer while recently being introduced to SAS version 9.0 at SAS User Group Conferences? Are you one of those programmers searching for a reason to migrate to 8.2? Would it not be nice to have a quick	proc step, audit trail, constraint, proc freq, proc sql, proc print, proc sort, data integrity, sas enterprise guide, macro variable, proc contents, excel, libname statement	9
12	Guidelines for Coding of SAS Programs	Thomas J. Winn Jr.	This paper presents a set of proposed guidelines that could be used for writing SAS code that is clear, efficient, and easy to maintain. The guidelines described herein are widely regarded as good practices for SAS programmers of all ability levels, and for all types of computing environments	proc step, keep statement, macro variable, proc sql	6
13	How to Incorporate Old SAS Data into a New DATA Step, or "What is S-M-U?"	Andrew T. Kuligowski	S-M-U. Some people will see these three letters and immediately t hink of the a bbreviation f or a p rivate university and asso ciated football team in Texas. Others might treat them a s a three-letter word, and recall a whi msical ca rtoon cha racter created by Al Capp many years ago. However, in the world of the SAS user, these three letters represent the building blocks for processing SAS datasets through the SAS `DATA STEP`. S, M, and U are first letters in the words SET, MERG E, and UP DATE - the 3 com mands used to introduce SAS data into a `DATA STEP`. DATA newdata; SET olddata1 olddata2; / additional statements /	dataset, set statement	10
14	Indicators of Inpatient Quality in Texas Hospitals	Sylvia Cook	The Texas Health Care Information Council (THCIC) is charged with producing reports on the quality of Texas hospitals. The methodology used to measure hospital quality is required by statute to include case-mix qualifiers and severity adjustment factors to accurately reflect hospital quality. This paper describes the application of SAS software developed for the federal Agency for Healthcare Research and Quality which satisfies those requirements to Texas hospital inpatient discharge data collected by THCIC. The SAS software was used to produce risk-adjusted rates for 25 indicators of inpatient quality in Texas hospitals. A report released in May 2003 includes data for years 1999 through 2001 for the 25 indicators	dataset, regression analysis, reference data, proc step	9
15	Inventory Forecasting With SAS/OR	Tom Taylor		integer programming, neural network	6
16	JavaTM Syntax for SAS Programmers	Don Boudreaux	As SAS coders are being asked to deploy their results on the web, they are challenged with learning any number of new technologies, scripting languages, and programming languages. In the cases where this effort will involve Applets, Servlets, or JavaServer Pages, the programmer will be faced with a rather complex object-oriented programming language to understand - Java. Obtaining a level of proficiency with Java involves a considerable investment in time and effort. However, a SAS programmer using webAF to create dynamic web applications with JavaServer Pages might only initially need to understand the basic syntax of Java in order to write short embedded code segments (scriptlets). Assuming this specific scenario defines the programming context, this paper will investigate basic Java syntax from a SAS perspective	conditional do loop, missing value, sas programmer	6
17	Macros - Basic	Destiny Corporation (a company)		macro variable, automatic macro variable, symbol table, macro definition, macro parameter, %macro parameters, put statement, macro quoting function, macro put, proc step, title statement, keyword parameter, missing value, macro facility, global symbol table, proc print, macro call, options statement	14
18	Macros - Intermediate	Destiny Corporation (a company)		macro variable, symbol table, call symput, local symbol table, data step, global symbol table, put statement, macro put, character variable, sas log, work library, macro definition	12
19	Macros Made Simple	Tom Mannigel		macro loop, do loop, macro definition, macro variable, macro facility, &variable	5
20	Merge Processing and Alternative Table Lookup Techniques	Destiny Corporation (a company)		proc sql, macro variable, array, data step, pdv, proc step, lookup, dataset, by group processing, modify statement, proc format, char., key=, master data management, data merging, character variable, format statement	7
21	Multi-Lingual Computing with the 9.1 SAS Unicode Server	Stephen M. Beatrous	In today's business world, information comes in many languages and you may have customers and employees in various countries all over the globe. It is very possible that your mission-critical data will be created and stored in more than one language. SAS offers several features that allow you to store and process multilingual data. With SAS 9.1, it is now possible to write a SAS application that processes data from many languages all in the same SAS session. This paper introduces the Unicode support that is provided in SAS 9.1 and discusses several scenarios for how you might use this support to deliver multilingual data to users around the world	sas 9, character variable, proc step, libname statement, put statement, sas base, ods html	8
22	Object Oriented Programming with SAS/AF Using Event Handlers and Extending SAS Objects	Kevin Graham	User-defined events provide Frame/SCL developers a complete toolset that helps streamline the applications development cycle. Combining object-oriented programming with Events is easy to understand and provides an excellent way to prototype application behaviors. By extending SAS objects developers can reprogram inherited methods, events, and attributes to define/redefine object actions and secondary object reactions in a way that closely mimics JavaScript/HTML programming	sas log, dataset	13
23	ODS LAYOUT: Arranging ODS Output as You See Fit	Brian T. Schellenberger	A new experimental feature for version 9 (both v9.0 and v9.1) is the `ODS` LAYOUT feature. Using this feature, you can easily mix graphics, text, and tables on the same page, arranging them in any position you want on the page. It's a bit like `PROC GREPLAY` only not just for graphics anymore. Complex reports and even forms, which were previously almost impossible to produce with `ODS`, are now quite straightforward to create. If you are required to present your data in a very specific format, with different parts of the report at different positions on the page, we finally have a solution for you	output delivery system, proc step, proc print, macro variable	13
24	Optimization with the SAS System: What It Is, What's New, and Why You Should Be Using It	Edward P. Hughes, Trevor D. Kearney	This paper presents an introduction to optimization and an overview of SAS capabilities in optimization, with a focus on mathematical optimization with `SAS/OR` software. We review the current suite of optimization modules and techniques available in `SAS/OR` software, highlighting recent additions. We discuss the value that optimization adds to business intelligence, and we describe several recent cases in which optimization has played a central role in the creation of SAS decision support solutions		7
25	Proc SQL - A Primer for SAS Programmers	Jimmy A. DeFoor		proc sql, proc step, select, group by, order by, proc print, proc means, create table, where statement	10
26	Pruning the SASLOG - Digging into the Roots of NOTEs, WARNINGs, and ERRORs	Andrew T. Kuligowski	You've sat through constant design meetings. You've endured countless requests for "just one more little change". You even managed to find a creative solution to that nagging technical problem. But, you persevered, and despite all of the obstacles, you've managed to eliminate the final syntax error in your newest SAS routine. Time to sit back and relax -- uh, not quite ... The primary focus of this presentation will be on techniques to ensure comprehension of your input data. We will look at several messages that are often found in the `SASLOG`, such as: NOTE: `MERGE` statement has more than one data set with repeats of BY values. that imply that there may be gaps in your knowledge of your data! Special emphasis will be placed on the use of ad-hoc queries to assist in finding data anomalies that can cause problems with your SAS code	input statement, numeric variable, proc step, merge statement, out=, index, data cleaning, infile statement, proc means, dataset, e., sample, put statement	11
27	Quicker Than Merge?	Kirby L. Cossey	How many times do you need to extract a few records from a large dataset? This paper compares four techniques: traditional merge, using SAS to write a where statement for you, the key= option on a `SET` statement, and SQL join	cpu time, where statement, proc sql, set statement, data merging	5
28	Reading and Writing Data from Microsoft Word/Excel Using DDE	Destiny Corporation (a company)		excel, data step, dataset, macro variable	7
29	SAS Performance Tuning Strategies and Techniques	Kirk Paul Lafler	As SAS Software becomes increasingly more popular, guidelines for its efficient us e are critical. Areas deserving special consideration include program execution, I/O, disk space, and program maint enance. A collection of techniques and sample code are presented to illustrate numerous practical methods for gaining efficiency while using SAS Software. The simplest of requests can fall prey to one or more efficiency violations, such as retaining unw anted datasets in w ork space, not subsetting early to eliminate undesirable records, or reading w anted as well as unwanted variables. Much of an application's inefficiency can be avoided w ith better planning and knowing what works and w hat does not prior to beginning the coding process. Most people do not plan to fail - they just fail to plan. Fortunately, efficiency gains can be realized by following a few guidelines	cpu time, proc sql, drop statement, dataset, if-then-else	6
30	SAS Solutions for the Web: Static and Dynamic Alternatives	Matthew Grover	This paper provides a detailed analysis of creating static and dynamic web content using the SAS System. The objective is to provide synthesis of the SAS technologies that enable communication with SAS applications via the web. Instead of looking at the dynamic solutions from a product perspective, this paper attempts to look at the software components that are involved with both remote data and remote computing services from a technology perspective. Web Content Generation HTML content primarily can be created within SAS in one of two ways Write out html tag statements (either in the `DATA STEP` or SCL) Output Delivery System (`ODS`) Benefits of Using `ODS` Provides an easy way to markup an output file with very little code. Content is separated from presentation format within the code by using pre-defined SAS supplied template definitions	output delivery system, proc step, macro variable	12
31	SAS System on Network Appliance: Performance Tuning a SAS Environment with Network Appliance Filers	Darrell Suggs, Margaret A. Crevar, Leigh A. Ihnen			19
32	SAS Table Design - The Good, The Bad, and The Ugly	Kenneth Bissett	How do you go about designing your SAS tabl es? What defines a row and what defines a col umn? Should you have a row for eac h unique customer account, or should you st ore one row per customer, with a column for each of their accounts? Does it even matter? In the database world, the `PROC` ess of table design is called database normalization. A highly skilled database administrato r will design a series of tables to redu ce data r edundancy, lower storage requirements, and hopefully speed up processing. In t he world of SAS, we typically don't consider the high ly skilled DBA because we're usually not buil ding compl ex sets of relate d tables. But there are things we should consider. This paper will give the SAS programmer a basic idea of some of the table design considerations as well as provide some business scenarios where good table design is critical. Examples will also be provided which will show different techniques for analyzing data depending on the table design	dataset, proc sql, proc freq, proc step	7
33	SAS/STAT Version 9: Progressing Into the Future	Robert N. Rodriguez, Maura E. Stokes, Randy Tobias	Version 9 of `SAS/STAT` software delivers a wealth of tools and functionality for statistical modeling and data analysis. Areas covered by new or enhanced software include multiple imputation, conditional logistic regression, robust regression, general linear models for proportional hazards, regression diagnostics, survey data analysis, power and sample size analysis, statistical distance computations, statistical graphics, and parallelization		6
34	Some Things Mainframe SAS Programmers Need to Know to Use SAS on the PC	Clarence W. Jackson	This paper is intended to assist SAS mainframe programmers in making the transition to writing SAS programs for the PC and client server environment. Since the core SAS language is the same regardless of the op erating environment in which it runs, and only differs in the operating system's host interface, special attention will be given to how to access the PC (Windows) host files fo r input and directing output, and relating it to MVS JCL	sas programmer, macro facility	5
35	SQL - Intermediate	Destiny Corporation (a company)		proc sql, proc step, inner join, select, full join, coalesce function, where statement, right join, data step, create table, macro variable, missing value	19
36	SQL Basics	Destiny Corporation (a company)		proc sql, proc step, group by, select, where statement, dataset, order by, data step, error message, sas programming, proc means	17
37	Tricks and Tips with SAS/IntrNet	Keith Cranford, Dan Hammarstrom	This paper presents various techniques that help make your `SAS/INTRNET` applications more useful for your users. Printing considerations, graphics enhancements, and interactivity are some of the topics covered. The techniques involve SAS code and options as well as HTML, JavaScript and VBScript	proc step, proc template, output delivery system, excel, ods html	14
38	Using DDE to Communicate Between SAS and Excel	Jim Hoffman	This presentation will show the audience how to interact with Microsoft `EXCEL` via a DDE link from SAS. We go past the macro driven routines that have been presented previously into the specific code required to do various tasks. We will start with how the connection to `EXCEL` is made. Then jump into Navigating the spreadsheet and entering variable data and formulas. Following that we look at a full range of formatting options. Finishing up with saving your work and exiting the system	excel, sample, macro variable	6
39	Using ODS With PROC UNIVARIATE (Poster)	Rebecca G. Frederick		proc step, likelihood function	11
40	Version 9 ODS (Output Delivery System) - Basics	Destiny Corporation (a company)		proc step, sas output	14
41	Version 9 ODS - Intermediate	Destiny Corporation (a company)		proc template, proc step, sas log	14
42	Web-Enable Your SAS Applications	Teresia L. Arthur, Mary Jafri	How many times do we write applications only to rewrite them later because a new operating system comes online, customers want a friendlier interface or customers just want "the latest cool stuff"? Wouldn't it be wonderful if we could write core application code that remained in use throughout the evolution of an application and if that application remained in service for many years? Who said applications have to become antiquated so quickly and who has time and resources for application rewrites? The objective of this paper is to demonstrate how a production	data validation rules, sample, proc step, proc sql	7
43	Writing Your SAS Program Right	Clarence W. Jackson	This paper is for SAS Users who want to write programs right the first time, and it defines the steps needed to write qu ality SAS programs. These steps include how to define the problem to be solv ed and the goal of the programmed solution, defining input and o utput specifications, and other el ements of the life cycle in implementing the program in the environment for use	sas programmer, sample, data validation rules, sas programming	11

Back to Conf go 2004 go 2002

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.