HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

SCSUG 2006 Papers - Index

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

Back to Conf
go 2007
go 2005
# Title
×		 Authors
×		 Abstract
×		 Keywords
×		 Extras Pages
1 An Introduction to SAS Information Map Studio Kevin Davidson SAS Information Map Studio is used to create information maps - metadata that surfaces your data into terms that business users can understand. Information architects can visually specify relationships between tables so that business users can query the data and get reports without having to know much (or any) programming. SAS Web Report Studio will be used to demonstrate the utilit y of information maps. A couple days before the conference deadline for submitting this paper I found out about some major upgrades to Information Map Studio, making some of my content out-of-date. Thus I'm going make this more of an executive summary style paper rather than a technical one with a plan of demonstrating the latest release of the software, version 3.1, during the presentation sas base, sas enterprise guide 10
2 An Introduction to SQL in SAS Peter J. Lund SQL is one of the many languages built into the SAS System. Using PROC SQL, the SAS user has access to a powerful data manipulation and query tool. Topics covered will include selecting, subsetting, sorting and grouping data--all without use of DATA STEP code or any procedures other than PROC SQL group by, proc sql, where statement, order by, select, create table, proc step, dataset, missing value, proc sort, sas output, if-then-else 22
3 Avoiding Mouse Elbow Malachy J. Foley Computer programming or coding may literally be dangerous to your health. Mouse Elbow, which is akin to Tennis Elbow, is just one adverse health condition that is associated with computer use. Other maladies associated with computers include Carpal Tunnel Syndrome (from keyboard and the mouse), shoulder and neck pain, and Sciatica. This paper describes computer-related health risks with special emphases on musculoskeletal disorder (MSD) and Mouse elbow. The information in this paper will hopefully help you avoid computer-related injury, or detect and cure it at an early stage 7
4 Basics of Modeling in a Data Mining Context Keith Cranford Data mining has become an industry buzz word, but what is it and how does it differ from traditional statistical methods? This paper addresses these questions by discussing the modeling process involved in data mining. The emphasis is on the process and model evaluation with only brief mention of modeling techniques. SAS Enterprise Miner is used to demonstrate certain aspects of the process. Data Mining Data mining has become a hot topic, but what is it? A couple of definitions found in the data mining literature give some insight into this question. Data mining is the analysis of (often large) observational data sets to find unsuspected relationships and to summarize the data in novel ways that are both understandable and useful to the data owner.1 Data mining is the process of selection, exploration, and modeling of large quantities of data to discover regularities or relations that are at first unknown with the aim of obtaining clear and useful results for the owner of the database data cleaning, neural network 8
5 Classic DATA _NULL_ and PUT Statements are Still Viable Solutions Howard Hagemann put statement, macro variable, proc step, filename statement 28
6 Creating AND Importing Multi-Sheet Excel Workbooks the Easy Way with SAS Vincent DelGobbo output delivery system, excel 20
7 Creating Zillions of Labels (and Other Documents) the Easy Way with ODS and Microsoft Word Vincent DelGobbo This paper provides a quick and easy way to generate address labels or other data-driven documents from your SAS data. The first step is to use the SAS Output Delivery System (ODS) to convert your data into a format that Microsoft Word can import. Then you use Word's Mail Merge Wizard to guide you through the steps to create your document. The technique is easy, requires only Base SAS version 8 or later, and will work on any platform where SAS is installed (even if SAS is installed on a mainframe). This technique can also be used with SAS version 6 by using the SAS HTML Formatting Tools instead of ODS dataset, sample 5
8 Data Mining at the Texas State Auditor's Office Thomas J. Winn Jr. In general, data mining is the iterative and interactive process of finding new and potentially useful knowledge from large quantities of data.1 The author's use of that term encompasses sophisticated statistical techniques, as well as many simpler data analysis methods. The mission of the Texas State Auditor's Office is to actively provide government leaders with useful information that improves accountability.2 This expository presentation describes some data mining work at the State Auditor's Office in support of auditing and investigationsactivities. Particular attention will be given to fraud detection and risk assessment. The Texas State Auditor's Office3 The State Auditor's Office (SAO) is the independent auditor for Texas State government. Operating within the legislative branch, the SAO provides government leaders and citizens with independent, objective, and reliable information about the operations of state agencies and higher education institutions data mining, internal audit, outlier, data science, proc hpsplit, neural network, type ii error 11
9 Data requests, quickly Elisa L. Priest As completion of a research study nears, investigators want to begin preliminary analysis of their data. Often, a data manager receives multiple data requests at once from different collaborators. I will give examples of code developed for a clinical trial that allows a data manager to produce complex datasets from multiple data tables with useful EXCEL data dictionaries, and fulfill customized data requests with minimal effort during the hectic final stage of a study adam dataset, label statement 6
10 Deploying SAS9 on Solaris 10: Calling Superheroes to Fight Supervillians Maureen E. Chew Solaris 10 brings a dream team cast of superheroes that can enlighten and empower meek and mild mannered SAS users / systems administrators to fight the evil villians and archenemies which prevent successful SAS deployments. Solaris 10 Containers brings Spider-Man to the rescue in the form of extreme agility as we explore a novel approach to promotion of SAS 9 test environments to production as well as extreme 'web' security in stopping attackers cold by forming protective shields or nets. Service Management Framework(SMF), part of the Solaris 10 Predictive Self-Healing feature, brings the superhuman healing factors known to the Incredible Hulk and X-Men's Wolverine and Archangel. Discover how SMF can monitor and self-heal key services such as SAS Metadata server and OLAP server. Solaris 10 DTrace is Batman's utility belt needed by Solaris admins and users who need to be 'in the know' sas 9, sas management console 15
11 Documentation-Driven Development of SAS Data Warehouses Leonid Batkhan This paper describes a process that is used in a SAS data warehouse implementation. Data model documentation of a SAS data warehouse (in Microsoft Word or EXCEL) serves as a feed to a SAS program that performs ETL. Coding techniques are presented for renaming variables and applying SAS formats, informats, and labels to SAS data warehouse tables. It proved to be extremely efficient during development, when data models often undergo changes and modifications. This suggested approach significantly speeds up the implementation of data warehouses data warehouse, dataset, macro definition 8
12 Flattening Dependent Tables from Relational Databases for Use in SAS Processing David Welch macro variable, array, data step, proc glm, proc genmod, proc step, dataset, cpu time, response variable, out=, ancova, macro loop, relational database, temporary dataset, variable list, character variable, covariance, sysrc, macro definition, main effect, proc datasets, proc univariate, %if-%then-%else 34
13 Getting Data into SAS: INFILE and INPUT Andrew T. Kuligowski The SAS System has numerous capabilities to store, analyze, report, and present data. However, those features are useless unless that data is stored in, or can be accessed by, the SAS System. This presentation includes an introduct ion to the INPUT and INFILE statements, which combine to provide a simple, yet powerful, method to pass data into the SAS System. Matters to be addressed are reading fixed and variable length files, .CSV files, in -stream data, informats, and more input statement, infile statement, proc step, character variable, proc copy, proc sql, dataset, variable, filename statement, libname statement, column input, list input 8
14 Getting From SAS-A to SAS-B: Some differences between academic and business SAS use Bryan Shepherd output delivery system, sas base 5
15 Getting Started with the DATA Step Hash Object Jason Secosky,
Janice Bloom		 A time consuming part of many SAS programs is looking up a value from one data set in another data set. SAS 6 lookup methods, like SET with KEY= or a format, are good for many applications. However, in SAS 9, there is a better tool, the DATA STEP hash object. The hash object provides a fast, easy way to perform lookups without sorting or indexing. This paper introduces the hash object, examines a few common hash object methods, compares SAS 6 techniques with the hash object, and builds rules of thumb for when to apply this new technology to your programs hash table, master data management, sysrc, sample, sas log, transaction data, set statement, hash iterator, sas 9, input statement, length statement, merge statement, key=, lookup, memory usage, options statement, proc step 10
16 Guidelines for Development of SAS/IntrNet Applications Thomas J. Winn Jr. Application developers often have different backgrounds, training, development expertise, and coding styles. All of these factors influence the programmer's approach to application development. For most information technology departments, the resources expended for soft ware maintenance constitute a huge share of the software budget, and software maintainers spent most of their time trying to understand the underlying logic of the system being modified. 1 Therefore, in order to make our coding more consistent, and to make the code that we write easier to maintain , we should seek adherence to a comprehensive set of development standards. This paper will discuss the establishment of standards and guidelines for the development of SAS/INTRNET applications at the State Auditor's Office. The Case for Standards The Case for Standards There are very many ways to write programming code in order to accomplish a particular objective proc step, dataset, proc sql, sas log, sas programmer, macro variable 25
17 Implementing a Data-Driven Courseware System with SAS Don Boudreaux This investigation presents a courseware system that is designed to facilitate the development and rapid deployment of web- based courses. Conceptually the system requires a collection of instructional documents and an overall course schema. Specifically, the instructional documents are source HTML files that contain the course lessons. The course schema describes how the instruction lessons are organized into a class. It is defined within the hierarchical structure of an XML document. A SAS9 program is used read the XML course schema, filter the lesson source documents into a set of final course files, and build an HTML navigation page. A number of design considerations for building courseware are presented, several SAS9 coding tricks for parsing XML are shown, and some pros and cons for using XML are discussed data step, macro variable, macro definition 12
18 Keep it Organized - SAS tips for a research project Elisa L. Priest Students learn the basics of SAS programming in class or on their own and then embark on a research project with these newly developed skills. At the end of the project, you generally end up with multiple pages of SAS code, multiple .SAS files, and many datasets. I will present examples to help students keep their SAS code and SAS datasets organized from their first research project on. The primary topics to be covered will include: documentation of SAS code, using comments, program headers, tables of contents, and organization of SAS files. This will allow the student researcher to remember what they did, how they did it, and where the results are. This diligence will be a critical timesaver in the final revisions of a research project or dissertation adam dataset, in= 4
19 Large Scale Data Building with MP-Connect The Precursor to Statistical Analysis & Modeling David Cedillo macro definition, dataset, mp connect, macro variable, %if-%then-%else 12
20 Learning PROC REPORT by Comparison Keith Cranford You can use what you already know to learn PROC REPORT. This paper compares PROC REPORT to PROC PRINT, PROC TABULATE and PROC MEANS. Through the use of examples that produce similar reports, the syntax and features of PROC REPORT are illustrated. PROC PRINT Comparison You all probably use PROC PRINT to obtain simple data listings. In general, PROC PRINT is simple to use and provides a quick approach with minimal statements. However, beyond simple listings, PROC PRINT has limited options, whereas PROC REPORT can also produce simple listings, without too many more statements or options than PROC PRINT, and provides much more flexibility. Simple Listing The following statements can be used to produce a simple listing of SASHELP.CLASS. title 'Simple Listing' ; PROC PRINT data=sashelp.class ; var name sex age height weight ; title2 'PROC PRINT' ; run ; This code produces Output 1.A. Output 1.A Simple Listing proc step, proc print, proc report, proc tabulate 17
21 MISSING VALUES: Everything You Ever Wanted to Know Malachy J. Foley Many people know about the 28 different missing values for SAS numerical data. However, few people know about the many different missing values for character data. This paper reviews all the different types of missing values, their sort order, the difficulties they can cause the SAS programmer and how to avoid those difficulties. It also discusses the MISSING system option, and how to use the various missing values in input, output, comparisons, and in PROC FREQ missing value, proc step, options statement, proc freq, sas log, input statement, proc print, macro variable 9
22 Output Delivery System Tips and Techniques Kirk Paul Lafler Are you looking for ways to improve the way your output appears? The SAS Output Delivery System (ODS) can help turn tired-looking output into great looking information with a purpose. ODS introduces exciting new features for your output. Gone are the days when the only available formatting choice is basic output listings consisting of monospace fonts printed on a white background. Using built-in format engines, ODS addresses the inherent weaknesses found in traditional SAS output by enabling "quality" output to be produced without having to import it into word processors. In Version 9, many new output formatting features and options are introduced for SAS users to take advantage of. Users have a powerful and easy way to create and access formatted procedure and DATA STEP output proc univariate, output delivery system, sas output, proc format, ods html, ods pdf, ods rtf, dataset, proc step 12
23 PDF Can be Pretty Darn Fancy: Tips and Tricks for the ODS PDF Destination Peter J. Lund We're not too far removed from the days when presentation-ready SAS output meant lots of cutting and pasting or retyping. Now, the ODS PDF destination enables you to produce high quality output the first time, without other tools or applications. This paper explores a number of ODS options in general and, more specifically, their use in creating PDF output. We will cover ODS ESCAPECHAR, which allows for inline formatting of titles, footnotes and other text; ODS LAYOUT, which lets you place output wherever you want it on the page - even output from more than one procedure; inline formatting in PROC REPORT; overlaying output from SAS/GRAPH procedures on top of other output and more. We'll work from real life examples and see how you can produce output that looks like it took hours to create proc step, proc report, ods pdf, footnote statement, output delivery system, proc sql 19
24 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 obsta cles, 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 inpu t 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 numeric variable, proc step, input statement, merge statement, out=, index, infile statement, dataset, put statement 10
25 Psychometrics 101: Test Development Barbara Foster For nearly a century, the development and use of tests were more or less restricted to the educational and psychological arenas. During the 7 0s and 80s a groundswell of testing was developed and used in the Human Resources arena, to help match positions with candidates. Particularly in the last ten years, there has been a dramatic increase in the use of tests within the medical field. Quality of Life Measures and Pain Indices are two commonly known ones. Measures to determine the amount of exercise and food ingestion over time are constantly being developed and upgraded. In recent years, research studies have used various tests as part of their research protocol. In some cases, the researchers have little if any knowledge of the science of test development. Experts within the field of test development are called Psychometricians. The name reflects the roots from the fields of Education and Psychology. Years of study are required to obtain a Ph.D correlation, proc step 13
26 Ruby-on-Rails, PHP, and the Attractiveness of Web Languages to SAS Developers Tom Taylor In the last 12 months a programming firestorm by the name of Ruby-on-Rails has swept to the forefront of web programming languages. In the past decade languages like Basic, Java, and PHP have also held this position. Over this period, SAS has managed to either co-op or ignore each of these developments and keep their market position in tact. However, Ruby-on-Rails is the first one I have seen that might actually change the behavior pattern of those who develop SAS or SAS like applications. In this paper I will give a point of view on the evolution of these popular languages, what makes them popular, and the likely reaction in the SAS world. This paper takes a look at the arcane world of computer language evolution relational database, sas programmer 5
27 SAS Macro Language Quick Study Clarence W. Jackson The purpose of this paper is to briefly describe the Macro Facility in BASE SAS. The information presented in this handout is based on information found inBASE SAS Users Guide and the SAS Macro Facility Guide. The Macro Facility was introduced with the 82 Release of BASE SAS. The outline of the paper is as follows: I. Introduction A. What is the Macro Facility? II. SAS and Macro Facility Processes III. Macro Facility Overview A. Components of Macro Facility 1. Macro Processor 2. Macro Language B. Macro Language Components 1. Variables 2. Statements 3. Functions 4. Expressions and Text C. Macro Definitions and Referencing D. Referencing Environments E. Programming Statements F. Functions G. Auto Call Facility H. System Options IV. Quick Rules macro variable, &variable, macro facility, autocall macro, macro loop, macro definition, macro call, proc step 10
28 Some SAS Techniques Used in Insurance Business Wei Yu There are many statistical techniques used in predictive modeling. In this paper, I present the selection procedures for building the predictive models. The difference between regression an d GLM, the difference between PROC GLM and PROC GENMOD are explained in this paper. Some techniques for manipulating and cleaning the data are also presented. In insurance business, the factor of territory plays more and more important role today. We nee d to know the geographic distribution of our data. The quarterly updated SAS zip code file is a good resource to help locate the distribution of data. In this paper, I present how I code to visually present the distribution of data in a map, not only using the different colors to show the distribution of data, but also labeling the name of fields in the map proc step, proc genmod, proc glm, regression analysis, anova, proc reg, proc freq 4
29 Succession Planning for SAS Programmers Thomas J. Winn Jr. In any organization, succession planning is essential for the continuation of operations following the anticipated or unanticipated absence of employees with critical knowledge and skills. A succession plan would provide for the cross - training of existing employees to cover temporary absences, as well as the development of strategies to address inevitable permanent staff changes due to retirement, death, or other types of employee terminations sas programmer, sas analyst 4
30 Understanding WHERE Clause Processing and Indexes Kirk Paul Lafler SAS users can quickly access selected observations (rows) of data in SAS data sets using WHERE clause processing and inde xes. This paper explores what an index is, the purpose of an index, how an index is created, factors that determine when an index is warranted, how WHERE clause processing can take advantage of an index, and techniques for tuning indexes for better perform ance. Attendees will learn valuable techniques for achieving improved query performance using indexes where statement, proc sql, index, proc step 4
31 Using SAS to Map ICD-8, ICD-9 and ICD-10 Codes to Common Codes Angela M. Thompson,
Timothy S. Church		 12
32 What's New in SAS Enterprise Miner 5.2 Wayne Thompson,
David R. Duling		 SAS Enterprise Miner 5.2 for SAS 9.1.3 provides many new enhancements to help both business analysts and statisticians carry out the data mining process more efficiently and with greater control and flexibility. A major focus of this release is to deliver new interactive statistical and visualization tools. The tool set has been expanded to include the new SOM/Kohonen, Decisions, and Replacement nodes. Major improvements have been made to nearly every other node. System administration has been enhanced through the use of the SAS Analytics Platform, which provides both thin-client distribution and server management functionality. Grid processing is now supported to manage the workload created by a large group of data miners. Customers will find many reasons to upgrade to SAS Enterprise Miner 5.2 data mining, proc hpsplit, sas management console, sample, data wrangling, estimate, stepwise selection, training set, regression analysis, score code 10

Back to Conf go 2007 go 2005

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.