Home
Contact
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI
SAS:SUGI papers
SAS:VIEWS 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.

Valid XHTML 1.0 Transitional

Google
  Search results
NESUG proceedings: Coders' Corner, 527 papers

Northeast SAS Users Group 2013   September 8-11, 2013 - Burlington, Vermont

Quick Tips (Coders' Corner and more)

tweet!  Debugging SAS ® code in a macro
  Bruce Gilsen, Federal Reserve Board
Keywords:  macro 
Pages: 5 Size: 19 Kb 

tweet!  I'm Going to Pop Some Tags: Using SAS® CALL SOUND Routines
  Richard Dirmyer, Rochester Institute of Technology
Pages: 4 Size: 325 Kb 

tweet!  Raw Deal: Dealing With Unpredictable Record Length and Content When Importing Raw Text Data
  Dan Bretheim, Towers Watson
Pages: 14 Size: 121 Kb 

tweet!  How to Handle Binomial Proportion with Zero Frequency
  Tulin Shekar, Merck
Pages: 11 Size: 518 Kb 

tweet!  Using SAS® ODS Tagsets to Create Non-SAS User Friendly Reports
  Stuart Summers, Alliant
Pages: 10 Size: 521 Kb 

tweet!  Add a Little Magic to Your Joins
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords:  SAS  SQL  PROC SQL  SQL procedure  join  joins  join algorithm  step-loop  sort-merge  index  hash  sas trainer  sas training  sql trainer  sql training  sas consultant  sas consulting  sql consultant  sql consulting  sas san diego  sql san diego  sas california  sql california  sas author  sql author  sas programmer  sql programmer  sas expert  sql expert  sas specialist  sql specialist  Lafler  Kirk Lafler  Kirk Paul Lafler  @sasNerd 
Pages: 6 Size: 385 Kb 

tweet!  OUT= is on the way out. Use ODS OUTPUT instead
  Stanley Fogleman, Harvard Clinical Research Institute
Keywords:  ODS  Data  Step 
Pages: 4 Size: 112 Kb 

tweet!  Dealing with Duplicates
  Christopher Bost, MDRC
Pages: 6 Size: 766 Kb 

tweet!  Bring it in and turn it around and around: Importing multiple excel sheets into SAS® Performing a simple double transpose
  Hezekiah Bunde, Educational Testing Service
Pages: 10 Size: 122 Kb 

tweet!  Picturing Your Character Variables with PROC FORMAT and SAS® 9.3
  Brice Hart, Westat
Pages: 5 Size: 94 Kb 

tweet!  Working with Excel spreadsheets using the SAS/ACCESS® LIBNAME statement
  Gwen Babcock, New York State Department of Health
Keywords:  NESUG  SAS  Excel  LIBNAME  ACCESS  import  export 
Pages: 6 Size: 1825 Kb    Download the codedownload (19 Kb)

tweet!  I Can SQL Clearly Now, the Data's Fine...
  Brian Taaffe, Westat
Keywords:  SQL 
Pages: 16 Size: 517 Kb 

tweet!  Removing Dummy Records From A Directory Of Datasets
  David Franklin, TheProgrammersCabin.com
Keywords:  REMOVE  RECORDS 
Pages: 3 Size: 120 Kb 

tweet!  SQL Metadata Applications: I Hate Typing
  Hannah Fresques, MDRC
Keywords:  SQL 
Pages: 6 Size: 178 Kb 

tweet!  Hash Table Look-up: Easier than you'd think.
  Virginia Blum, Harris IT Services
Pages: 9 Size: 313 Kb 

tweet!  Does the cat have your tongue? Using VNAME and CATX to get SAS to speak to you.
  Gayle Springer, JHU BSPH
Pages: 4 Size: 238 Kb 

tweet!  The Smarts of Using Dummies
  Patricia Meholick, Roswell Park Cancer Institute
Pages: 4 Size: 180 Kb 

tweet!  Practical Solutions for Pagination, Indention, and Mixed-Text Alignment in ODS RTF Word Documents
  Hui Song, PRA International
Pages: 7 Size: 349 Kb 

tweet!  PROC SQL Pass-Through Log
  Adeline Wilcox, Department of Veterans Affairs
Keywords:  SQL 
Pages: 4 Size: 72 Kb 

tweet!  So your data is on multiple servers? No worries, SAS can help.
  David Lawrence, Comcast
Pages: 4 Size: 683 Kb 

tweet!  How to indent selected table cells using NBSPACE
  Roberta Glass, Abt Associates
Pages: 5 Size: 314 Kb 

tweet!  Need a little SAS help or a knowledge boost? There's a URL for that.
  David Lawrence, Comcast
Pages: 3 Size: 435 Kb 


Northeast SAS Users Group 2012   November 11-14, 2012 - Baltimore, Maryland

Coders' Corner

tweet!  Kick It Old School - Creating Reports with the DATA _NULL_ Step
  Sai Ma, PharmaNet/i3; Suwen Li, Everest Clinical Research Services Inc.; Minlan Li, Everest Clinical Research Services Inc.
Keywords:  DATA _NULL_  AE  Study Comments  PROC REPORT 
Pages: 10 Size: 126 Kb 

tweet!  Not Dividing by Zero: Last of the Low-Hanging Efficiency Fruit
  Bruce Gilsen, Federal Reserve Board
Pages: 4 Size: 35 Kb 

tweet!  With a Trace: Making Procedural Output and ODS Output Objects Work For You
  Louise Hadden, Abt Associates Inc.
Pages: 11 Size: 641 Kb    Download the codedownload (5 Kb)

tweet!  Penetrating the Matrix
  Justin Smith, U.S. Census Bureau; William Zupko, U.S. Census Bureau
Pages: 11 Size: 180 Kb 

tweet!  Exploring the PROC SQL _METHOD Option
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords:  SAS  PROC SQL  SQL  SQL procedure  _METHOD  _METHOD option  Log messages  Lafler  Kirk Lafler  Kirk Paul Lafler  sasNerd 
Pages: 3 Size: 190 Kb 

tweet!  Checking Out Your Dates with SAS®
  Christopher Bost, MDRC
Pages: 6 Size: 99 Kb 

tweet!  Writing Flexible SAS® Codes: Exploring the Value of Global Macro Variables, Conditional Statements, and %SYSFUNC
  Victoria Porterfield, Rutgers University
Keywords:  macro 
Pages: 10 Size: 528 Kb 

tweet!  Accessing SAS® Code via Visual Basic for Applications
  Jennifer Davies, Z, Inc
Pages: 5 Size: 75 Kb 

tweet!  A Practical Application of PROC GPLOT and PROC GCHART and Annotate to Clinical Trial Data
  Tulin Shekar, Merck & Co., Inc.
Keywords:  clinical 
Pages: 7 Size: 61 Kb 

tweet!  Checking for Duplicates
  Wendi Wright, CTB McGraw-Hill
Pages: 5 Size: 56 Kb 

tweet!  Using PROC FCMP to Solve Rolling Regression Rapidly
  Chao Huang, Oklahoma State University; Liang Xie
Pages: 4 Size: 435 Kb 

tweet!  Using SAS® to E-Mail Reports and Results to Users
  Stuart Summers, Alliant, LLC
Pages: 5 Size: 210 Kb 

tweet!  Using PROC SQL and the SAS® Macro Facility to Blind Formatted Dates on a Group of Datasets within a Single Directory
  Diana Ventura, Harvard University
Keywords:  SQL  Efficiency  Base  Benchmark  macro 
Pages: 5 Size: 138 Kb 

tweet!  Store and Manage Routinely Extracted Observations: A Practical Application
  Si Gao, State University of New York - Albany; Xin Li, State University of New York - Albany
Pages: 6 Size: 225 Kb 

tweet!  Create User-Defined Formats: Using SAS® Code to Write Code
  Yonghong Shang, Westat
Pages: 11 Size: 300 Kb 

tweet!  Correcting for Natural Time Lag Bias among Non-Participants in Pre-Post Intervention Evaluation Studies
  Gandhi Bhattarai, United Health Group
Pages: 5 Size: 49 Kb 

tweet!  The SAS® System Generates Code for You While Using File IMPORT and EXPORT Procedures
  Anjan Matlapudi, Amerihealth
Pages: 6 Size: 275 Kb 

tweet!  Careful Use of Input Delimiters
  Howard Schreier, Howles Informatics
Pages: 4 Size: 156 Kb 

tweet!  Managing SAS® Dates with Irregular Granularity
  Howard Schreier, Howles Informatics
Pages: 10 Size: 202 Kb 

tweet!  You Have SASMAIL!
  Rajbir Chadha, Cognizant Technology Solutions
Pages: 8 Size: 636 Kb 

tweet!  Multitasking with Nested Formats
  Jonathan Kerman, Johns Hopkins Bloomberg School of Public Health
Pages: 5 Size: 62 Kb 

tweet!  A Macro to Squeeze SAS® Data and Create a SAS Transport File
  Hany Aboutaleb, Biogen Idec
Keywords:  macro 
Pages: 11 Size: 444 Kb 

tweet!  Mimicking the DATA Step Dash and Double Dash in PROC SQL
  Arlene Amodeo, Law School Admission Council
Keywords:  SQL 
Pages: 24 Size: 1114 Kb 

tweet!  Using SAS® to Control the Postprocessing of MS Documents
  Nat Wooding, J. Sargeant Reynolds Community College
Pages: 8 Size: 425 Kb 

tweet!  Yes, No, Maybe So: Tips and Tricks for Using 0/1 Binary Variables
  Laurie Hamilton, Healthcare Management Solutions LLC
Pages: 6 Size: 418 Kb 

tweet!  %ASSERT Your Way to Sleep-Filled Nights: A One-Line Macro for Data Validation
  Quentin McMullen, Siemens Healthcare
Keywords:  macro 
Pages: 8 Size: 61 Kb 

tweet!  Calculating Questionnaire Scores Made Easy in SAS®
  Qin Lin, ACI, LLC
Pages: 9 Size: 65 Kb 

tweet!  Analyze and Manage Your Output with PROC MEANS
  Si Gao, State University of New York - Albany; Xin Li, State University of New York - Albany
Pages: 6 Size: 387 Kb 

tweet!  Fun with PROC SQL
  Darryl Putnam, CACI, Inc.
Keywords:  SQL 
Pages: 6 Size: 113 Kb 

tweet!  Summing Data with the SUM Function in SAS®
  Anjan Matlapudi, AmeriHealth; Daniel Knapp, AmeriHealth
Pages: 11 Size: 118 Kb 

tweet!  Sorting a Large Data Set When Space is Limited
  Selvaratnam Sridharma, U.S. Census Bureau
Pages: 4 Size: 158 Kb 

tweet!  Bring Excel Files with Multiple Sheets to SAS®
  Mindy Wang, Marriott International
Pages: 7 Size: 1352 Kb 

tweet!  Seek and Ye Shall FINDC: A Powerful Function for Qualitative Data Validation
  Xiaoke Yang, State University of New York - Albany; Peter Landi, New York State Office of Mental Health
Pages: 7 Size: 96 Kb 

tweet!  Using PROC TCALIS to Investigate Equality of Covariance Matrices across Two Groups
  Chen Li, Educational Testing Service; Steven Holtzman, Educational Testing Service
Pages: 5 Size: 162 Kb 

tweet!  Combining Continuous Events and Calculating Duration in Kaplan-Meier Analysis Using a Single DATA Step
  Hui Song, PRA International Inc.; George Laskaris, PRA International Inc.
Pages: 8 Size: 305 Kb 


Northeast SAS Users Group 2011   September 11-14, 2011 - Portland, Maine

Coders' Corner

tweet!  A Validation Macro to Check Compliance of CDISC SDTM Data
  Hany Aboutaleb, Biogen Idec
Keywords:  macro 
Pages: 13 Size: 375 Kb 

tweet!  Survival Analysis: K-M Plot with Confidence Band
  Santosh Bari, eClinical Solution; Himanshu Patel, eClinical Solution
Pages: 9 Size: 270 Kb 

tweet!  Viva la Resolucion! 5 Things You Should Know About Macro Resolution
  Dan Bretheim, Towers Watson
Keywords:  macro 
Pages: 8 Size: 316 Kb 

tweet!  Hands Free: Automating Variable Name Re-Naming Prior to Export
  John J. Cohen, Advanced Data Concepts LLC
Pages: 5 Size: 381 Kb 

tweet!  Generation Why: How Generation Data Sets Can Help
  Lisa Eckler, Lisa Eckler Consulting
Pages: 7 Size: 137 Kb 

tweet!  A Utility to Validate the LoT
  Mukesh Garg, eClinical Solutions; David Etris, Ockham; Vikash Jain, eClinical Solutions
Pages: 4 Size: 83 Kb 

tweet!  Tales from the Help Desk 5: Yet More Solutions for Common SAS® Mistakes
  Bruce Gilsen, Federal Reserve Board
Pages: 8 Size: 48 Kb 

tweet!  PROC PRESENT: Write Your Presentation in SAS® in as Few as Five Easy Steps
  Louise S. Hadden, Abt Associates Inc.
Pages: 6 Size: 239 Kb    Download the codedownload (1898 Kb)

tweet!  Put a Little Zip in Your SAS® Program
  Louise S. Hadden, Abt Associates Inc.
Pages: 6 Size: 311 Kb 

tweet!  10 Steps to Easier SAS Code Maintenance
  Jessica R. Hampton, CIGNA
Pages: 9 Size: 172 Kb 

tweet!  Easy DOS It.
  Asaf Hanish, University of Pennsylvania
Pages: 7 Size: 109 Kb 

tweet!  Get Started Writing SAS® Macros
  Luisa M. Hartman, Merck Sharp & Dohme Corp.; Jane Liao, Merck Sharp & Dohme Corp.
Keywords:  macro 
Pages: 12 Size: 176 Kb 

tweet!  A Practical and Efficient Approach in Generating AE (Adverse Events) Reports Within a Clinical Study Environment
  Jiannan Hu, Vertex
Keywords:  clinical 
Pages: 8 Size: 73 Kb 

tweet!  A Missing Guide for a Comprehensive Kaplan-Meier Plot
  Jiannan Hu, Vertex
Pages: 7 Size: 133 Kb 

tweet!  Using PRX to Search and Replace Patterns in SAS® Programming
  Wenyu Hu, Merck Sharp & Dohme Corp.; Liping Zhang, Merck Sharp & Dohme Corp.
Pages: 6 Size: 52 Kb 

tweet!  Combining the Results from Multiple SAS PROCs into a Publication Quality Table
  Robert Kabacoff, Management Research Group
Pages: 20 Size: 298 Kb 

tweet!  Reading Multiple Sheets from Excel Using SAS
  Sandeep Kottam, Ockham; Sree Lakshmi K Tripuraneni, PURDUE PHARMA
Pages: 5 Size: 188 Kb 

tweet!  What's on Your Menu?
  Sanjaya Kumar, New York State Department of Health
Pages: 9 Size: 372 Kb 

tweet!  An Animated Guide: A Program to Read Information in SAS Headers and Produce Reports for Programming Managers
  Russ M. Lavery, Independent Contractor
Pages: 20 Size: 600 Kb 

tweet!  A SAS® Macro for Transposing Large Datasets
  Chen LI, ETS
Keywords:  macro 
Pages: 4 Size: 736 Kb 

tweet!  Creating PDF Reports Using Output Delivery System
  Shubha Manjunath, Dotcom team; Shirish Nalavade, Dotcom team
Keywords:  ods 
Pages: 5 Size: 151 Kb 

tweet!  A Way to Work with Invoice Flat Files in SAS
  Anjan Matlapudi, AmeriHealth; J. Daniel Knapp, AmeriHealth
Pages: 6 Size: 73 Kb 

tweet!  Tips to Use Character String Functions in Record Lookup
  Anjan Matlapudi, AmeriHealth
Pages: 12 Size: 97 Kb 

tweet!  Periodicity Via the SAS Iterative Loop
  Joel P. McMullin, Maine Medical Center
Pages: 6 Size: 426 Kb 

tweet!  Measuring Medication Persistence Using SAS Stamina
  Mark J. MIhalyo, Community Care Behavioral Health Organization
Pages: 7 Size: 538 Kb 

tweet!  Introduction to PK/PD Data Structures and Process Optimization to Get Analysis-Ready Data
  Smitha Mullapudi, Independent Contractor
Pages: 4 Size: 353 Kb 

tweet!  Looping Through the Unknown
  Rebecca I. Piegari, Department of Veterans Affairs
Pages: 4 Size: 132 Kb 

tweet!  SAS Procedures as UNIX Commands
  Sriharsha Rachabattula, Covance Inc.
Pages: 7 Size: 162 Kb 

tweet!  Missing Categories from Categorical Summary Report? PRELOADFMT Comes to Your Rescue
  Sapan M. Raval, Independent; Niraj J. Pandya, Element Technologies Inc.
Pages: 6 Size: 161 Kb 

tweet!  The Colorful ODS
  Ali Sabouri, Healthcare
Pages: 5 Size: 77 Kb 

tweet!  Join or Merge? The Differences Between PROC SQL goin and Data Step Merge and When to Use Them.
  Ted Shelly, Pinnacle Project Group LLC
Keywords:  SQL 
Pages: 7 Size: 53 Kb 

tweet!  The Beginnings of Creating a Civil Partnership Between SAS and Excel
  Kathleen M. Siemborski, Educational Testing Service
Pages: 6 Size: 260 Kb 

tweet!  Zebras Wanted. Using ODS Tagsets and PROC REPORT to Create a Striped Spreadsheet
  Gayle K. Springer, Johns Hopkins University Bloomberg School of Public Health
Pages: 8 Size: 120 Kb 

tweet!  Life in the FASTCLUS: A Data-Driven Approach to Classifying Time Intervals
  Jedediah J. Teres, MDRC
Pages: 4 Size: 170 Kb 

tweet!  Intelligent PROC SORT NODUPKEY
  Andrea Wainwright-Zimmerman, Capital One
Pages: 4 Size: 72 Kb 

tweet!  How to Keep Multiple Formats in One Variable After Transpose
  Mindy Wang, CDM Group
Pages: 9 Size: 1193 Kb 

tweet!  A Practical Method to Generate Desirable Group Sizes by Performing Adaptive Randomization
  Feifei Yang, University of Pennsylvania
Pages: 5 Size: 223 Kb 

tweet!  A Macro for Safely Merging Many Datasets
  Taylor R. Young, The Broad Institute
Keywords:  macro 
Pages: 5 Size: 111 Kb 

tweet!  How to Color Your Report?
  Xuefeng Yu, Celgene Corporate
Pages: 8 Size: 229 Kb 

tweet!  An Animated Look at the Westward Movement of the US Population Center
  Mike Zdeb, University at Albany School of Public Health
Pages: 8 Size: 339 Kb    Download the codedownload (3 Kb)

tweet!  Repeating Statistics Tables - Building A Macro that Dynamically Organizes and Formats
  Wayne (Weizhen) Zhong, Octagon Research Solutions
Keywords:  macro 
Pages: 6 Size: 642 Kb 


Northeast SAS Users Group 2010   November 14-17, 2010 - Baltimore, Maryland

Coders' Corner

tweet!  Drivers Wanted: Zipping and Moving Along through SAS®
  Marie Byrd Alexander, Westat; Sharon Avrunin-Becker, Westat
Pages: 6 Size: 286 Kb    Download the codedownload (1 Kb)

tweet!  Happy Birthday! But... How Old Are You, Really?
  Elizabeth Axelrod, Abt Associates Inc.
Pages: 6 Size: 70 Kb 

tweet!  Variable List Shortcuts in PROC SQL
  Ken Borowiak, PPD, Inc.
Keywords:  SQL 
Pages: 4 Size: 426 Kb 

tweet!  To FREQ, Perchance to MEANS
  Christopher J. Bost, MDRC
Pages: 11 Size: 46 Kb 

tweet!  Put Off By Writing Tedious PUT Statements? Automate It! Let SAS® Do It For You.
  Dan Bretheim, Towers Watson
Pages: 11 Size: 398 Kb 

tweet!  Normalizing SAS Datasets Using User Defined Formats
  David D. Chapman, US CENSUS BUREAU
Pages: 7 Size: 38 Kb 

tweet!  Table Lookups: Getting Started With Proc Format
  John J. Cohen
Pages: 5 Size: 503 Kb 

tweet!  Automation of LOG CHECKING: What to check and why?
  Sridhar R. Dodlapati, i3 Statprobe; Kiran K. Karidi, Novartis Oncology; Mahipal R. Vanam, EMD Serono, Inc.
Pages: 5 Size: 54 Kb 

tweet!  Monitoring Dataset Quality Using Proc Format and A Reference File
  Hanadi Eltahir, US Census Bureau
Pages: 3 Size: 49 Kb 

tweet!  Using Fillable PDF together with SAS for Questionnaire Data
  Donald Evans, IRS
Pages: 9 Size: 263 Kb 

tweet!  Using %SYMEXIST for eliminating repetitive words in a SAS macro string - no data steps, no procedures.
  Alexander Feigin, Alex Feigin,Inc.
Keywords:  macro 
Pages: 6 Size: 143 Kb 

tweet!  Let SAS® Write and Execute Your Data-Driven SAS Code
  Kathy H. Fraeman, UnitedBiosource Corporation
Pages: 5 Size: 53 Kb 

tweet!  Making an RTF file Out of a Text File, With a Single Datastep
  David Franklin, Independent SAS Consultant
Keywords:  SAS  RTF  macro 
Pages: 3 Size: 110 Kb 

tweet!  PROC PRESENT: Write Your Presentation in SAS in as Few as Five Easy Steps
  Louise S. Hadden, Abt Associates Inc.
Pages: 6 Size: 364 Kb 

tweet!  Ordering PROC FREQ around
  Jonathan Kerman, Johns Hopkins University
Pages: 9 Size: 147 Kb 

tweet!  An Animated guide: Suggestions for coding standards
  Russ M. Lavery, Self
Pages: 24 Size: 360 Kb 

tweet!  An Exercise Using PROC SURVEYREG and NYC HANES: Examining Social Support as a Predictor of Body Mass Index in New York City
  Jackie Lee, Columbia University
Pages: 6 Size: 209 Kb    Download the codedownload (654 Kb)

tweet!  Creating Trellis Graph Using SAS
  Jane X. Liao, Merck & CO., Inc
Pages: 9 Size: 287 Kb 

tweet!  Get Connected - Attach To Your Data Sources Using SAS/ACCESS
  Laura G. Liotus, Community Care Behavioral Health
Pages: 9 Size: 348 Kb 

tweet!  Challenge! Reading Mainframe Hex Delimited Flat File Where Each Line Has Different Layout
  Anjan Matlapudi, PerformRx; James D. Knapp, PerformRx
Pages: 7 Size: 58 Kb    Download the codedownload (4 Kb)

tweet!  Please Don't Lag Behind LAG !
  Anjan Matlapudi, PerformRx; James D. Knapp, PerformRx
Pages: 12 Size: 110 Kb 

tweet!  Impact Analysis - The Smart Way
  George G. Mendoza, CIGNA Corporation
Pages: 6 Size: 38 Kb 

tweet!  Modifying Datasets and Documenting Changes in SAS
  GIRISH K. NARAYANDAS, Health Dialog Inc.
Pages: 7 Size: 98 Kb 

tweet!  By Your Command: Executing Windows DLLs in SAS Enterprise Guide
  Darryl Putnam, CACI, Inc.
Pages: 7 Size: 52 Kb 

tweet!  The Tips and Tricks: Using Greek Font and Hexadecimal code to get Special Characters in SAS/Graph Output in RTF
  Amos Shu, INC Research, Inc.
Pages: 5 Size: 124 Kb 

tweet!  Using SAS/GRAPH® Annotate and ODS to Create Customized Control Charts
  Sailesh Vezzu, Educational Testing Service
Pages: 5 Size: 211 Kb 

tweet!  # or ## - how to reference SQL server temporary tables
  Xiaoqiang Wang, University of Pittsburgh
Keywords:  SQL 
Pages: 8 Size: 158 Kb 

tweet!  Make it robust and easier to maintain
  Mindy Wang, The CDM Group
Pages: 8 Size: 1688 Kb 

tweet!  Macros and Conventional Macro Variables: Effective Tools for Customizing Tabular Output in SAS® ODS
  Perry Watts, Independent Consultant
Keywords:  macro 
Pages: 7 Size: 89 Kb    Download the codedownload (10 Kb)

tweet!  Are We There Yet?
  Nat Wooding, Dominion
Pages: 3 Size: 64 Kb 

tweet!  Know What You Are Missing: How to Catalogue and Manage Missing Pieces of Historical Data
  Shankar Yaddanapudi, Paradigm Infotech
Pages: 5 Size: 130 Kb 

tweet!  Passing date ranges to Oracle® made simple using SAS® picture formats
  Santosh Kothamasu, Presenter; Jonas V. Bilenas
Pages: 3 Size: 107 Kb 

tweet!  A side of Hash for you to dig into
  Shan Rasul, indigo books and music inc
Pages: 7 Size: 221 Kb    Download the codedownload (1 Kb)

tweet!  Table Lookup in SAS
  Weili Yang, Merck; Fang Chen, Merck; Liping Zhang, Merck; Wenyu Hu, Merck
Pages: 7 Size: 55 Kb 

tweet!  Expanding PROC EXPAND
  Bruce F. Gilsen, Federal Reserve Board
Pages: 4 Size: 20 Kb 

tweet!  Using Data Set Labels and Format Descriptions to Simplify Application Debugging
  Rob Russell, The Hartford
Pages: 9 Size: 122 Kb 


Northeast SAS Users Group 2009   September 13-16, 2009 - Burlington, Vermont

Coders' Corner

tweet!  PROC CALENDAR: Get organized using SAS®!
  Murphy Choy, Quatrro Risk Management; Matthew Komos, Quatrro Risk Management
Pages: 4 Size: 52 Kb 

tweet!  Improve Your Dating: The INTNX Function Alignment Value SAMEDAY
  Bruce F. Gilsen, Federal Reserve Board
Pages: 2 Size: 19 Kb 

tweet!  A Secure Automated FTP Process to Transfer Data from a Remote Server
  Shankar Yaddanapudi, Paradigm Infotech
Pages: 6 Size: 156 Kb 

tweet!  Crossing the environment chasm - better queries between SAS and DB2
  Mark Sanderson, CIGNA
Pages: 6 Size: 150 Kb 

tweet!  Getting the IN operator to FUNCTION inside a SAS® Macro
  Perry Watts, Independent Consultant
Keywords:  macro 
Pages: 5 Size: 57 Kb    Download the codedownload (2 Kb)

Without Typing, Without Typos
  Lei Sun, Merck & Co., Inc.


tweet!  Using SAS® Software and Visual Basic for Application to Automatically Produce Customized RTF Tables from SAS® List Files
  Zemin Zeng, Forest Research Institute, Inc., Mei Li, ImClone Systems
Pages: 6 Size: 199 Kb 

tweet!  Techniques for Labeling SAS® Variables
  Paulette W. Staum, Paul Waldron Consulting
Pages: 6 Size: 295 Kb 

tweet!  Using Systask to Dynamically Create Libname Statements
  Ray Cloutier, Health Dialog
Pages: 3 Size: 104 Kb 

tweet!  Automating Comparison of Multiple Datasets
  Sandeep Kottam, Remx IT staffing
Pages: 5 Size: 255 Kb 

tweet!  Proper Housekeeping – Developing the perfect “Maid” to Clean your SAS® Environment
  Chuck Bininger, Comsys
Pages: 4 Size: 22 Kb 

tweet!  A PROC SQL+Data Step Alternative to the Hash Object for Creating Multiple, Data-Driven Data Sets
  Mike S. Zdeb, U@Albany School of Public Health
Keywords:  SQL 
Pages: 6 Size: 161 Kb 

tweet!  Deciding if the EM Algorithm is the Right Choice
  Michael B. Moldoff, US Census Bureau
Pages: 3 Size: 137 Kb 

tweet!  A Utility Program for Quickly Identifying LOG Error or Warning Messages
  Zhengyi Fang, Social & Scientific Systems, Inc. Paul Gorrell, Social & Scientific Systems, Inc.
Pages: 5 Size: 348 Kb 

tweet!  Magic Spells with SAS®
  Christopher J. Bost, MDRC
Pages: 5 Size: 103 Kb 

tweet!  Choosing the Right Technique to Merge Large Data Sets Efficiently
  Qingfeng Liang, Community Care Behavioral Health Organization
Pages: 9 Size: 99 Kb 

tweet!  A Closer Look at PROC SQL's Feedback Option
  Ken Borowiak, PPD, Inc.
Keywords:  PROC SQL  feedback  select *  natural joins  macro variables  operator mnemonics 
Pages: 7 Size: 103 Kb 

tweet!  How Proc Freq Can Help You Merge
  Emmy Pahmer, MDS Pharma Services
Pages: 5 Size: 50 Kb    Download the codedownload (2 Kb)

tweet!  Taming the Box Plot
  Sanjiv Ramalingam, Octagon Research Solutions Inc.
Pages: 7 Size: 268 Kb 

tweet!  Using SQL Joins to Perform Weighted Matches on Multiple Identifiers
  Jedediah Teres, MDRC
Keywords:  SQL 
Pages: 8 Size: 131 Kb 

tweet!  Using HASH to find a sum over a transactional path
  Richard A. DeVenezia, Independent Consultant
Keywords:  Hash  HIter  Transaction  Linked List 
Pages: 5 Size: 141 Kb 

tweet!  Automating SAS® Macros: Run SAS® Code when the Data is Available and a Target Date Reached.
  Nitin Gupta, Tailwind Associates
Keywords:  macro 
Pages: 6 Size: 290 Kb 

tweet!  More Than One Way To Age A Cat
  Lloyd Butler, Health Dialog
Pages: 7 Size: 47 Kb 

tweet!  Dealing with Blanks: Leading, Trailing, In-Between
  Virginia Chen, ERS Group
Pages: 6 Size: 162 Kb 

tweet!  Techniques to Perform the Lead Function Through Data Manipulation
  Kruti Pandya, Independent Consultant Niraj J. Pandya, Independent Consultant
Pages: 6 Size: 65 Kb 

tweet!  Some Simple Perl Regular Expressions Examples in SAS® 9
  Selvaratnam Sridharma, Census Bureau
Pages: 5 Size: 50 Kb 

tweet!  Dropping Automatically Variables with Only Missing Values
  Selvaratnam Sridharma, Census Bureau
Pages: 6 Size: 50 Kb 

tweet!  Tips of Using Proc Report For Summary Tables And Listings
  Jenny H. Zhang, ICON Clinical Research
Pages: 6 Size: 36 Kb 

tweet!  This is the Modern World: Simple, Overlooked SAS® Enhancements
  Bruce F. Gilsen, Federal Reserve Board
Pages: 10 Size: 40 Kb 


Northeast SAS Users Group 2008   September 14-17, 2008 - Pittsburgh, Pennsylvania

Coders' Corner

tweet!  Avoiding Common Traps When Accessing RDBMS Data
  Mike Rhoads, Westat
Pages: 11 Size: 246 Kb 

tweet!  Customize SAS® Output Files Using SAS Output Delivery System
  Li Liu, Merck & Co., Inc.; Junjie Lu, Merck & Co., Inc.
Keywords:  ods 
Pages: 7 Size: 380 Kb 

tweet!  The Mighty Macro That Will Change How You Macro
  Marie Byrd Alexander, Westat; Sharon Avrunin-Becker, Westat
Keywords:  macro 
Pages: 3 Size: 143 Kb 

tweet!  Wandering Cross Reference Lines in PROC GPLOT
  Sharon Avrunin-Becker, Westat; Marie Byrd Alexander, Westat
Pages: 8 Size: 254 Kb 

tweet!  Tricks to Quickly Analyze and Graphically Represent Numeric Data
  Anastasiya M. Osborne, Farm Service Agency
Pages: 9 Size: 249 Kb 

tweet!  Address Cleaning Using the TRANWRD Function
  Rena Jones, NYS Dept. of Health Center for Environmental Health; Mike S. Zdeb, U@Albany School of Public Health
Pages: 4 Size: 102 Kb 

tweet!  Using Proc SQL to Run SAS Procedures on a Group of Datasets within a Single Directory
  Diana Ventura, Harvard University School of Public Health
Keywords:  SQL  Efficiency  Base  Benchmark 
Pages: 4 Size: 54 Kb 

tweet!  Constructing a System for Tracking Revenue Generated from Dissimilar Projects
  Roger S. Cohen, New York State Tax Department; Paul Bastian, New York State
Pages: 6 Size: 46 Kb 

tweet!  Purrfectly Fabulous Feline Functions
  Louise S. Hadden, Abt Associates Inc.
Pages: 11 Size: 156 Kb 

Creating Longitudinal Master Data After Renaming Variables with SAS(R) Macro and Loop
  Ja K. Gu, CDC/NIOSH
Keywords:  macro 


tweet!  Holy Emacs, Batchman!
  Sara Hickson, Channing Laboratory
Pages: 6 Size: 1525 Kb 

tweet!  Multiple Facts about Multilabel Formats
  Gwen D. Babcock, New York State Department of Health
Pages: 8 Size: 81 Kb 

tweet!  The History of How, Who, Which, What, Where – Utilizing the SAS® Trace Module!
  Jerry Alex, The Wharton School
Pages: 16 Size: 827 Kb 

tweet!  Run SAS® Code based on Filename extensions
  Shiva Srinivasan, PJM Interconnection; Shailaja Ramesh, Prosoft Software Inc
Pages: 7 Size: 203 Kb 

tweet!  Benchmarking Tool for Hardware resources
  Sreekanth Middela, MaxisIT; Venkata S. Bhamidipati, Merck & Co., Inc.
Pages: 6 Size: 71 Kb 

tweet!  PC Tips for Mainframers
  Claudine Lougee, Dualenic
Pages: 3 Size: 23 Kb 

tweet!  Table Lookups: Getting Started With Proc Format
  John J. Cohen, AstraZeneca LP
Pages: 5 Size: 31 Kb 

tweet!  Plotting Overall Mean and Individual Values in One Graph
  Jenny H. Zhang, ICON Clinical Research
Pages: 7 Size: 79 Kb 

tweet!  HELP! - My MERGE Statement Has More Than One Data Set With Repeats of BY Values!
  Andrew T. Kuligowski, The Nielsen Company
Pages: 5 Size: 66 Kb 

NESUG-L, Live answers to your questions
  Kenneth W. Borowiak, PPD, Inc.; Paul M. Dorfman, Red Buffalo, Inc.; Peter Eberhardt, Fernwood Consulting Group Inc; Kirk P. Lafler, Software Intelligence Corporation



Northeast SAS Users Group 2007   November 11-14, 2007 - Baltimore, Maryland

Coders' Corner

tweet!  Jazz Up Those Boring Reports by Using Nontraditional Fonts
  Sharon Avrunin-Becker, Westat; Marie Byrd Alexander, Westat
Pages: 5 Size: 110 Kb 

tweet!  Put Down That Mouse!
  Daniel Boisvert, Genzyme
Pages: 6 Size: 1499 Kb 

tweet!  Visualizing PROC TRANSPOSE
  Daniel Boisvert, Genzyme; Shafi Chowdhury, Shafi Consultancy Ltd.
Pages: 6 Size: 171 Kb 

tweet!  Additional Metadata for Common Catalog Entry Types
  Kenneth Borowiak, PPD, Inc.
Pages: 5 Size: 113 Kb 

tweet!  Sensitivity Training for PRXers
  Kenneth Borowiak, PPD, Inc.
Pages: 7 Size: 130 Kb 

tweet!  Automatically Renaming Common Variables Before Merging
  Christopher Bost, MDRC
Pages: 7 Size: 124 Kb 

tweet!  Getting Something from Nothing: How to Produce a PROC TABULATE Table with All Zeros
  Marie Byrd Alexander, Westat; Sharon Avrunin-Becker, Westat
Keywords:  tabulate 
Pages: 6 Size: 161 Kb 

tweet!  Search and Replace in SAS® Data Sets Through GUI
  Edmond Cheng, Bureau of Labor Statistics
Pages: 6 Size: 81 Kb 

tweet!  Exporting Access Databases with Indexes and Keys
  Roger Cohen, New York State Tax Department
Pages: 5 Size: 43 Kb 

tweet!  Matching %DO-%END Pairs - A Macro Debugging Technique
  Zizhong Fan, MedImmune, Inc.
Keywords:  macro 
Pages: 5 Size: 1253 Kb 

tweet!  FreqLibname: A Data Review Routine for All Memnames in a Libname
  Ronald Fehd, Centers for Disease Control
Keywords:  call execute  data review  dynamic programming  includes  list processing  nrstr  routines  source2  subroutines 
Pages: 22 Size: 191 Kb 

tweet!  Writing Testing-Aware Programs That Self-Report when Testing Options Are True
  Ronald Fehd, Centers for Disease Control
Keywords:  call execute  echoauto  macro  module  mprint  options  parameterized include file  routine  source2  subroutine  testing  verbose 
Pages: 20 Size: 182 Kb 

tweet!  Dealing with Duplicates: Identify, Investigate and Purge
  Ying Feng, CTB/McGraw-Hill
Pages: 4 Size: 53 Kb 

tweet!  Controlling SAS Datasets Using SAS® System and Dataset Options
  David Franklin, Independent Consultant
Keywords:  audit trail  dataset versions  dataset control 
Pages: 7 Size: 57 Kb 

tweet!  Data Without (Step) Boundaries
  Felix Galbis-Reig, GWU Biostatistics Center
Pages: 7 Size: 77 Kb 

tweet!  Comparing Values Across Observations: Be Careful
  Prafulla Girase, Pharmetrics, a unit of IMS
Pages: 4 Size: 83 Kb 

tweet!  SAS Dates, the Basics
  Steven Gorin, Pitney Bowes
Pages: 7 Size: 57 Kb 

tweet!  The Great Escape(char)
  Louise Hadden, Abt Associates Inc.
Pages: 14 Size: 1231 Kb 

tweet!  Great Expectations of PROC FORMAT - Applications All You Can Do with Formats in the SAS® System
  John He, Octagon Research; Ram Valluru, Octagon Research
Pages: 8 Size: 187 Kb 

tweet!  Working with Missing Values
  Edward Heaton, Westat; Michelle Zhuang, Westat
Pages: 3 Size: 52 Kb 

tweet!  Performing Iterative Processes with the Macro Facility
  Katie Joseph, US Office of Personnel Management; Taylor Lewis, US Office of Personnel Management
Keywords:  macro 
Pages: 5 Size: 44 Kb 

tweet!  Swap the DATA Step for PROC TRANSPOSE
  Katie Joseph, US Office of Personnel Management
Pages: 5 Size: 38 Kb 

tweet!  PROC SQL - A Powerful Tool in SAS
  Swetha Kongara, PVR Technologies Inc; Raja Panchumarthi, Smith Hanley Consulting Group Inc
Keywords:  SQL 
Pages: 9 Size: 2135 Kb 

tweet!  PROC SQL and Arrays: The Powerhouse Behind Data Processing
  Meera Kumar, Sanofi-Aventis
Keywords:  SQL  array 
Pages: 3 Size: 45 Kb 

tweet!  Tips and Tricks in Creating Graphs Using PROC GPLOT
  Qin Lin, Applied Clinical Intelligence, LLC
Pages: 7 Size: 179 Kb 

tweet!  Using Macro and ODS to Overcome Limitations of SAS® Procedures
  Wei (Lisa) Lin, Merck & Co., Inc.; Jing Su, Merck & Co., Inc.
Keywords:  macro 
Pages: 7 Size: 1552 Kb 

tweet!  Using the SAS® Data Step and PROC SQL to Create Macro Arrays
  Stuart Long, Westat; Edward Heaton, Westat
Keywords:  SQL  macro  array 
Pages: 11 Size: 166 Kb 

tweet!  Adding Ruby to Your SAS® Toolbox
  Daniel Olguin, First Coast Service Options
Pages: 7 Size: 203 Kb 

tweet!  Writing SAS® Code in Excel®
  Emmy Pahmer, MDS Pharma Services
Pages: 4 Size: 78 Kb 

tweet!  ODS, An Introduction to Creating Output Data Sets
  Elisabeth Pyle, Merck & Co., Inc.
Pages: 7 Size: 60 Kb 

tweet!  Does Your Application Have a Performance Problem? Put It in a SAS® Pipe and Smoke It! (An Introduction to SAS Pipes)
  Rob Russell, The Hartford
Pages: 11 Size: 144 Kb 

tweet!  Measuring Days and Hours: An Introduction to the Handy Uses of the IN, END, LAG, FIRST and LAST Statements
  Catherine Schmitt, Bureau of the Census
Pages: 9 Size: 2107 Kb    Download the codedownload (9 Kb)

tweet!  Conditional Lags Don't Have to Be Treacherous
  Howard Schreier, Howles Informatics
Pages: 10 Size: 73 Kb 

tweet!  Handling Non-Date Dates in SAS®
  Gary Seale, Federal Housing Finance Board; Anna Watson, Federal Housing Finance Board
Pages: 4 Size: 900 Kb 

tweet!  A SAS Macro to Automate the Process of Pooling Sites
  Changhong Shi, Merck & Co., Inc.; Lili Chen, Merck & Co., Inc.
Keywords:  macro 
Pages: 6 Size: 102 Kb 

tweet!  Tabbing Through ODS
  Haibin Shu, Duramed Research, Inc
Pages: 4 Size: 229 Kb 

tweet!  An RTF Document Index: Easier Than You Think
  Electra Small, MDRC
Pages: 10 Size: 138 Kb 

tweet!  Creating Multiple Cohorts Using the SAS® Data Step
  Jonathan Steinberg, Educational Testing Service
Pages: 9 Size: 116 Kb 

tweet!  Take Control of Your Output: Discover Dynamic Data Exchange
  Matthew Taylor, Bank of America
Pages: 7 Size: 52 Kb 

tweet!  Differences in ODS formatting for HTML with PROC PRINT and PROC REPORT
  Laura Thornton, USDA-ARS, AIPL
Keywords:  html 
Pages: 5 Size: 56 Kb 

tweet!  %DO Loop - A Simple Dynamic Programming Technique
  Yunchao (Susan) Tian, Social & Scientific Systems, Inc.
Pages: 4 Size: 70 Kb 

tweet!  The Power and the Trap of Automatic Retain
  Yunchao (Susan) Tian, Social & Scientific Systems, Inc.
Pages: 6 Size: 76 Kb 

tweet!  PROC EXPAND to the Rescue!
  Premal Vora, Penn State - Harrisburg
Pages: 5 Size: 31 Kb 

tweet!  Benefits of Using Excel File in CDISC SDTM Data Mapping
  Hong Wang, Clinforce LLC
Pages: 8 Size: 615 Kb 

tweet!  Adding One Value to All Records in a SAS® Data Set
  Anne Warren, MDRC
Pages: 6 Size: 77 Kb 

tweet!  Identify and Remove Any Variables, Character or Numeric, That Have Only Missing Values
  Wei Xu, Boston Scientific
Pages: 3 Size: 45 Kb 

tweet!  Importance of WARNING and NOTE Messages from SAS® Log
  Jyotheeswara Yellanki, Independent Consultant
Pages: 5 Size: 1124 Kb 


Northeast SAS Users Group 2006   September 17-20, 2006 - Philadelphia, Pennsylvania

Coders' Corner

tweet!  Working outside the SAS® Box: Calling Other Applications from within SAS
  James Zeitler, Harvard Business School
Pages: 4 Size: 50 Kb 

tweet!  Urban Legends and SAS
  Stanley Fogleman, Harvard Clinical Research Institute
Pages: 3 Size: 32 Kb 

tweet!  %IFN - A Macro Function
  Chang Chung, Princeton University; Ian Whitlock
Keywords:  macro 
Pages: 6 Size: 65 Kb 

tweet!  Variable List Short-Cuts in PROC SQL
  Kenneth Borowiak, Howard M. Proskin & Associates, Inc.
Keywords:  SQL 
Pages: 4 Size: 67 Kb 

tweet!  Where Did Those Duplicates Come From?
  Kenneth Gold, New York State Department of Tax; Roger Cohen, New York State Department of Tax
Pages: 4 Size: 34 Kb 

tweet!  How Many Keystrokes are Needed to Build this Dataset?
  Roger Cohen, New York State Department of Tax; Kenneth Gold, New York State Department of Tax
Pages: 5 Size: 35 Kb 

tweet!  Simple Techniques to Help Trace Problems in Your Application
  Rob Russell, The Hartford
Pages: 9 Size: 520 Kb 

tweet!  Create a Report Showing Monthly, Quarter-To-Date and Year-To-Date Information
  Rodger Zhang, TD Canada Trust
Pages: 6 Size: 43 Kb 

tweet!  Teaching a New Dog Old Tricks - Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report
  Stanley Fogleman, Harvard Clinical Research Institute
Keywords:  SQL 
Pages: 3 Size: 40 Kb 

tweet!  SAS Data Views Simply Stated
  James Stokes, Dun & Bradstreet
Keywords:  SAS  data  set 
Pages: 3 Size: 28 Kb 

tweet!  %MISSING: A Macro to Report Missing Value Percentages for a Multi-Year Multi-File Information System
  Rushi Patel, Creative Information Technology Inc.
Keywords:  macro 
Pages: 6 Size: 60 Kb 

tweet!  Using SAS to Find Bootstrap Estimates of Field Air Sampling Data
  James Slaven, National Institute for Occupational Safety and Health; David Bartley, National Institute for Occupational Safety and Health; Mike Rose, Department of Labor, Occupational Safety & Health Administration, Salt Lake Technical Center; Martin Harper, National Institute for Occupational Safety and Health; Michael Andrew, National Institute for Occupational Safety and Health
Pages: 4 Size: 53 Kb 

tweet!  Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops
  Ronald Fehd, Centers For Disease Control
Keywords:  data review  dynamic programming  list processing  do loop  macro  SQL 
Pages: 9 Size: 130 Kb 

tweet!  PROC REPORT's Temporary Variable: What is it and Why Do I Care?
  Mike Molter, Howard M Proskin & Associates
Pages: 5 Size: 79 Kb 

tweet!  Taking Out the Garbage
  Adam Lamanna, Howard M. Proskin and Associates, Inc.
Pages: 3 Size: 36 Kb 

tweet!  ISO 8601 - An International Standard for Date and Time Formats
  Shi-Tao Yeh, GlaxoSmithKline
Pages: 5 Size: 80 Kb 

tweet!  Excellent Dating in SAS
  James Zeitler, Harvard Business School
Pages: 3 Size: 34 Kb 

tweet!  Renaming Variables for Source Data Residing Outside of a SAS® Data Set
  Barbara Morse, Anthem Blue Cross - Maine
Pages: 3 Size: 50 Kb 

tweet!  PROC SQL: When and How to Use It?
  Ying Feng, Educational Testing Services
Keywords:  SQL 
Pages: 5 Size: 38 Kb 

tweet!  Handling Dates in the Macro Facility
  Toby Dunn, Eagle Group Int.; Presented by Chang Chung, Princeton University
Keywords:  macro 
Pages: 4 Size: 24 Kb 

tweet!  Identifying Duplicate Values
  Christopher Bost, MDRC
Pages: 8 Size: 99 Kb 

tweet!  Improve Your Dating: The INTNX Function Alignment Value SAMEDAY
  Bruce Gilsen, Federal Reserve Board
Pages: 2 Size: 23 Kb 

tweet!  MIMO: Multiple Inputs Multiple Outputs - Multiplying the Fun while doing the Data Step
  John Fahey, Reproductive Care Program Of Nova Scotia
Pages: 9 Size: 150 Kb 

tweet!  The Invisible Character Alt-255 Hidden Dragon: Hiding And Aligning Text in SAS® Output
  Eugene Tsykalov, Glaxosmithkline; Shi-Tao Yeh, GlaxoSmithKline
Keywords:  Alt-255  Alt255  SAS Output  Invisible Character  Hidden Dragon  Proc Report  ODS  PDF 
Pages: 8 Size: 131 Kb 

tweet!  DBCompare: A Powerful Tool to Compare Data Definitions of Datasets Across Multiple Databases
  Balakrishna Dandamudi, SFBC International
Pages: 8 Size: 120 Kb 

tweet!  Programmatically Comparing Data Libraries
  Stephen Hamburg, Omnicare Clinical Research
Pages: 3 Size: 30 Kb 

tweet!  Any WAY you Want it: Getting the Right TYPEs of Observations Out of PROC SUMMARY or MEANS
  Christianna Williams, University Of North Carolina At Chapel Hill
Pages: 7 Size: 101 Kb 

tweet!  Those Sneaky SAS Functions: Beware of Unexpected Handling of Missing Data and Variable Lists
  Christianna Williams, University Of North Carolina At Chapel Hill
Pages: 4 Size: 73 Kb 

tweet!  LAG - the Very Powerful and Easily Misused SAS Function
  Yunchao (Susan) Tian, Social & Scientific Systems
Pages: 5 Size: 43 Kb 

tweet!  Using PROC CDISC
  Chauthi Nguyen, GlaxoSmithkline
Pages: 5 Size: 147 Kb 


Northeast SAS Users Group 2005   September 11-14, 2005 - Portland, Maine

Coders' Corner

tweet!  Improve Your Dating: The INTNX Function Alignment Value SAMEDAY
  Bruce Gilsen, Federal Reserve Board
Pages: 2 Size: 124 Kb 

tweet!  A SAS® Macro to Standardize Graphics
  Swarna Ramanjulu, sanofi aventis
Keywords:  macro 
Pages: 4 Size: 56 Kb 

tweet!  Fast and Easy Ways to Check Your Work: Using PROC MEANS to Confirm Continuous Variable Categorizations
  Rick Mitchell, Westat
Pages: 2 Size: 79 Kb 

tweet!  SYMPLIFY Your Data Set Transposition with SYMPUT and Make It Data-Driven Too!
  Christianna Williams, University Of North Carolina At Chapel Hill
Pages: 3 Size: 76 Kb 

tweet!  Dude, Where's My Zero? Using DDE to Read Microsoft Excel Files Containing Leading Zeros
  Kevin Dietz, U.S. Government Accountability Office
Pages: 2 Size: 110 Kb 

tweet!  Literally Minded: the Use of SAS Literals and Why They Are Still Felevant!
  Stanley Fogleman, Harvard Clinical Research Institute
Pages: 4 Size: 43 Kb 

tweet!  Using XML Mapper to Create An XML Map
  Shi-Tao Yeh, GlaxoSmithKline
Keywords:  xml 
Pages: 10 Size: 674 Kb 

tweet!  Simple Methods to Pull the Diagonal out of a Correlation Matrix.
  Laura Thornton, USDA-ARS-AIPL
Pages: 2 Size: 54 Kb 

tweet!  Long to Wide Transformation---A More Flexible Approach Using SAS/IML
  Liang Xie, State University of New York at Binghamton
Pages: 8 Size: 102 Kb 

tweet!  A Quick Look at Change in a Longitudinal Study
  Virginia Towle, Yale University
Pages: 3 Size: 73 Kb 

tweet!  Performing Macro Iteration on Consecutive Lines of a Dataset Using Proc SQL
  Syloke Soong, Allegro Microsystems
Keywords:  SQL  macro 
Pages: 5 Size: 153 Kb 

tweet!  Traffic Lighting: Easier Than You Think
  Michael Davis, Aetna Integrated Informatics
Pages: 4 Size: 162 Kb 

tweet!  Right Time Right Place: An Application of Arrays
  Len Zangwill, Advanta Corp.
Keywords:  array 
Pages: 5 Size: 175 Kb 

tweet!  Setting Uniform Spacing Between Columns for Table/Listings
  Lily Yu, MedImmune, Inc.
Pages: 4 Size: 173 Kb 

tweet!  How to Recognize and Use Calendar Dates.
  Melvin Tooker, USDA-ARS-AIPL
Pages: 2 Size: 36 Kb 

tweet!  Mainframe Files On Your Windows Desktop with SAS/CONNECT®
  Michael Sadof, MGS Associates, Inc.
Pages: 5 Size: 129 Kb    Download the codedownload (8 Kb)

tweet!  In Search of the LOST CARD
  Andrew Kuligowski, Nielsen Media Research
Pages: 9 Size: 294 Kb 

tweet!  Reading a File of Questionable Lineage
  James Zeitler, Harvard Business School
Pages: 6 Size: 92 Kb 

tweet!  SAS/Connect Simply Stated
  James Stokes, D&B
Pages: 2 Size: 93 Kb 

tweet!  Question: How do I find out what _TYPE_ is from my PROC MEANS?Answer: the FINDTYPE macro
  Dan Bruns, Tennessee Valley Authority
Keywords:  macro 
Pages: 4 Size: 34 Kb 

tweet!  HIRE POWER
  Neil Howard, Neil Howard Inc.
Pages: 11 Size: 136 Kb 

tweet!  A SAS Programmer's Guide to Project - and Program-Level Quality Control
  Paul Gorrell, Social & Scientific Sytems, Inc
Pages: 15 Size: 97 Kb 

tweet!  An Animated Guide: Hashing in V9.1
  Russell Lavery, Independent Consultant
Pages: 13 Size: 145 Kb 

tweet!  Creating Zillions of Labels (and Other Documents) the Easy Way with ODS and Microsoft® Word
  Vincent DelGobbo, SAS Institute
Pages: 5 Size: 140 Kb 


Northeast SAS Users Group 2003   September 7-10, 2003 - Washington, District of Columbia

Coders' Corner

tweet!  Drawing Multiple Random Samples with Replacement
  Charles DePascale, Center For Assessment
Pages: 2 Size: 104 Kb 

tweet!  Interleaving a Dataset with Itself: How and Why
  Howard Schreier, U.S. Dept. Of Commerce
Pages: 6 Size: 122 Kb 

tweet!  A Simple and Efficient Approach to the Cross-tabulation of Large SAS® Data Sets
  Robert Sands, Census Bureau; Mark E. Asiala, Census Bureau
Pages: 2 Size: 81 Kb 

tweet!  Create All Those Tables and Call PROC SQL Once!
  Stanley Fogleman, Harvard Clinical Research Institute
Keywords:  SQL 
Pages: 2 Size: 112 Kb 

tweet!  Automating SAS Data Management Tasks
  Catherine Buffington, Census Bureau
Pages: 2 Size: 27 Kb 

tweet!  Logicals From Libraries: Using Storage as a Bridge Between Sessions
  Gary Schlegelmilch, Census Bureau
Pages: 2 Size: 22 Kb 

tweet!  Falling in Love with PROC DATASETS
  Mary McDonald, UBS Painewebber
Pages: 2 Size: 26 Kb 

tweet!  Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets
  Steve Feder, Federal Reserve Board
Keywords:  SQL 
Pages: 5 Size: 82 Kb 

tweet!  What to Wear on a Date' A Short Discussion of SAS Date Functions, Formats and Informats
  Louise Hadden, Abt Associates Inc.
Pages: 3 Size: 132 Kb 

tweet!  Creepy Characters
  Elizabeth Axelrod, Abt Associates Inc.
Pages: 2 Size: 158 Kb 

tweet!  Changing that Pesky Datetime to a Date
  Stanley Fogleman, Harvard Clinical Research Institute
Pages: 2 Size: 114 Kb 

tweet!  Matching Character Variables by Sound: A closer look at SOUNDEX function and Sounds-Like Operator (=*)
  Zizhong Fan, Westat
Pages: 3 Size: 168 Kb 

tweet!  The Best of Cheesy, Sleazy SAS' Tricks
  Michael Davis, Bassett Consulting Services
Pages: 2 Size: 29 Kb 

tweet!  %ARRAY: Construction and Usage of Arrays of Macro Variables
  Ronald Fehd, Centers For Disease Control
Keywords:  macro  array 
Pages: 3 Size: 57 Kb    Download the codedownload (12 Kb)

tweet!  A Few Macro Techniques to Shorten Your Programs
  Yunchao (Susan) Tian, Social & Scientific Systems
Keywords:  macro 
Pages: 2 Size: 98 Kb 


Northeast SAS Users Group 2002   September 29 - October 2, 2002 - Buffalo, New York

Coders' Corner

tweet!  Creepy Characters
  Elizabeth Axelrod
Pages: 2 Size: 39 Kb 

tweet!  Don't Resort to Re-Sort
  Elizabeth Axelrod
Pages: 2 Size: 22 Kb 

tweet!  The Sparse Option in PROC FREQ: Little Known, Yet Powerful
  Chris Moriak
Pages: 2 Size: 25 Kb 

tweet!  Where to Put "WHERE"'
  Hongwei Zhang
Pages: 2 Size: 154 Kb 

tweet!  Splitting a Large Data Set
  Selvaratnam Sridharma
Pages: 1 Size: 10 Kb 

tweet!  Merging Multiple Observation Data Sets Together
  Tim Kelly
Pages: 2 Size: 21 Kb 

tweet!  Libname: Start Your Engines
  Janet Stuelpner
Pages: 2 Size: 18 Kb 

tweet!  Identifying Duplicate Key Values
  Roger Staum
Pages: 2 Size: 32 Kb 

tweet!  Using _INFILE_, Substr, Translate, and TranWrd to Manipulate Strings of Text Within the Input Buffer
  Peter Wobus
Pages: 3 Size: 71 Kb 

tweet!  Subsetting SAS® Data Set by Using PROC SQL Self-join with Compound Key
  Zizhong Fan
Keywords:  SQL 
Pages: 2 Size: 25 Kb 

tweet!  Capturing SAS® Macro Code into an Executable SAS® Program
  David Jemiolo, Paul Gilbert
Keywords:  macro 
Pages: 2 Size: 29 Kb 

tweet!  %Rtfsymbl - An Easy Solution for Defining Special Symbols in RTF File-Generating SAS® Programs
  Liping Zhang, Eric Qi, Weifeng Xu
Pages: 2 Size: 32 Kb 

tweet!  SAS® and the Security of Confidential Data
  Lori Maiwald
Pages: 2 Size: 137 Kb 

tweet!  Get With the Validation Program - Successful Steps to Edit Check Failures
  Michael Rea
Pages: 2 Size: 32 Kb 

tweet!  Web-Ready Reports of Student Ratings
  Suzanne Cross
Keywords:  internet 
Pages: 2 Size: 46 Kb 

tweet!  Tips for Reading and Writing Delimited Files
  Michael Sadof
Pages: 2 Size: 167 Kb 


Northeast SAS Users Group 2001   September 30 - October 3, 2001 - Baltimore, Maryland

Coders' Corner

tweet!  Graphing Them Together: Overlaying Plots with Macros and SAS/GRAPH®
  Lawrence Altmayer
Keywords:  macro 
Pages: 2 Size: 501 Kb 

tweet!  A Few Ways to Use Macro Variables, Comparison Operators, and ".other=." Format Statements to Shorten Your Programs
  Scott Burroughs
Keywords:  macro 
Pages: 2 Size: 63 Kb 

tweet!  Using Regular Expressions with SAS®
  Brian Conley, Prevision Marketing, MA
Pages: 2 Size: 76 Kb 

tweet!  Using SAS/CONNECT Software and X Statements to Navigate the Directory Structure of a Remote Server
  Kevin Delaney and Peter Landi
Pages: 2 Size: 42 Kb 

tweet!  Another Simple SAS/AF® Program to Manage SAS/CONNECT® Sessions
  Richard L. Downs, Jr., U.S. Census Bureau, Washington, DC
Keywords:  af 
Pages: 2 Size: 152 Kb 

tweet!  Appendix Numbers: A Macro to Eliminate Hard Coding
  Daphne Ewing
Keywords:  macro 
Pages: 2 Size: 109 Kb 

tweet!  A Macro to Report Problematic SAS Log Messages in a Production Environment
  Tianshu Li and John K. Troxell, Merck & Co., Inc., Rahway, NJ
Keywords:  macro 
Pages: 3 Size: 27 Kb 

tweet!  Control With PROC CONTENTS
  Gary McQuown, Data and Analytic Solutions Inc. Fairfax, Virginia
Pages: 1 Size: 58 Kb 

tweet!  SAS/ACCESS for Excel spreadsheets: A consultant's challenges
  Elizabeth A. Morgenthien, The Quincunx Group, Manlius, NY
Pages: 2 Size: 21 Kb 

tweet!  Two Quick Tips for PROC REPORT: Making a Line above the Headers and the PAGE Option
  Chris Moriak, Boehringer Ingelheim
Pages: 2 Size: 16 Kb 

tweet!  PROC REPORT - Land of the Missing OBS Column.
  Ray Pass, Ray Pass Consulting
Pages: 2 Size: 13 Kb 

tweet!  What We Really Need is a %BY Statement - V2
  Ray Pass, Ray Pass Consulting
Pages: 2 Size: 29 Kb 

tweet!  WHAT'S IN A NAME
  Michael C. Ross, Chevy Chase Bank, Laurel, MD
Pages: 2 Size: 8 Kb 

tweet!  Connecting Simply with SAS/CONNECT® Software
  Michael G. Sadof, MGS Associates, Inc., Bethesda, MD.
Pages: 4 Size: 30 Kb 

tweet!  Processing Dates in Health Care Enrollment Data
  Thiru Satchi
Keywords:  healthcare 
Pages: 3 Size: 169 Kb 

tweet!  Now _INFILE_ is an Automatic Variable - So What?
  Howard Schreier, U.S. Department of Commerce, Washington, DC
Pages: 2 Size: 325 Kb 

tweet!  FTP File Access Method - Leave That File In Place
  Jack Shoemaker, Thotwave Technologies
Pages: 2 Size: 64 Kb 

tweet!  Dynamically Build a PROC FORMAT for Subsetting Large Datasets
  Warren E. Stinson, Director, Analytical Processes, Dun & Bradstreet, Inc.
Pages: 1 Size: 41 Kb 

tweet!  How Do We CNTL It?
  Janet Stuelpner, Citigroup, New York, NY
Pages: 2 Size: 63 Kb 

tweet!  Calculating Age in One Line of Code
  Wei Wang, Highmark Blue Cross Blue Shield, Pittsburgh, PA
Pages: 2 Size: 17 Kb 

tweet!  Defining colors with Precision in your SAS/GRAPH. Application
  Perry Watts, Independent Consultant
Pages: 2 Size: 146 Kb 

tweet!  What User Defined Formats Are Available?
  Ian Whitlock, Westat, Rockville, MD
Pages: 2 Size: 17 Kb 

tweet!  A Simple SAS Macro Technique to Build a Report Data Set
  Christianna S. Williams, Yale University, New Haven, CT
Keywords:  macro 
Pages: 2 Size: 24 Kb 

tweet!  SAS on OS/390 Interacting With USS
  Hsiwei Yu (Michael), Consultant, Gaithersburg, MD and Michael McInerney, Consultant, Centreville, VA
Pages: 2 Size: 18 Kb 

tweet!  Five (or more) alternatives for record selection from one file based on information in another
  Mike S. Zdeb, New York State Department of Health
Pages: 3 Size: 96 Kb 

tweet!  Using animation to add a time dimension to maps
  Mike S. Zdeb, New York State Department of Health
Pages: 4 Size: 112 Kb 

tweet!  An Automated Approach to Create a SAS Macro Program with Formatted Variables and Labels from Table Description Files of a Database
  Hongwei Zhang
Keywords:  macro 
Pages: 2 Size: 127 Kb 


Northeast SAS Users Group 2000   September 24-26, 2000 - Philadelphia, Pennsylvania

Coders' Corner

tweet!  Saving Time with Variable Labels
  Brian Conley
Pages: 2 Size: 12 Kb 

tweet!  An Automated Method to Create a Descriptive Index for a Directory of SAS® Programs
  Gary Cunningham
Pages: 2 Size: 72 Kb 

tweet!  Numeric Data Displays Utilizing Special Characters in PROC REPORT
  Kerry Deem
Pages: 2 Size: 15 Kb 

tweet!  Using PROC DATASETS for Efficient SAS Processing
  Ken Friedman
Pages: 2 Size: 22 Kb 

tweet!  CHOOSING SAS® OPERATORS TO SELECT A RANGE OF VALUES OF A VARIABLE
  Chang Jiang
Pages: 2 Size: 12 Kb 

tweet!  SASHELP: A Backstage Pass
  Tim Kelly
Pages: 2 Size: 20 Kb 

tweet!  Comparing 2 SAS Data Sets: An Alternative to Using PROC COMPARE
  Kevin King
Pages: 2 Size: 19 Kb 

tweet!  Three Ways to Skin a Cat: Many to Many Merges
  Mary McDonald
Pages: 2 Size: 16 Kb 

tweet!  PROC REPORT - Land of the Missing OBS Column
  Ray Pass
Pages: 2 Size: 14 Kb 

tweet!  What We Really Need is a %BY Statement - V2
  Ray Pass
Pages: 2 Size: 13 Kb 

tweet!  SAS EXTRACT MACRO TO CREATE A COMMA DELIMITED FILE FOR MICROSOFT EXCEL97 IMPORT
  Aldona A. Rajecki, Eric E. Kahle
Keywords:  macro 
Pages: 2 Size: 11 Kb 

tweet!  CREATING E-MAIL MESSAGES USING SAS AND PERL SCRIPT
  Cyril Ravindra, John Owusu Djamboe
Pages: 2 Size: 17 Kb 

tweet!  Intelligently Launching Microsoft Excel from SAS, Using SCL Functions Ported to Base SAS
  Chris Roper
Pages: 2 Size: 13 Kb 

tweet!  Using SAS and DDE to Execute VBA Macros in Microsoft Excel
  Chris Roper
Keywords:  macro 
Pages: 2 Size: 16 Kb 

tweet!  Batch Processing with SAS®: Beyond Running Programs Overnight
  Lisa Sanbonmatsu
Pages: 2 Size: 19 Kb 

tweet!  Batch SAS as Shell Script:Command Line and Prompted Variable/Parameter Assignment
  David C. Steven
Pages: 2 Size: 16 Kb 

tweet!  Indexing: My New Best Friend for Table Lookup
  Warren E. Stinson
Pages: 2 Size: 11 Kb 

tweet!  New Ways to Update Old Formats
  Janet E. Stuelpner
Pages: 2 Size: 15 Kb 

tweet!  Create Custom Numeric Formats with the Proc Format Picture Statement
  Vince Timbers
Pages: 2 Size: 17 Kb 

tweet!  USING PROC SQL TO SELECTIVELY COLLAPSE CELLS FOR WEIGHTING PROCESS
  Ann Von Holle
Keywords:  SQL 
Pages: 2 Size: 15 Kb 

tweet!  A Double Transpose
  Ian Whitlock
Pages: 2 Size: 17 Kb 

tweet!  Dictionary Files
  Ian Whitlock
Pages: 2 Size: 16 Kb 

tweet!  SUMMARIZING CENSUS 2000 RACE CHECK BOX COMBINATIONS
  Adeline J. Wilcox
Pages: 2 Size: 13 Kb 

tweet!  WHEN ROUNDING THE RESULT OF A RANDOM NUMBER GENERATOR IS WRONG
  Adeline J. Wilcox
Pages: 2 Size: 11 Kb 

tweet!  A Coding History for Clinical Data
  Phyllis Wolf
Keywords:  clinical 
Pages: 2 Size: 17 Kb 

tweet!  Macro Makes PROC MEANS Flexible
  Kimberly D. Yarbrough
Keywords:  macro 
Pages: 2 Size: 11 Kb 

tweet!  Streamline the Process - A Real Life Example
  Yadong Zhang
Pages: 2 Size: 23 Kb 


Northeast SAS Users Group 1999   October 3-5, 1999 - Washington, District of Columbia

Coders' Corner

tweet!  Dynamically Build a PROC FORMAT for Subsetting Large Datasets
  Warren E. Stinson
Pages: 1 Size: 4 Kb 

tweet!  A Macro to Center Text in a DATA _NULL_ Step
  Erik S. Larsen
Keywords:  macro 
Pages: 2 Size: 12 Kb 

tweet!  What We Really Need is a %BY Statement: V2
  Ray Pass
Pages: 2 Size: 13 Kb 

tweet!  PROC REPORT - Land of the Missing OBS Column
  Ray Pass
Pages: 2 Size: 24 Kb 

tweet!  One Efficient Way to Select Records From a Very Large Flat File or SAS Data Set
  George Bukhbinder
Pages: 2 Size: 13 Kb 

tweet!  Self Adjusting Date Formats
  Marianne Whitlock
Pages: 2 Size: 14 Kb 

tweet!  Three Unrelated Tips That Solve Three Unrelated SAS Problems
  Perry Watts
Pages: 2 Size: 16 Kb 

tweet!  Make Your Own Macro Processor
  Ian Whitlock
Keywords:  macro 
Pages: 2 Size: 13 Kb 

tweet!  An OBS Limit with a WHERE Condition
  Ian Whitlock
Pages: 2 Size: 11 Kb 

tweet!  Shortcuts
  Janet E. Stuelpner
Pages: 2 Size: 10 Kb 

tweet!  "Zooming In" on SAS/GRAPH® Plots Using GREPLAY Templates
  Earl R. Westerlund
Pages: 2 Size: 34 Kb 

tweet!  %manyplot: A Macro for Plotting Many Graphs on a Single Page
  Earl R. Westerlund
Keywords:  macro 
Pages: 2 Size: 11 Kb    Download the codedownload (3 Kb)

tweet!  CREATING MACRO VARIABLES VIA PROC SQL
  Mike S. Zdeb
Keywords:  SQL  macro 
Pages: 2 Size: 7 Kb 

tweet!  Hidden Nuggets in Version 7: New Informats, Formats, and Functions
  Mike Rhoads
Pages: 2 Size: 19 Kb 

tweet!  Using the ID Option in PROC REPORT
  Chris Moriak
Keywords:  PROC REPORT  ID  Report Generation 
Pages: 2 Size: 10 Kb 

tweet!  Seamless Interface to Microsoft Word from SAS Output
  Tim Muir, Wendell Refior
Pages: 2 Size: 13 Kb 

tweet!  Using &SYSBUFFR to Gather User Input
  Michael A. Mace
Pages: 2 Size: 15 Kb 

tweet!  What Sort of Input Should You Input to a Sort?
  Michael A. Raithel
Pages: 2 Size: 13 Kb 

tweet!  Transferring Your Mainframe SAS Programs To Your PC In Three Easy Steps
  Michael A. Raithel
Pages: 2 Size: 18 Kb 

tweet!  Discontented with PROC CONTENTS? Expand it with FMTLIB
  Irene Mendelson
Pages: 2 Size: 13 Kb 

tweet!  Customizing Break Lines When PROC REPORT "Does Not Compute"
  Kerry Deem
Pages: 2 Size: 15 Kb 

tweet!  Getting More For Less: A Few SAS® Programming Efficiency Issues
  Arthur L. Carpenter
Pages: 4 Size: 23 Kb 

tweet!  Dynamic Variable Lists
  Darlene Skarbek, Warren E. Stinson
Pages: 2 Size: 15 Kb 


Northeast SAS Users Group 1998   October 4-6, 1998 - Pittsburgh, Pennsylvania

Coders' Corner

tweet!  Creating a Self-Documenting FORMAT Catalog
  Jack Shoemaker
Pages: 2 Size: 31 Kb 

tweet!  It's Only Temporary
  Janet Stuelpner
Pages: 2 Size: 16 Kb 

tweet!  SAS-L Meets MS Exchange
  Jack Shoemaker
Pages: 1 Size: 13 Kb 

tweet!  Spreadsheet Techniques to Speed SAS Coding - Revisited
  Glen Dalessandra
Pages: 2 Size: 12 Kb 

tweet!  IN & OUT of CNTL with PROC FORMAT
  Nancy Patton
Pages: 2 Size: 13 Kb 

tweet!  What We Really Need is a %BY Statement ;
  Ray Pass
Pages: 2 Size: 9 Kb 

tweet!  Dynamic Variable Lists
  Warren Stinson
Pages: 2 Size: 9 Kb 

tweet!  The Resolve Function - What Is It Good For?
  Ian Whitlock
Pages: 2 Size: 32 Kb 

tweet!  Simplifying Complex Character Comparisons by Using the IN Operator and the Colon (:) Operator Modifier
  Paul Grant
Pages: 2 Size: 16 Kb 

tweet!  The 'SKIP' Statement
  Paul Grant
Pages: 2 Size: 14 Kb 

tweet!  SQL Macro List to Retrieve Data from Large DB2 Databases Using the SAS Pass-Through Facility
  Thiru Satchi
Keywords:  SQL  macro 
Pages: 2 Size: 21 Kb 

tweet!  Panel Discussion (Larsen, DePascale, Ewing, Pass)
  Laresen, Pass, Ewing, DePascale
Pages: 8 Size: 43 Kb 

tweet!  Old Friends, New Features: What's new in SUMMARY and TABULATE
  Robert Ray
Keywords:  tabulate 
Pages: 2 Size: 141 Kb 

tweet!  More about "INTO:Host Variable" in PROC SQL: Examples
  John Zhang
Keywords:  SQL 
Pages: 2 Size: 18 Kb 


Northeast SAS Users Group 1997   October 5-7, 1997 - Baltimore, Maryland

Coders' Corner

tweet!  How to Plot a Line Chart with a Standard Error
  Hany Aboutaleb
Pages: 3 Size: 29 Kb 

tweet!  Using Dynamic Data Exchange Within SAS Software to Directly Access Data From Microsoft Windows Applications
  Ellen Asam
Pages: 2 Size: 18 Kb 

tweet!  Using Compute Blocks to Enhance PROC REPORT Output
  Laurie Buchanan
Pages: 3 Size: 90 Kb 

tweet!  Using Macros to Input and Process Data from 3.5" Diskettes
  Charles DePascale
Keywords:  macro 
Pages: 2 Size: 13 Kb 

tweet!  Generating a Table of Contents for a Format Library
  Craig Dickstein
Pages: 2 Size: 20 Kb 

tweet!  Iterative Code Development: Two Testing Techniques
  Craig Dickstein
Pages: 2 Size: 20 Kb 

tweet!  Getting the Most Out of "INTO" in PROC SQL: An Example for Creating Macro Variables
  Mary-Elizabeth Eddlestone
Keywords:  SQL  macro 
Pages: 2 Size: 20 Kb 

tweet!  There Is No APPEND Option on PROC FORMAT. What Can You Do?
  Lori Goldman
Pages: 2 Size: 17 Kb 

tweet!  The 'SKIP' Statement
  Paul Grant
Pages: 2 Size: 14 Kb 

tweet!  Simplifying Complex Character Comparisons by Using the IN Operator and the Colon (:) Operator Modifier
  Paul Grant
Pages: 2 Size: 21 Kb 

tweet!  A Method for Sorting a Large Data Set with Limited Memory
  Leslie LaBrecque
Pages: 1 Size: 8 Kb 

tweet!  Split Street Address Information Using Do Loop and Array Processing
  Winston Lai
Keywords:  array 
Pages: 2 Size: 17 Kb 

tweet!  Automate the Process of Concatenating Partitioned Data Set Members on MVS®
  Winston Lai
Pages: 2 Size: 20 Kb 

tweet!  Creative Use of SAS Outputs
  Vincent Law
Pages: 3 Size: 21 Kb 

tweet!  Propagating Observations in a Batch Environment
  Michael Marzano
Pages: 2 Size: 14 Kb 

tweet!  Summarizing Data to Assess Patient Compliance With a Protocol
  Sarah McLaughlin
Pages: 3 Size: 18 Kb 

tweet!  Graphically Enhancing Univariate Descriptive Statistics
  James O'Hearn
Pages: 3 Size: 94 Kb 

tweet!  Automatically Generate SAS Data from MS ACCESS Tables
  Alexa Parliyan
Pages: 2 Size: 17 Kb 

tweet!  Word-Wrapping Text Output in SAS Reports
  David Riba
Pages: 2 Size: 12 Kb 

tweet!  A Closer Look At FIRST.var and LAST.var
  Marge Scerbo
Pages: 2 Size: 17 Kb 

tweet!  A Macro for Centralized Ordering, Numbering, and Titling of Tables
  Wayne Schuck
Keywords:  macro 
Pages: 2 Size: 34 Kb 

tweet!  How Old Are You?
  Jack Shoemaker
Pages: 2 Size: 38 Kb 

tweet!  Skipping, The Easy Way
  Janet Stuelpner
Pages: 2 Size: 14 Kb 

tweet!  Search Your LOG Files for Problems the Easy Way: Use LOGCHK.SAS
  Michael Walega
Pages: 2 Size: 17 Kb 

tweet!  Using Unnamed Pipes to Simplify Access to External Files
  John Wenston
Pages: 2 Size: 14 Kb 

tweet!  Why Did this Code Take 22 Hours to Run?
  Ian Whitlock
Pages: 2 Size: 28 Kb 

tweet!  Creating Test Data for an American Community Survey Edit
  Adeline Wilcox
Pages: 2 Size: 17 Kb 

tweet!  Sample SAS Program for Reporting (from Multiple Records)
  Hla Win
Pages: 2 Size: 27 Kb 


Northeast SAS Users Group 1996   October 6-8, 1996 - Boston, Massachusetts

Coders' Corner

tweet!  Transforming Data From Household-Level to Person-Level: PROC TRANSPOSE or DO Loop?
  Mary-Elizabeth Eddlestone, Information Maximizers
Pages: 2 Size: 98 Kb 

tweet!  Using Macros to Recode Sensitive Data
  Mary-Elizabeth Eddlestone, Information Maximizers
Keywords:  macro 
Pages: 2 Size: 98 Kb 

tweet!  Organizing Your SAS Graphs
  Steven Elkin, MBH Consulting, Inc.
Pages: 2 Size: 101 Kb 

tweet!  Using Across Variable in PROC REPORT Procedure
  Min Fu, Trilogy Consulting Corporation
Pages: 3 Size: 142 Kb 

tweet!  Tips on Designing SAS Macros
  Michael Keohan, E-Z Solutions, Inc.
Keywords:  macro 
Pages: 1 Size: 54 Kb 

tweet!  File Subsetting and Modification Using PROC FORMAT
  Allison Levine, Golden Software
Pages: 2 Size: 87 Kb 

tweet!  A Simple Way to Create a Clinical Trial Study Data Dictionary
  Frank Liu, Genzyme Inc.
Keywords:  clinical 
Pages: 3 Size: 127 Kb 

tweet!  Standardizing Output: PROC TRANSPOSE to the Rescue
  Judy Loren, Independent Consultant
Pages: 2 Size: 109 Kb 

tweet!  Creating Hot-Keys for Data Entry in FSEDIT
  Alexa Parilyan, Pfizer Inc.
Pages: 2 Size: 90 Kb 

tweet!  SAS Printout in Chinese
  Lou Chen
Pages: 2 Size: 64 Kb 

tweet!  SAS Printout in Chinese
  Jin Pihuan; Chen Chunwei
Pages: 2 Size: 78 Kb 

tweet!  A Method for Reading Multiple Input Datasets (including dataset names) From a Single Input File
  Danielle Ringstrom, U. S. Bureau of Census
Pages: 2 Size: 85 Kb 

tweet!  To Subset or Not to Subset
  Janet E. Stuelpner, ASG, Inc.
Pages: 2 Size: 97 Kb 

tweet!  Inducing a Break in a Curve in a SAS/GRAPH Plot
  Earl Westerlund, Eastman Kodak Company
Pages: 2 Size: 45 Kb 


Northeast SAS Users Group 1995   October 8-10, 1995 - Washington, District of Columbia

Coder's Corner

tweet!  Creating ASCII Fixed Length Record Files from SAS Data Sets
  Lawrence Altmayer, U. S. Bureau of Census
Pages: 2 Size: 66 Kb 

tweet!  DIFFER: An SCL File Comparison Utility
  James R. Carter, Systems and Computer Technology Corporation
Pages: 4 Size: 199 Kb 

tweet!  Searching High and Low for Similar Observations
  Patricia A. Datte, U. S. Quality Algorithms, Inc.
Pages: 2 Size: 90 Kb 

tweet!  A Creative Way to Read Stored Printed Reports Using the INPUT Statement and PROC TRANSPOSE
  Karen E. Davis, Social Security Adminstration
Pages: 2 Size: 89 Kb 

tweet!  Converting PROC FREQ Output to a Data File
  Charles A. DePascale, Data Analysis & Testing Associates, Inc.; Patricia Cole, Advanced Systems In Measurement & Evaluation, Inc.
Pages: 2 Size: 96 Kb 

tweet!  Interval Training: Fun with Date Functions
  Alan Dickson, ASG, Inc.
Pages: 2 Size: 123 Kb 

tweet!  An Efficient Way to Condense Unbalanced Panel Data
  Andrew J. Epstein, Georgtown University Medical Center
Pages: 2 Size: 103 Kb 

tweet!  Imputing Missing Values to Survey Data: Three SAS Algorithms
  Roald Euller, RAND
Pages: 2 Size: 106 Kb 

tweet!  Appendix Numbers: A Macro to Eliminate Hard Coding
  Daphne E. Ewing, Bio-Pharm Clinical Services, Inc.
Keywords:  macro 
Pages: 2 Size: 87 Kb 

tweet!  A Generalized Method of Finding and Using Program Names
  John J. Genzano, Genzano Software Consulting
Pages: 2 Size: 85 Kb 

tweet!  Creating a Bar Chart with a Moving Line Target Without Using Annotate
  Rick Guest, IBM Microelectronics Division
Pages: 2 Size: 72 Kb 

tweet!  A SAS Macro Introduction to Statistical Quality Control of Longitudinal Data
  Timothy D. Kelly, IMS America
Keywords:  macro 
Pages: 2 Size: 115 Kb 

tweet!  Effective Use of SAS Select Language Statement
  Rick Lockwood, IBM Microelectronics Division
Pages: 2 Size: 66 Kb 

tweet!  Using Indexes for Direct Access to SAS Datasets
  Judy Loren, Independent Consultant
Pages: 2 Size: 121 Kb 

tweet!  VSAM Files Made (Almost) Simple; SAS System Approach
  Mary McDonald, New York City Office of Management and Budget
Pages: 2 Size: 141 Kb 

tweet!  Practical PROC CALENDAR
  Andrew Mosso, New York City Health & Hospitals Corporation
Pages: 2 Size: 109 Kb 

tweet!  Repetitive Data Retrieval from Time-Series Data
  Robert Charles Oshinsky, Resolution Trust Corporation
Pages: 2 Size: 114 Kb 

tweet!  A Macro Which Transposes Data Beyond what PROC TRANSPOSE Can Do
  Yen L. Ouyang, Hoffman-La Roche Inc.
Keywords:  macro 
Pages: 2 Size: 119 Kb 

tweet!  Use of a Date Macro at the Beginning of Programs Rather than Find and Replace in Multipl Locations
  Joseph Pasquale, Carpenter Technology Corporation
Keywords:  macro 
Pages: 1 Size: 55 Kb 

tweet!  Use of a Date Macro Algorithm to Establish a Moving but Fixed Length Date Range
  Joseph Pasquale, Carpenter Technology Corporation
Keywords:  macro 
Pages: 2 Size: 77 Kb 

tweet!  Using Global Macro Variables as a Data Management Tool
  Cynthia A. Stetz, Merrill Lynch
Keywords:  macro 
Pages: 2 Size: 105 Kb 

tweet!  SAS Code Coding SAS
  Warren E. Stinson, Dun & Bradstreet Information Services
Pages: 2 Size: 62 Kb 

tweet!  Dynamically Build a PROC FORMAT for Subsetting Large Datasets
  Warren E. Stinson, Dun & Bradstreet Information Services
Pages: 1 Size: 37 Kb 

tweet!  Using SAS/GRAPH For Data Visualization
  Frank J. Tedesco, E. I. Dupont Company
Pages: 2 Size: 72 Kb 

tweet!  How to Put Almost Anything into a PROC TABULATE Cell
  Michael E. Tomb, Informatics ECS
Keywords:  tabulate 
Pages: 2 Size: 96 Kb 

tweet!  Let The SET Statement Do Your Record Counting For You
  Michael A. Walega, Bio-Pharm Clinical Services, Inc.
Pages: 2 Size: 101 Kb 

tweet!  A Macro That Generates the PROC GLM LSMEANS Table from the LSMEANS Output Data Set
  Michael A. Walega, Bio-Pharm Clinical Services, Inc.
Keywords:  macro 
Pages: 2 Size: 101 Kb 

tweet!  A SAS Documenting Tool
  LeAnn P. Weaver, Fu Associates, Ltd.
Pages: 2 Size: 63 Kb 

tweet!  A Many-to-Many Merge of Recipe Files Using PROC SQL
  Adeline Wilcox, U. S. Department of Agrilculture; Jean A. Fowler, U. S. Department of Agrilculture
Keywords:  SQL 
Pages: 2 Size: 108 Kb 

tweet!  Capitalizing Names With PROC FSVIEW Formulas
  Alan C. Wilson, Robert Wood Johnson Medical School
Pages: 2 Size: 88 Kb 


Northeast SAS Users Group 1994   October 2-4, 1994 - Philadelphia, Pennsylvania

Coder's Corner

tweet!  Assignin a I/O Value to a Variable through Comparisons
  Charles A. DePascale, Advanced Systems In Measurement & Evaluation, Inc.
Pages: 1 Size: 61 Kb 

tweet!  Replacing Records in a Data File with the MERGE Statement
  Charles A. DePascale, Advanced Systems In Measurement & Evaluation, Inc.
Pages: 1 Size: 59 Kb 

tweet!  PROC TRANSPRINT: Sort of
  Ralph W. Leighton, ITT Hartford Insurance Group
Pages: 2 Size: 119 Kb 

tweet!  Seeing Double: How to Compare a SAS Dataset with Itself
  Judy Loren, ASG, Inc.
Pages: 2 Size: 87 Kb 

tweet!  A Font Control Macro for HP Laserjet III Printer
  Frederick Pratter, Abt Associates Inc.
Keywords:  macro 
Pages: 2 Size: 89 Kb 

tweet!  Macros for Creating Delimited Files
  Clinton S. Rickards, Aetna Life and Casualty
Keywords:  macro 
Pages: 2 Size: 103 Kb 

tweet!  Controlling Page Breaks When Using PROC REPORT
  Cynthia A. Stetz, Merrill Lynch
Pages: 2 Size: 90 Kb 

tweet!  Editing Output in the Program Editor
  Bob Virgile, Robert Virgile Associates, Inc.
Pages: 1 Size: 42 Kb 

tweet!  CALL EXECUTE versus CALL SYMPUT
  H. Ian Whitlock, Westat
Pages: 2 Size: 83 Kb 

tweet!  Using the INFILE Option FILEVAR= With Page Controlled Input
  H. Ian Whitlock, Westat
Pages: 2 Size: 87 Kb 

tweet!  Adding BY Group Processing to a SAS/IML Subroutine Library
  Adeline Wilcox, U. S. Department of Agrilculture
Pages: 2 Size: 99 Kb 


Northeast SAS Users Group 1993   November 7-9, 1993 - Springfield, Massachusetts

Coders Corner

tweet!  Replay Your SAS Graphs Into One Template
  Irene Mendelson, Hoffman-La Roche Inc.
Pages: 2 Size: 105 Kb 

tweet!  Rotate A Title to Put Subscripts or Superscripts Into Your Axis Title
  Irene Mendelson, Hoffman-La Roche Inc.
Pages: 2 Size: 78 Kb 

tweet!  Using BY Variable Text Substitution To Add Data Values to SAS/Graph Titles
  Earl R. Westerlund, Eastman Kodak Company
Pages: 2 Size: 63 Kb 

tweet!  Use Origin and Length to Pinpoint And Match Up Multiple Graphs
  Irene Mendelson, Hoffman-La Roche Inc.
Pages: 2 Size: 90 Kb 

tweet!  A Device-Independent Macro To Force The SAS/GRAPH Plotting Area To Be Square
  Earl R. Westerlund, Eastman Kodak Company
Keywords:  macro 
Pages: 2 Size: 64 Kb 

tweet!  Undocumented Features To Test For the Existence of Data Sets
  John Beach, BlueCross BlueShield of Connecticut Inc.
Pages: 2 Size: 113 Kb 

tweet!  Stop The Program, I Want To Get Off!
  Gary Katsanis, Blue Cross and Blue Shield of the Greater Rochester Area
Pages: 1 Size: 53 Kb 

tweet!  Publication Quality Output From the SAS System
  Mary McDonald, New York City Office of Management and Budget
Pages: 2 Size: 137 Kb 

tweet!  Using the REVERSE and SUBSTR Features of SAS
  Jean LaFrance, Financial Information Services Agency
Pages: 2 Size: 67 Kb 

tweet!  Flipping Your List: Using the REVERS Function To Break Up Text Strings
  Lary Jones, Binghamton University
Pages: 2 Size: 92 Kb 

tweet!  The SKIP Statement
  Paul Grant, Private Healthcare Systems, Inc.
Pages: 2 Size: 143 Kb 

tweet!  Calculating Missing Value Counts
  Loren Lidsky, Computer Analytics
Pages: 2 Size: 107 Kb 

tweet!  Iterative Processing Of A Data Set Using Two-Dimensional Arrays
  Charles DePascale, Advanced Systems In Measurement & Evaluation, Inc.; Margaret Rost, Advanced Systems In Measurement & Evaluation, Inc.
Keywords:  array 
Pages: 2 Size: 78 Kb 

tweet!  Counting Responses to Multiple-Choice Questions
  Charles DePascale, Advanced Systems In Measurement & Evaluation, Inc.; Margaret Rost, Advanced Systems In Measurement & Evaluation, Inc.
Pages: 2 Size: 81 Kb 

tweet!  Numeric Variable Validation Using Arrays in SCL
  Marge Scerbo, University of Maryland at Baltimore
Keywords:  array 
Pages: 4 Size: 185 Kb 

tweet!  Three-Way Crosstabulation with PROC FREQ and the OUTPCT Option
  Adeline Wilcox, U. S. Department of Agrilculture
Pages: 2 Size: 91 Kb 

tweet!  A Routine to Convert Missing Numeric Values to Zero
  Paul Grant, Private Healthcare Systems, Inc.
Pages: 1 Size: 57 Kb 

tweet!  SAS Code Coding SAS
  Warren Stinson, Dun & Bradstreet Information Services
Pages: 2 Size: 65 Kb 

tweet!  Dynamically Build a PROC FORMAT for Subsetting Large Datasets
  Warren Stinson, Dun & Bradstreet Information Services
Pages: 1 Size: 39 Kb 

tweet!  Create Formats From Data Sets For Table Look-up
  Mike Davis, BlueCross BlueShield of Connecticut Inc.
Pages: 2 Size: 109 Kb 

tweet!  The WHERE Clause and SCL
  Marge Scerbo, University of Maryland at Baltimore
Pages: 2 Size: 103 Kb 

tweet!  Counting In A PROCE FSEDIT Subset, A Version 6.09 Update
  John Paul Elrod, John Hopkins University
Pages: 2 Size: 121 Kb 


Northeast SAS Users Group 1992   October 4-6, 1992 - Baltimore, Maryland

Coder's Corner

tweet!  Addressing a Problem: A Functional Approach
  Alan Dickson, LL Bean, Inc.
Pages: 2 Size: 94 Kb 

tweet!  Three Methods for Creating One Observation from Multiple Observations
  Adeline Wilcox, VA Cooperative Studies Program
Pages: 2 Size: 88 Kb 

tweet!  Reading Several One-Digit Variables from a Single Field
  Adeline Wilcox, VA Cooperative Studies Program
Pages: 2 Size: 57 Kb 

tweet!  The Virtues of Variable Validation
  Kathryn Acciari, University of Rochester
Pages: 2 Size: 98 Kb 

tweet!  Using the PUT Functions to Recode Variables
  Ronald Cody, Robert Wood Johnson Medical School
Pages: 2 Size: 76 Kb 

tweet!  Creating Numberic Collating Sequences Using the NOBS Data Set Option
  Gary Katsanis, Blue Cross and Blue Shield of the Greater Rochester Area
Pages: 2 Size: 71 Kb 

tweet!  Creating Character Collating Sequences Using the Translate Function
  Gary Katsanis, Blue Cross and Blue Shield of the Greater Rochester Area
Pages: 2 Size: 80 Kb 

tweet!  Using SAS to Create Secondary Merge Files for Wordperfect 5.1
  Charles DePascale, Advanced Systems In Measurement & Evaluation, Inc.; Jim H. Jagielski, Advanced Systems In Measurement & Evaluation, Inc.
Pages: 2 Size: 80 Kb 

tweet!  Using SAS Dataset Options to Improve Efficiency
  Clinton S. Rickards, Aetna Life and Casualty
Pages: 2 Size: 99 Kb 

tweet!  Creating an Animated Progress Bar
  Rick Aster
Pages: 1 Size: 56 Kb 

tweet!  Creating Range Variables & Range Labels for PROC RANK Quantiles
  Rhena Seidman
Pages: 1 Size: 40 Kb 

tweet!  Counting Observations in a PROC FSEDIT Subset
  John Paul Elrod, John Hopkins University
Pages: 2 Size: 176 Kb 

tweet!  Reducing I/O Operations Using PROC TRANSPOSE
  Susan Repole, Atlantic Research Corporation
Pages: 2 Size: 83 Kb 

tweet!  Mapping With SAS/GRAPH
  Christina Herman
Pages: 2 Size: 77 Kb 

tweet!  "Zooming In" on SAS/GRAPH Plots Using Proc GREPLAY Templates
  Earl R. Westerlund, Eastman Kodak Company
Pages: 2 Size: 74 Kb 

tweet!  A Few FORMCHAR= Option Sets for Different Printers
  Earl R. Westerlund, Eastman Kodak Company
Pages: 2 Size: 70 Kb 


Powered by SAS®.
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-2014 Lex Jansen. All rights reserved.