PNWSUG 2004 Papers - Index

25 papers. Source: PNWSUG (Pacific Northwest SAS Users Group) conference proceedings.

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	A Peek at PROC DOCUMENT	Andrew H. Karp	This document copyright 2003 Sierra Information Services, Inc. and may not be reproduced without the express written consent of the copyright holder. SAS is a registered trademark of SAS Institute, Inc. in the USA and other countries. indicates USA registration. 1 A Peek at	proc step, output delivery system, sas 9, logistic distribution, sas output	25
2	A Sort of a Mess: Large Datasets and Multiple Keys	David L. Cassell	One of the most useful features of SAS is its capabilities for handling large datasets. However, a sort of a very large dataset on many keys can present difficulties. Disk space or temporary space may be inadequate. The time needed may be enormous. The	proc step, proc sort, proc sql, cpu time	4
3	A System to Calculate Market Value-at-Risk using Oracle and Monte Carlo Simulation	George Rezek	`SAS/IML` is used with Base SAS and Oracle to produce a system to calculate Value-at-Risk (VaR) with the flexibility to reflect changes in the database, in the calculation, and reporting. VaR is calculated using Monte Carlo simulation. The overall process is covered and aspects of the calculation are highlighted. Finally, the impact of the results on the Enterprise are outlined	interest rate, confidence interval, standard deviation, covariance, interest rate risk, correlation, proc transpose, proc step, monte carlo	12
4	Anyone Can Learn PROC TABULATE	Lauren E. Haworth	SAS Software provides hundreds of ways you can ana- lyze your data. You can use the `DATA STEP` to slice and dice your data, and there are dozens of procedures that will process your data and produce all kinds of statistics. But odds are that no matter how you organize and analyze your data, you'll end up producing a report in the form of a table. This is why every SAS user needs to know how to use `PROC TABULATE`. While TABULATE doesn't do anything that you can't do with other PROCs, the payoff is in the output. TABULATE computes a variety of sta- tistics, and it neatly packages the results in a single table. Unfortunately, TABULATE has gotten a bad rap as being a difficult procedure to learn. This paper will prove that if you take things step by step, anyone can learn `PROC`	proc tabulate, proc step, ods html	9
5	Beyond the Data Dictionary - Database Consistency	Sheree Hughes	How often do you get a LOG file surprise telling you that the variable length of similarly named variables differs in more than one data source when you are trying to merge, or append them? Data Dictionaries serve a critical role in helping a user know his data within a dataset, but they do not enable a user to get the bird's eye view that is also needed across a database. This paper details an effective way to determine variable name, length, type, and format consistency across multiple SAS datasets in a database. It uses the features of `PROC CONTENTS`, The `DATA STEP`, and `PROC TABULATE` to produce a report that indicates, at a glance, any discrepancies in name, length, type, or format characteristics. The "Variable Dictionary", like the "Data Dictionary" is a tool that every database manager should not be without! In a few easy steps you can keep your data clean, and know what to fix, if it is not	proc step, proc tabulate, proc contents, data dictionary, dataset	6
6	Bridging the Censuses: An Object-Oriented Metadata-Driven Approach	Curtis E. Mack	The VISTA group needed population estimates that were not supplied by either the Census Bureau or by the Washington State Office of Financial Management (OFM). What they needed were small area population estimates with a complete matrix of race, Hispanic ethnicity, detailed age, and sex. They needed these as a continuous series for every year 1990 to present so that they could be used for trend analysis. These estimates needed to agree with published OFM numbers at the county level and with 1990 and 2000 Census counts.	demographics table, constraint	9
7	Building an Online Entry Form with WebAF (and a Little Java)	Frederick E. Pratter	The AppDev Studio software suite from SAS is a comprehensive set of tools for developing web applications. This paper is intended as a quick introduction to WebAF, the SAS IDE (Integrated Development Environment) for building dynamic web content based on SAS data. Once an initial system configuration has been established, it is possible to provide dynamic access to SAS datasets in real-time for thin clients that do not have any SAS software available. This is accomplished using the JavaServer Pages technology from Sun Microsystems, along with some server-side SAS resources	dataset, sample	19
8	Complex Sampling Meets the Blazing Turkey of Glory	David L. Cassell	Sophisticated sampling designs can save money, provide more accurate answers, and answer questions that simple AnnMaria: I would choose a sampling design which will random sampling (or non-random data) cannot. Yet too many reveal accurate estimates for a minimal cost. investigators are guilty of a multitude of sins. These include David: I would choose a sampling design which will reflect not collecting data optimally, not analyzing data according to the complexities of the target population. the underlying features of the sampling designs or (horrors!) The Client: [in an odd Peter Lorre-like voice] The Client all of the above. Survey data are the lifeblood of marketing chooses.. stratified sampling! analyses, healthcare studies, environmental and sociological <pause> research, and many other areas. It is essential that data be The Client: What?!? The Client LIKES the stratified collected and analyzed in the best possible ways	sample, proc step, proc surveyselect, stratified sampling, cluster sampling, random sampling, population, sample size, sample weight, by group processing, proc surveyreg, proc reg, proc surveymeans, regression analysis, missing value, proc calis	8
9	Design better graphs:Tips and Tricks for efficient charts and plots	Aaron Wnkel	A good graph is easy on the eyes and attracts the viewer to the content and information contained in the graph. There are default features in `SAS/GRAPH` that are not always necessary - borders, frames, gridlines, legends, etc. With a little TLC, graphs can be scaled down to wash away the "busyness". This paper will demonstrate techniques for eliminating chartjunk to enhance the graphical presentation of information. At the same time, it will show ways to augment the relevant portions of the graph	macro variable, proc gplot, proc step	10
10	Dynamically Change Your Perspective with the Link King (and a Little SAS/AF)	Kevin M. Campbell	Administrative datasets containing client identifying information (names, birthdates, SSNs) are often used for a variety of research and evaluation projects. The projects often require the linking of two or more independently maintained client rosters in order to track service utilization across different systems. Unfortunately, a given client may be represented with slightly different identifying information both within and across administrative datasets. Discrepancies arise from a variety of reasons including: Use of nicknames Hyphenated names Misspelled names Transposed SSN digits * Transposed date fields Failure to identify and appropriately deal with this problem may lead to incomplete linking of client records and, ultimately, introduce unnecessary error into the research or evaluation project. This paper introduces The Link King - a `SAS/AF` application for use in the linkage and unduplication of administrative datasets	record linkage, character variable, sample, in=, batch processing, missing value, artificial intelligence, imputation	9
11	Extracting Data from Oracle into SAS - Lessons Learned	Maria Y. Reiss	In the pharmaceutical industry, it is very common to use SAS and the Oracle Clinical database system together to store, process and analyze clinical data. The traditional way of using these products is to store the clinical data in an Oracle Clinical database and analyze the data us ing the SAS system. Before data can be analyzed with SAS, it must be extracted from Oracle and transformed into SAS views or da ta sets. This paper provides an overview of the various te chniques available to accomplish this ta sk. In SAS 8, SAS Institute introduced SAS Integration Technologies, a product that allows easier integration of SAS with other applications. This paper also discusses the use of this product to integrate SAS and Oracle	clinical data, clinical database, proc sql	12
12	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 think of the abbreviation for a private university and associated football team in Texas. Others might treat them as a three-letter word, and recall a whimsical cartoon character created by Al Capp many years ago. Howe ver, in the world of the	dataset, libname statement, set statement	9
13	Make Your Life a Little Easier: The Evolution of a SAS Macro	Peter J. Lund	SAS Macros are used in a variety of ways: to automate the generation of SAS code, to simulate functions and subroutines, or even to "comment" out a section of code. This paper focuses on another use of SAS macros: utilities. These macros don't generate any SAS code and they aren't "functions," but they all take tasks I found myself doing repeatedly and bundled them in an easy to reference package. These are examples range in scope from displaying SAS date values to retrieving information about external files, from getting the values of current options to getting a list of variables in a dataset. They are meant to be just that - examples. I hope that they will give you some ideas about how to automate some of the tasks you find yourself doing repeatedly.	sysdate9, macro variable, macro definition, macro put, date variable, macro loop, %if-%then-%else, proc sql	10
14	ODS Tips and Tricks	Lauren E. Haworth	Haven't gotten around to reading the entire `ODS` section in Online Doc? Don't have time to read a whole book on the topic? This presentation will show some simple tips and tricks from my book "Output Delivery System: The Basics". In no time you'll be impressing your boss and coworkers with beautiful customized `ODS` output. The presentation will include easy-to-use techniques for enhancing HTML, RTF, and printer results.	proc step, ods output, ods rtf, proc freq, output, proc means, ods html, proc template	7
15	Perks of PRX...	David L. Cassell	Pattern matching lets you find chunks of text that have a particular pattern - even patterns that would be very hard to find using SAS functions like index() and substr(). For example, try finding all strings which have two consecutive words that are the same, not counting capitalization. Difficult with traditional SAS functions, but Perl's 'regular expressions' give you a simple language to search for patterns, extract patterns from strings, and even change text that matches your patterns. This is invaluable for all manner of text manipulation, including validation, text replacement, and string testing. With the advent of SAS 9, the power of Perl's regular expressions is now available in the `DATA STEP`.	prxparse, sas 9
16	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
17	Reading and Writing XML Files from SAS	Peter J. Lund	XML (eXtensible Markup Language) is gaining popularity as a medium for data exchange. SAS Institute has added additional support recently for reading and writing XML files under both 8.2 and 9.1. The purpose of this workshop is to provide a quick introduction to XML, show the ways in which XML is read and written from SAS, and then present hands-on examples for reading in and mapping XML files to SAS datasets and writing out SAS datasets to XML files.	dataset, proc step, proc print, proc contents, clinical trial, key, libname engine, character variable, foreign key, sysdate9, raw data
18	SAS Add-In for Microsoft Office - Leveraging SAS Throughout the Organization from Microsoft Office	Jennifer Bradshaw Clegg	The SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in to Microsoft `EXCEL` and Microsoft Word. The SAS Add-In for Microsoft Office seamlessly exposes the power of SAS data access, reporting, and analytics directly from the familiar environment of Microsoft Office. This paper discusses the capabilities and features of the SAS Add-In for Microsoft Office 1.3. Refer to Appendix A for a list of features by release	excel, sas enterprise guide, sas management console, business intelligence, proc sql, life sciences	15
19	SAS Programming for Job Security: Tips and Techniques Revisited	Arthur L. Carpenter	A great deal has been said about programming techniques for efficiency and maintainability of SAS programs. We are taught to write code that minimizes machine and programmer resources. Unfortunately, easily maintained code requires fewer programmers, and fewer programmers means pink slips and less job security. In these troubled times, programmers need to be able to maximize their indispensability. Programmers can increase their job security and thereby protect themselves and their families by applying the tips and techniques discussed within this paper. The programmer will be advised when to apply the techniques, and whether the use of the techniques should be subtle or gross. Techniques will cover programming style, editing style, statements to use and avoid, and naming conventions. You will learn to blur data steps, make non-assigning assignment statements, and in general write code that not even you will be able to figure out how or why it works	job security, proc step, options statement, macro definition, macro put, proc sql, set statement, by group processing, proc sort, macro variable, macro quoting function, %if-%then-%else	10
20	SAS Tools to Aid in Application Development	Peter J. Lund	Writing code, organizing output, managing datasets--all these things and more go into development of a successful application. SAS provides a wonderful environment to develop code, but there are times when the Enhanced Editor or SAS Explorer just isn't enough to develop your application in the most efficient manner. This paper presents some tips and tricks for simplifying development tasks. Some are user-written macros to aid in code development, data management, and process tracking. Some are little known or little used SAS tools. The goal of the paper is not intended to go into line-by-line detail on all these tips, but to inspire you to think of ways to improve your own processes. I feel kind of cheated if I make it through a whole project without acquiring a new utility macro to add to my toolbox. I hope this paper leaves you looking at your work in the same way	sas log, macro variable, macro put, proc step	9
21	SAS with Style: Creating your own ODS Style Template for RTF Output	Lauren E. Haworth	Once you've started using the Output Delivery System, you'll quickly discover that your taste in output design probably doesn't coincide with the built in `ODS` styles shipped with SAS software. To create output with more panache, you need to create your own style template. This workshop will take you step by step through the process of creating a custom style for your output. You'll learn how to make minor modifications, and how to give your output a complete makeover. If you'd like all of your SAS output to be in hot pink on an acid green background with a gigantic script font, this workshop will show you how! Or, if you'd just like to make the output smaller and use colors that coordinate with your company logo, you can do that too. The workshop will walk through the `TEMPLATE` procedure, showing how you can redefine the default style elements and attributes to customize fonts, colors, and borders to suit your own personal or corporate style. You'll be given a basic style template that you can customize during the workshop and then take home to try out on your `ODS` output. The workshop is aimed at beginning to intermediate `ODS` users, and is based on SAS version 8.	sample, proc step, proc template, output delivery system, ods html, proc freq	10
22	Storing and Using a List of SAS Macro Variables	Arthur L. Carpenter	When using the macro language it is not at all unusual to need to manipulate a list of values. These may be a list of variables in a data set or even a list of data set names. This list is often stored in a macro variable where one macro variable is used to store the entire list. Usually this list is then used one item at a time. The macro variable that contains this list of values can be created in a number of different ways including through the use of the `DATA STEP` or `PROC SQL`. Once created, the user will often want to step through the list performing one or more operations on each of the elements in the list, and this is often accomplished using a combination of the %DO statement and the %SCAN function. This paper shows how to write a series of values to a macro variable and then how to take advantage of the list by utilizing it from within the macro language	macro variable, macro loop, proc sql, character functions, macro function, proc step, macro facility, do loop, call symput, symbol table, macro definition	6
23	Tips and Techniques for Large Files	Andrew H. Karp	Presentation	proc step, proc rank, sample, dataset, character variable, numeric variable, drop statement	37
24	Using the SAS Add-in for MS Office	Mark E. Thompson	Presentation		7
25	Working with SAS Date and Time Functions	Andrew H. Karp	Presentation	sysdate9, sysdate, datetime variable, datepart, date variable, proc step, time series analysis	70

Back to Conf go 2005 go 1998

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.