Home
Contact
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PhUSE papers
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI
SAS:SUGI papers
SAS:WUSS papers
SAS:CDISC papers
CDISC Forum
Search SAS-L
Browse SAS-L
Fortune records
Marsh 1001
India
South America
UC time
Virus info
My Links

Powered by SAS® 9.01.01M3P02162005.
Google
  Search results
SAS Conference Proceedings: Western Users of SAS Software 2005
2005-09-21/2005-09-23, San Jose, California
WUSS 2009   WUSS 2008   WUSS 2007   WUSS 2006   WUSS 2005   WUSS 2004   WUSS 2003  

Western Users of SAS Software 2005: Best Papers and honorable mentions

Duration Calculation from a Clinical Programmer’s Perspective
  Alice M. Cheng, Scios Inc., Fremont, CA (Best Contributed Paper in Coders' Corner)
Characterizing Patterns of Longitudinal Data Completeness through Successive Refinement
  Lawrence Rasouliyan and David J. Pasta; Ovation Research Group, San Francisco, California (Best Contributed Paper in Data Analysis and Statistics)
Coding with Compassion – Giving Everyone Access to The Power to Know™
  Jennifer Harper, MSPH, California Dept. of Health Services, Epidemiology and Prevention for Injury Control (EPIC) Branch, Sacramento, CA; Lisa Pappas, SAS Institute, Cary, NC (Best Contributed Paper in Data Presentation)
Exploring DICTIONARY Tables and SASHELP Views
  Kirk Paul Lafler, Software Intelligence Corporation (Best Contributed Paper in Data Warehousing and Database Management)
Deployment of a Data Transfer Application Using PROC SQL and Nested Macros
  Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA (Best Contributed Paper in Posters)
Make ‘em %LOCAL: Avoiding Macro Variable Collisions
  Arthur L. Carpenter; California Occidental Consultants, Oceanside, California (Best Contributed Paper in SAS Solutions)

Coders' Corner
Data Analysis and Statistics
Data Presentation
Data Warehousing and Database Management
Hands-On Workshops
Posters
SAS Essentials
SAS Solutions
Tutorials

Coders' Corner

Comparing the SAS XML Libname Engine with ODS MARKUP in the Creation of XML Files
  Kirk Paul Lafler, Software Intelligence Corporation
Size: 193 Kb Keywords:  XML  XML Libname Engine  ODS MARKUP 

Best Contributed Paper
Duration Calculation from a Clinical Programmer’s Perspective
  Alice M. Cheng, Scios Inc., Fremont, CA
Size: 41 Kb 

Illustrating Concatenation Operations with PROC APPEND
  Kirk Paul Lafler, Software Intelligence Corporation
Size: 16 Kb Keywords:  PROC APPEND  concatenate 

Intelligent SAS® Log Manager
  Paul D Sherman, Western Digital Corporation, Fremont, CA
Size: 136 Kb Keywords:  SAS  Log  Macro  Symbolgen  MLogic  MError 

It's the lines per page that counts
  Jonathan Squire, C2RA, Cambridge, MA; Johnny Tai, Comsys, Portage, MI
Size: 530 Kb 

Just Skip It
  Helen Carey, Carey Consulting, Kane‘ohe, HI
Size: 154 Kb 

Macros to Help Organize and Standardize SAS Projects
  S. Patrick Thornton, SRI International, Menlo Park, CA
Size: 40 Kb Keywords:  macros libname symput 

%MACRO Bag of Tricks
  Rodger Madison, RAND Corporation, Santa Monica, CA
Size: 34 Kb 

MISSING VALUES: Everything You Ever Wanted to Know
  Malachy J. Foley, Chapel Hill, NC
Size: 63 Kb 

Old Fashion but Still Useful: Applications for Running the X Statement to Issue DOS Commands in the Windows Operation System
  Na Li, Pharmacyclics, Sunnyvale, CA
Size: 164 Kb 

Overcome Programming Problems with SAS® Automatic Variable N
  Louie Huang, Baxter BioScience, Westlake Village, California 91362, USA
Size: 275 Kb Keywords:  AUTOMATIC VARIABLE  SAS/GRAPH  ANNOTATION  PROC REPORT  ARRAY  ODS TEMPLATE 

Patient Profile, a Simple Approach
  Sandy Chang, Gilead Sciences, Inc., Foster City, California
Size: 21 Kb 

The General Method for Variable Recoding and Its Applications in SAS
  Randi Chen, Ka-On Fong; Pacific Health Research Institute, Honolulu, Hawaii
Size: 63 Kb 

Sign of the Times: Using SAS® to Produce Conference Signage
  Daniel K. Downing, Caremark, Scottsdale, Ariz.
Size: 48 Kb Keywords:  ODS PDF WATERMARK BACKGROUND 

Understanding WHERE Clause Processing and Indexes
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Size: 207 Kb Keywords:  WHERE Clause  Index 

What's Your _TYPE_? Finding the CLASS You Want In PROC SUMMARY
  Frank Ferriola, Pacioli Companies, Highlands Ranch, CO
Size: 61 Kb 

WHY USE PROC DATASETS
  David Fickbohm, Homegain+, Emeryville, CA
Size: 138 Kb 

Data Analysis and Statistics

A Comparison of Missing Data Handling Methods
  Catherine Truxillo, SAS® Institute Inc, Cary, NC
Size: 216 Kb 

Introducing the GLIMMIX Procedure for Generalized Linear Mixed Models
  Oliver Schabenberger, SAS Institute Inc., Cary, NC
Size: 192 Kb 

SAS/STAT® Version 9: Progressing into the Future
  Maura Stokes, SAS Institute, Cary, NC
Size: 11 Kb 

Analysis of Group-Randomized Designs: A clinic-based breast cancer rescreening example
  Jesse A. Canchola, University of California, San Francisco & California State University, East Bay; Regina Otero-Sabogal, University of California, San Francisco
Size: 61 Kb 

Analyzing Sample Data with the SAS Survey Procs
  David Cassell, Design Pathways, Corvallis, OR
Size: 10 Kb 

A Comparison of Two Procedures to Fit Multi-Level Data: PROC GLM versus PROC MIXED
  MaryAnne DePesquo Hope, Health Services Advisory Group, Phoenix, AZ
Size: 106 Kb Keywords:  GLM  PROC MIXED  Healthcare  Hierarchical data  ICC 

A Macro Mapping Date and Time Variable to CDISC Date and Time Variable
  Song Liu, Brett Sellars, Biogen Idec, San Diego, California
Size: 233 Kb 

A Programmer’s Guide to Statistical Procedures
  Jim Edgington, Gilead Sciences, Inc., Foster City, California
Size: 32 Kb 

Best Contributed Paper
Characterizing Patterns of Longitudinal Data Completeness through Successive Refinement
  Lawrence Rasouliyan and David J. Pasta; Ovation Research Group, San Francisco, California
Size: 53 Kb 

Classification Using Neural Networks: From Human to Machine Learning
  Mable Kong, CSU East Bay, Alameda, CA; Qian (Julia) Zhang, CSU East Bay, Albany, CA
Size: 11 Kb 

Combining Segmentation and Targeting Modeling: A Winning Formula
  Aaron Lai, Howell Kiung, and Oiching Yeung, InfoAtlas, Inc., Oakland, CA
Size: 18 Kb 

Computing Exact Power for Multivariate Repeated Measurements Design
  Jimmy Thomas Efird, Kavitha Alimineti; Biostatistics and Data Management Facility, John A. Burns School of Medicine, Honolulu, HI; Department of Biostatistics and Epidemiology, UCSF School of Medicine, San Francisco, CA
Size: 51 Kb 

Effects of PROC EXPAND Data Interpolation on Time Series Modeling when the Data are Volatile or Complex
  Keiko I. Powers, J. D. Power and Associates, Westlake Village, CA
Size: 148 Kb 

Principal Component Analysis vs. Exploratory Factor Analysis
  Diana D. Suhr, University of Northern Colorado
Size: 106 Kb 

Revisiting the cross-over: A two-period design using a treatment and a placebo
  Qian(Julia) Zhang, California State University, East Bay; Mable Kong, California State University, East Bay
Size: 44 Kb 

Using SAS® to Calculate Arizona Judicial Salaries
  Mark McDermott and Humberto Cisneros, Arizona Supreme Court, Phoenix, AZ
Size: 143 Kb 

Using Statistical Graphics to Understand Your Data (Not Just Present Results)
  David J. Pasta, Ovation Research Group, San Francisco, CA
Size: 36 Kb 

What moves wholesale electricity prices in the Pacific Northwest?
  Aaron Lai and Raymond Wan, InfoAtlas, Inc., Oakland, California
Size: 91 Kb 

Data Presentation

Creating Multi-sheet Excel Workbooks with ODS
  David Kelley, SAS Institute, Cary, NC
Size: 11 Kb 

Introduction to Graphics Using SAS/GRAPH® Software
  Ted Durie, SAS Institute, Cary, NC
Size: 11 Kb 

ODS HTML and CSS
  Ted Durie, SAS Institute, Cary, NC
Size: 11 Kb 

A Peek at PROC DOCUMENT
  Andrew H. Karp, Sierra Information Services, Inc., Sonoma, California USA
Size: 50 Kb 

Better Communication, Analysis and Decisions SAS® plus GIS
  Stephen Trammell, ESRI, Redlands, CA
Size: 432 Kb 

Best Contributed Paper
Coding with Compassion – Giving Everyone Access to The Power to Know™
  Jennifer Harper, MSPH, California Dept. of Health Services, Epidemiology and Prevention for Injury Control (EPIC) Branch, Sacramento, CA; Lisa Pappas, SAS Institute, Cary, NC
Size: 162 Kb Keywords:  508  accessible  accessibility  graph  ods  sas  output  pdf  gaccessible  disability  government  html  w3c  wai  tabulate  report  standards  gch 

Drill down into your SAS data on the web while using XML, javascript and HTML
  Bruce Kayton, San Diego, CA
Size: 82 Kb 

Introduction to SAS maps
  Gur Hoshen, American Institutes for Research, Palo Alto, CA
Size: 77 Kb Keywords:  GMAP SQL 

Unleashing the Power of MULTILABEL Formats
  Andrew H. Karp, Sierra Information Services, Sonoma, CA
Size: 13 Kb 

Using SAS, MySQL, and PHP to Empower End-Users to Generate Dynamic Descriptive and Analytic Statistical Web Reports
  Jeremy Morris, Gary Levy & Ray Dahl; University of Utah, Office of Budget & Institutional Analysis (OBIA)
Size: 140 Kb 

Using SAS® with XML to Create Custom Formatted Excel® Workbooks
  James Van Campen, SRI International, Menlo Park, CA
Size: 53 Kb Keywords:  SAS  Excel  XML 

Data Warehousing and Database Management

Enhancements to the SAS Data Storage Architecture
  Bill Oliver, SAS Institute, Cary, NC
Size: 11 Kb 

Pipeline Parallelism Performance Practicalities
  Michelle Buchecker, SAS Institute, Cary, NC
Size: 11 Kb 

Database-ics A Primer for Creating a Usable Database in SAS®
  Frank Ferriola, Pacioli Companies, Highlands Ranch, CO
Size: 26 Kb 

Best Contributed Paper
Exploring DICTIONARY Tables and SASHELP Views
  Kirk Paul Lafler, Software Intelligence Corporation
Size: 410 Kb Keywords:  Dictionary Tables  SASHELP Views 

Extreme Web Access: What to Do When FILENAME URL Is Not Enough
  Garth Helf, Hitachi Global Storage Technologies, San Jose, CA
Size: 367 Kb 

Looking into Oracle with SAS: Designing a simple SAS Windows interface for an Oracle Database.
  Allison Mercer, CTB/McGraw-Hill, Monterey, California
Size: 205 Kb Keywords:  SAS  Oracle  Database  Windows  Interface 

Producing Multipurpose Metadata for Data Quality, and a Data Dictionary
  John E. Bentley, Wachovia Bank, Charlotte NC
Size: 292 Kb 

The SQL Optimizer Project: _Method and _Tree in SAS®9.1
  Russ Lavery : Contractor for Numeric, LLC
Size: 68 Kb 

The Optimizer Project: WHERE The Statement Is Not The Clause
  Paul D Sherman, San Jose, CA; Russell Lavery, Ardmore, PA
Size: 405 Kb Keywords:  SQL  Query  Database  Beancounting  Data Modeling  Creating Efficient SQL 

Hands-On Workshops

Moving Data and Analytical Results between SAS® and Microsoft Office
  Vincent DelGobbo, SAS Institute Inc., Cary, NC
Size: 2066 Kb 

A Hands-On Tour of the 5 Most Exciting Features Found in PROC SQL
  Kirk Paul Lafler, Software Intelligence Corporation
Size: 56 Kb Keywords:  PROC SQL  queries  case  views  indexes  joins 

Extreme Graphics Make Over: Using SAS/GRAPH® to Get the Graphical Output You Need
  Miriam Cisternas, Ovation Research Group, San Francisco, CA; Art Carpenter, California Occidental Consultants, Oceanside, CA
Size: 235 Kb 

Graphing the Probability of Event as a Function of Time Using Survivor Function Estimates and the SAS® System's PROC PHREG
  Tyler Smith, Besa Smith, Department of Defense Center for Deployment Health Research, Naval Health Research Center, San Diego, CA
Size: 360 Kb Keywords:  survival analysis  Kaplan Meier  Cox Regression  lifetest  phreg 

Introduction to Summary Tables in SAS® Enterprise Guide®
  Lora D. Delwiche, University of California, Davis, CA; Susan J. Slaughter, Avocet Solutions, Davis, CA
Size: 1102 Kb Keywords:  "Summary Tables"  "Enterprise Guide"  "PROC TABULATE"  reports  styles 

PROC REPORT Basics: Getting Started with the Primary Statements
  Arthur L. Carpenter, California Occidental Consultants, Oceanside, California
Size: 71 Kb 

SAS® with Style: Creating your own ODS Style Template for RTF Output
  Lauren Haworth, Genentech, Inc., South San Francisco, CA
Size: 196 Kb 

Version 9 Changes and Enhancements
  Dana Rafiee, Destiny Corporation
Size: 10 Kb 

WHERE vs. IF Statements: Examples in usage and differences
  Sunil Gupta, Gupta Programming
Size: 163 Kb 

Posters

A Journey to Ellis Island: Profiling Historical Immigration Using SAS® and JMP® Time Series Methods
  Archie J. Calise, Queensborough College of the City University of New York; Joseph Earley, Loyola Marymount University, Los Angeles
Size: 149 Kb Keywords:  SAS  JMP  regression  Granger causality 

Can Matrix Capture Missing Data Values?
  Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA
Size: 69 Kb Keywords:  PROC IML  PROC SQL  Macro and Matrix 

Comparing Macros to Arrays to Simple Code for Input Statements: a Visual Display for the Novice Programmer
  Lara Jungvig-Hilton, RAND Corporation, Santa Monica, CA
Size: 76 Kb Keywords:  beginner macro macros array arrays 

Best Contributed Paper
Deployment of a Data Transfer Application Using PROC SQL and Nested Macros
  Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA
Size: 182 Kb Keywords:  Mapping Table  PROC SQL and Nested Macros 

Identify Customers from Multiple Lists Using Fuzzy-Matching Technique
  Raymond Chan, Howell Kiung; InfoAtlas, Inc., Oakland, California
Size: 149 Kb 

Making Your Data File More Versatile for Web Applications
  Maureen Ross, DMDC-West
Size: 104 Kb 

SAS® Application Detects, Quantifies, Prioritizes and Reports Errors in Public Mental Health Data: Impact on Quality of Data Reported
  Bryan Fisher, Christine Beck; California Department of Mental Health, Sacramento, CA
Size: 53 Kb Keywords:  Detect Quantify Prioritize Report Errors 

Summary Tables in SAS® Enterprise Guide® PROC TABULATE Made Easy
  Susan J. Slaughter, Avocet Solutions, Davis, CA; Lora D. Delwiche, University of California, Davis, CA
Size: 542 Kb Keywords:  "Summary Tables"  "Enterprise Guide"  "PROC TABULATE"  reports  styles 

The Use of Formats, Concatenate and Sum for Reporting on “Check All That Apply” Variables
  Lara Jungvig Hilton, RAND Corporation, Santa Monica, CA
Size: 93 Kb Keywords:  beginner format formats concatenate sum 

Using Proc Mixed to Model Daytime Log-Cortisol Slopes
  Eric Neri, Helena Kraemer, Art Noda, Yung Wang, Stanford University School of Medicine, Palo Alto, CA
Size: 28 Kb 

SAS Essentials

Arrays by example
  Diana Suhr, University of Northern Colorado, Greeley, CO
Size: 92 Kb Keywords:  array  subscript  array-elements  _TEMPORARY_  %LET 

Get it together: Combining data with SAS® MERGE, UPDATE, and SET
  Mel Widawski, MHW Consulting, Culver City, CA
Size: 274 Kb Keywords:  MERGE  SET  Combining Data  UPDATE  Table Look-up 

Habits that Help: Developing Good Programming Style
  Casey Cantrell, Clarion Consulting, Los Angeles, CA
Size: 290 Kb 

How SAS® Does Quick Results
  Neil Howard, Independent Consultant
Size: 11 Kb 

SAS® Essentials
  Neil Howard, Basking Ridge, NJ
Size: 100 Kb 

How to Find Answers: Using SAS® Resources
  Ginger Carey, University of Hawai‘i, Honolulu, HI; Helen Carey, Carey Consulting, Kane‘ohe, HI
Size: 772 Kb Keywords:  Resouces  documentation  web sites  help  OnlineDoc  training  SAS-L  books  Users Groups  sample code 

Job Security: Using the SAS® Macro Language to Full Advantage
  Arthur L. Carpenter; California Occidental Consultants, Oceanside, California
Size: 66 Kb 

SAS Solutions

Getting the Best Performance from V9 Threaded PROC SORT
  Scott Mebust, SAS Institute, Cary, NC
Size: 11 Kb 

Migrating to SAS® 9: Impact and Opportunity
  Maria Keyser, SAS Institute, Cary, NC
Size: 13 Kb 

A Regulatory Compliant Process for Developing SAS®-Based Reports
  Chuck Reap, SAS® Institute Inc., Cary NC
Size: 248 Kb 

SAS® 9 BI Tools: Making Your SAS Analytics and Reports Available to Everyone in the Decision-making Process
  Steve Harris, SAS Institute, Cary, NC
Size: 11 Kb 

Anyone Can Learn PROC TABULATE
  Lauren Haworth, Genentech, Inc., South San Francisco, CA
Size: 108 Kb 

A Meeting of the Minds
  Kathryn Valdés, SRI International, Menlo Park, CA
Size: 157 Kb 

Building SAS® Business Intelligence Applications in the Analytic Work Group: Synergistic Benefits
  Christine Beck, Bryan Fisher, Waling-Waling Rosello, Tom Wilson, Department of Mental Health, State of California, Sacramento, CA
Size: 67 Kb Keywords:  Business Intelligence application analysis macro 

Data Collection, Database Management and Reporting in Real-Time based on SAS® and Other Applications
  Beate Danielsen, Health Information Solutions, Rocklin, CA; Barbara Murphy, Stanford University, Palo Alto, CA; Jeffrey B. Gould, Stanford University, Stanford, CA
Size: 1757 Kb Keywords:  SAS/IntrNet  JavaScript  real-time  application server  web server  CPQCC  quality improvement 

Data Integrity through DEFINE.PDF and DEFINE.XML
  Sy Truong, Meta-Xceed, Inc, Fremont, CA
Size: 582 Kb 

Documenting Your Data Using the CONTENTS© Procedure
  Curtis A. Smith, DCAA, La Mirada, CA
Size: 990 Kb Keywords:  CONTENTS LABEL WUSS 2005 

How to Get Promoted: Planning for Career Growth
  Sandra Minjoe, Genentech Inc, South San Francisco, CA
Size: 217 Kb Keywords:  balance  money  preparation  recognition  reward 

Best Contributed Paper
Make ‘em %LOCAL: Avoiding Macro Variable Collisions
  Arthur L. Carpenter; California Occidental Consultants, Oceanside, California
Size: 38 Kb 

Modular Programming using AF/SCL
  Kevin Graham, Montura, San Francisco, California
Size: 149 Kb 

ODS Statistical Graphics for Clinical Research
  Wei Cheng, Isis Pharmaceuticals, Inc., Carlsbad, CA
Size: 263 Kb 

SAS® Certification: Is it for You?
  Sarbjit Rai, Genentech Inc., South San Francisco, CA
Size: 86 Kb 

The Perks of PRX…
  David L. Cassell, Design Pathways, Corvallis, OR
Size: 38 Kb 

To Merge or Not to Merge
  Helen Davis, Kathy Gates, Defense Manpower Data Center, Seaside, CA
Size: 29 Kb 

Transforming Data for CDISC and ISS
  Sy Truong, Meta-Xceed, Inc, Fremont, CA
Size: 577 Kb 

Understand, Document, and Automate Your Programs and Data Tables
  Anthony Dymond, Dymond and Associates, LLC, Concord, CA
Size: 145 Kb Keywords:  metadata  documentation  process model  Service Oriented Architecture (SOA)  Business Process Management (BPM)  Real Time Enteprise (RTE)  Business Activ 

Validating Your SAS Systems
  Sy Truong, Meta-Xceed, Inc, Fremont, CA
Size: 472 Kb 

WHERE vs. IF Statements: Knowing the difference in how and when to apply
  Sunil Gupta, Gupta Programming
Size: 163 Kb 

Tutorials

Customizing ODS Statistical Graphs
  Cynthia Zender, SAS® Institute Inc., Cary, NC; Catherine Truxillo, SAS® Institute Inc., Cary, NC
Size: 583 Kb Keywords:  ODS Graphics Style Graph Template Scatterplot 

200 Reports, 1 Program: An Automated Approach to Creating Graphical Reports with SAS® Software
  Michael J. Yee, The Permanente Medical Group, Inc., Oakland, CA
Size: 577 Kb Keywords:  SAS GRAPH REPORT MACROS AUTOMATED 

An Introduction to SAS Character Functions (Including some new V9 functions)
  Ronald Cody, Ed.D.
Size: 115 Kb 

Enterprise Guide for Business Analysts
  Sunil Gupta, Gupta Programming, Simi Valley, CA
Size: 900 Kb 

Get Going with PROC SQL
  Richard Severino, Convergence CT, Honolulu, HI
Size: 258 Kb 

Improving Your Graphics Using SAS/GRAPH® Annotate Facility
  David J. Pasta, Ovation Research Group, San Francisco, CA; David Mink, Ovation Research Group, San Francisco, CA
Size: 250 Kb 

Introduction to Arrays
  Eric Elkin, University of California, San Francisco, CA
Size: 28 Kb Keywords:  array  tutorial 

Meta Data That You (Probably) Didn’t Know That You Had: A Beginners’ Guide to Using SAS Dictionaries and Automatic Macro Variables
  Richard F. Pless, Ovation Research Group, Highland Park, IL
Size: 60 Kb Keywords:  dictionaries  automatic macro variables 

Tips & Techniques with PROC MEANS
  Andrew H. Karp, Sierra Information Services, Inc., Sonoma, California USA
Size: 61 Kb 

Simple Tests of Hypotheses for the Non-statistician: What They Are and Why They Can Go Bad
  Arthur L. Carpenter, California Occidental Consultants
Size: 84 Kb 

Tips and Techniques for the Windowing Environment
  Mel Widawski, MHW Consulting, Culver City, CA
Size: 325 Kb Keywords:  Customiziing Sas  SAS Display Manager  SAS in Windows 

Using the COMPUTE Block in PROC REPORT
  Jack Hamilton, Kaiser Foundation Health Plan, Oakland, California
Size: 426 Kb 


Powered by SAS® 9.01.01M3P02162005.
SAS® 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.
Copyright © 1999-2010 Lex Jansen. All rights reserved.