Home
Contact
SAS Paper Search
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI papers
SAS:SUGI papers
SAS:VIEWS papers
SAS:WUSS papers
SAS:CDISC papers
Fortune records
Marsh 1001
India
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

Google
  Search results
SAS PharmaSUG proceedings: SQL, 122 papers

Pharmaceutical SAS Users Group 2017   May 14-17, 2017 - Baltimore, Maryland

tweet!  Important and Valuable Things You Can Do with SAS® Metadata DICTIONARY Tables and SASHELP Views
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: SAS, metadata, sas metadata, DICTIONARY, DICTIONARY tables, system tables, SASHELP views, system views, author, sas press, sas press author, consultant, sas consultant, sql, sql consultant, Lafler, ...
Pages: 8 Size: 931 Kb 
tweet!  Writing Efficient Queries in SAS Using PROC SQL with Teradata
  Mina Chen, Roche
Keywords: Teradata SQL
Pages: 5 Size: 117 Kb 
tweet!  SAS® Debugging 101
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: SAS, error, errors, warning, warnings, SAS log, log, debug, debugging, sas debugging, sas debugging techniques, Benchworkzz, consultant, sas consultant, sas consulting, sql, sql consultant, sql con ...
Pages: 13 Size: 879 Kb 
tweet!  Application of Deming Regression in Molecular Diagnostics using a SAS® Macro
  Merlin Njoya, Roche; Pari Hemyari, Roche
Keywords: Deming Regression bootstrap SAS macro SQL Procedure
Pages: 6 Size: 500 Kb 

Pharmaceutical SAS Users Group 2016   May 8-11, 2016 - Denver, Colorado

tweet!  SAS® integration with NoSQL data
  Kevin Lee, Clindata Insight, Moraga, CA
Keywords: SQL
Pages: 9 Size: 347 Kb 
tweet!  What's Hot – Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 558 Kb 
tweet!  Hands-On SAS® Macro Programming Essentials for New Users
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, Macro Language, macro, keyword macro, positional macro, SQL, SQL procedure, consultant, SAS consultant, consulting, SAS consulting, sql, sql consultant, sql consulting, author, sas author, sas ...
Pages: 10 Size: 617 Kb 
tweet!  PROC SQL: To Create Macro Variables with Multiple Values and the Uses in Clinical Programming
  Anish Kuriachen, inVentiv Health Clinical, NJ
Keywords: Proc Sql macro
Pages: 4 Size: 81 Kb 
tweet!  Best Practices: Subset Without Getting Upset
  Mary F. O. Rosenbloom, Lake Forest, CA; Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS subset subsetting by-group by-group processing subgroup analysis best practice SQL SAS SQL PROC SQL joins LEFT join Coalesce Rosenbloom Lafler
Pages: 17 Size: 700 Kb 
tweet!  Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL
  Richann Watson, Experis, Batavia, OH; Lynn Mullins, PPD, Cincinnati, OH
Keywords: hash SQL
Pages: 14 Size: 251 Kb 

Pharmaceutical SAS Users Group 2015   May 17-20, 2015 - Orlando, Florida

tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting Corporation, San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 556 Kb 
tweet!  Application Development Techniques Using PROC SQL
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, i ...
Pages: 20 Size: 1076 Kb 
tweet!  DS2 with Both Hands on the Wheel
  Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada; Xue Yao, Winnipeg Regional Health Authority, Winnipeg, MB, Canada
Keywords: DS2 method package array FCMP function null date SQL datatype
Pages: 32 Size: 276 Kb 
tweet!  PROC SQL for SQL Die-hards
  Jessica Bennett, Advance America, Spartanburg, SC; Barbara Ross, Flexshopper LLC, Boca Raton, FL
Keywords: QT06 SQL
Pages: 7 Size: 419 Kb 
tweet!  Creating output datasets using SQL (Structured Query Language) only
  Andrii Stakhniv, Experis Clinical, Ukraine
Keywords: SQL
Pages: 10 Size: 358 Kb 

Pharmaceutical SAS Users Group 2014   June 1-4, 2014 - San Diego, California

tweet!  D is for Dynamic, putting Dynamic back into CDISC (A simple macro utilizing PROC SQL which auto-formats continuous variables for lab tables)
  Steven Black, SynteractHCR, Carlsbad, CA
Keywords: PROC SQL MACO Language SAS functions CDISC Paramn AVAL macro
Pages: 9 Size: 81 Kb 
tweet!  Using the Power of SAS SQL
  Jessica Wang, Regeneron Pharmaceuticals Inc., Basking Ridge, NJ
Keywords: SQL
Pages: 14 Size: 132 Kb 
tweet!  Efficient SQL for Pharma… and Other Industries
  Chris Olinger, d-Wise, Morrisville, NC
Keywords: SQL IO Optimizations Code Tricks _METHOD _TREE MAGIC UPDATE ORDER BY Sort Assertions Configuration Options
Pages: 15 Size: 115 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting Corporation, San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's hot in sas, the hottest topics in sas are, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tab ...
Pages: 6 Size: 513 Kb 
tweet!  Need for Speed in Large Datasets – The Trio of SAS® INDICES, PROC SQL and WHERE CLAUSE is the Answer
  Kunal Agnihotri, PPD LLC, Morrisville, NC
Keywords: SQL
Pages: 7 Size: 269 Kb 
tweet!  A Hands-on Introduction to SAS® Dictionary Tables
  Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada
Keywords: SAS dictionary constraints macros table column library SQL rdbms
Pages: 15 Size: 275 Kb 
tweet!  Principles of Writing Readable SQL
  Kenneth W. Borowiak, PPD, Morrisville, NC
Keywords: SQL
Pages: 9 Size: 181 Kb 
tweet!  Strategies and Techniques for Debugging SAS® Program Errors and Warnings
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS, error, errors, warning, warnings, SAS log, log, debug, debugging, sas debugging, sas debugging techniques, consultant, sas consultant, sas consulting, sql, sql consultant, sql consulting, auth ...
Pages: 13 Size: 1134 Kb 

Pharmaceutical SAS Users Group 2013   May 12-15, 2013 - Chicago, Illinois

tweet!  Submitting SAS® Code On The Side
  Rick Langston, SAS Institute Inc., Cary NC
Keywords: macro %include call execute sql dosubl run_macro proc stream
Pages: 5 Size: 135 Kb 
tweet!  Conditional Processing Using the Case Expression in PROC SQL
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS SQL PROC SQL SQL procedure Case Case expression conditional processing logic logic scenarios simple case searched case Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 8 Size: 584 Kb 
tweet!  Can you export all the datasets into Excel for me? - A small dynamic macro that does it as fast as they think it should.
  Steven Black, W. L. Gore & Associates Inc., Flagstaff, AZ
Keywords: PROC SQL PROC TEMPLATE PROC REPORT EXCELXP TAGSET MACRO language
Pages: 8 Size: 43 Kb 
tweet!  A Closer Look at PROC SQL’s FEEDBACK Option
  Kenneth W. Borowiak, PPD, Inc., Morrisville, NC
Keywords: PROC SQL feedback select * natural joins macro variables operator mnemonics
Pages: 7 Size: 286 Kb 
tweet!  Add a Little Magic to Your Joins
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS SQL PROC SQL SQL procedure join joins join algorithm step-loop sort-merge index hash Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 6 Size: 427 Kb 
tweet!  Quick Results with PROC SQL
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS SQL PROC SQL query case expression view join inner join outer join Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 17 Size: 1056 Kb 
tweet!  SQL Subqueries: Usage in Clinical Programming
  Pavan Vemuri, PPD, Morrisville, NC
Keywords: SQL
Pages: 7 Size: 392 Kb 
tweet!  Things Dr Johnson Did Not Tell Me: An Introduction to SAS® Dictionary Tables
  Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada
Keywords: SQL dictionary remember
Pages: 15 Size: 275 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA; Charles Edwin Shipp, Consider Consulting, Inc., San Pedro, CA
Keywords: SAS, SAS skills, what's hot, what's not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tables, BI, SAS/XML, sasCommunity, SAS-L, LexJansen.c ...
Pages: 6 Size: 582 Kb 
tweet!  SQL, HASH Tables, FORMAT and KEY= — More Than One Way to Merge Two Datasets
  David Franklin, TheProgrammersCabin.com, Litchfield, NH
Keywords: SQL HASH FORMAT KEY Merge
Pages: 5 Size: 158 Kb 
tweet!  Access to Relational Databases Using SAS®
  Frederick Pratter, Destiny Corp., Rocky Hill, CT
Keywords: SAS relational SQL
Pages: 10 Size: 409 Kb 

Pharmaceutical SAS Users Group 2012   May 13-16, 2012 - San Francisco, California

tweet!  Quick Data Definitions Using SQL, REPORT and PRINT Procedures
  Bradford J. Danner, PharmaNet/i3, TN
Keywords: data definitions SQL REPORT PRINT ExcelXP tagset
Pages: 5 Size: 50 Kb 
tweet!  Ready To Become Really Productive Using PROC SQL?
  Sunil K. Gupta, Gupta Programming, Simi Valley, CA
Keywords: Where IF SQL
Pages: 20 Size: 500 Kb    Download the workshop filesdownload (.zip, 1712 Kb)
tweet!  SAS® Macro Programming Tips and Techniques
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: SAS Macro Language macro keyword macro positional macro SQL SQL procedure Lafler Kirk Lafler Kirk Paul Lafler
Pages: 9 Size: 293 Kb 
tweet!  Exploring DATA Step Merges and PROC SQL Joins
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA
Keywords: merge join merge vs. join DATA step PROC SQL SQL Cartesian Product match-merge outer join Hash hash hash object hash methods methods Lafler Kirk Lafler Kirk Paul Lafler
Pages: 14 Size: 758 Kb 
tweet!  Get SAS®sy with PROC SQL
  Amie Bissonett, Pharmanet/i3, Minneapolis, MN
Keywords: SQL
Pages: 12 Size: 100 Kb 

Pharmaceutical SAS Users Group 2011   May 8-11, 2011 - Nashville, Tennessee

tweet!  Tracking Metadata within SAS Drug Development Using SDDPARMS
  Bradford J. Danner, i3 Statprobe, Lincoln, NE; Matthew J. Wiedel, Celerion, Lincoln, NE; Katrina E. Canonizado, Celerion, Lincoln, NE
Keywords: SAS DD metadata SDDPARMS SQL ExcelXP tagset
Pages: 7 Size: 401 Kb 
tweet!  Exploring DATA Step Merges and PROC SQL Joins
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, California
Keywords: merge join merge vs. join DATA step SQL Cartesian Product match-merge outer join
Pages: 11 Size: 436 Kb 
tweet!  Resolving OpenCDISC Error Messages Using SAS®
  Virginia Redner, Merck & Company, Inc., Upper Gwynedd, PA; John R. Gerlach, SAS / CDISC Analyst; Hamilton, NJ
Keywords: OpenCDISC CDISC SQL Validation
Pages: 10 Size: 112 Kb 
tweet!  Producing Clinical Laboratory Shift Tables From ADaM Data
  Rao Bingi, Octagon Research Solutions, Wayne, PA
Keywords: lab shift table shift table SAS ADaM shift tables proc freq Rao Bingi Bingi proc sql CDISC
Pages: 12 Size: 385 Kb 
tweet!  A Non-Invasive Macro to Track Submission Metadata in SAS Drug Development
  Katrina E. Canonizado, Celerion, Lincoln, NE; Bradford J. Danner, i3 Statprobe, Lincoln, NE; Matthew J. Wiedel, Celerion, Lincoln, NE
Keywords: Metadata SDDPARMS SAS Drug Development SQL macro
Pages: 8 Size: 96 Kb 
tweet!  Macros to Help You Clean Up!
  Kavitha Madduri, Boehringer Ingelheim Pharmaceuticals Inc., Ridgefield, CT
Keywords: SAS Dictionary Tables Macros SQL
Pages: 7 Size: 72 Kb 
tweet!  A Pragmatic Programmers Introduction to Data Integration Studio: Hands on Workshop (updated for DI Studio 4.2)
  Gregory S. Nelson, ThotWave Technologies, Cary, North Carolina
Keywords: Data Integration SQL Data Management Data Integrity
Pages: 35 Size: 2196 Kb 
tweet!  Powerful and “Sometimes” Hard-to-find PROC SQL® Features
  Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, California
Keywords: PROC SQL SQL queries case logic views Dictionary tables macro variables joins query performance
Pages: 17 Size: 724 Kb 
tweet!  Good Programming Practices in Healthcare Creating Robust Programs
  Gregory S. Nelson, ThotWave Technologies; Jay Zhou, Q-Squared Business Intelligence, Inc.
Keywords: SAS Base SAS Macro SQL Data Step healthcare
Pages: 17 Size: 349 Kb 
tweet!  A Many to Many Merge, Without SQL?
  David Franklin, TheProgrammersCabin.com, Litchfield, NH
Keywords: datastep SQL
Pages: 4 Size: 93 Kb 

Pharmaceutical SAS Users Group 2010   May 23-26, 2010 - Orlando, Florida

Best Paper
tweet!  SAS Programming Techniques for Manipulating Metadata on the Database Level
  Chris Speck, PAREXEL International
Keywords: Metadata Macro Library Database SQL Quoting Dictionary Tables
Pages: 7 Size: 58 Kb 
tweet!  When Best to Use the %LET Statement, the SYMPUT Routine, or the INTO Clause to Create Macro Variables
  Arthur Li, City of Hope/University of Southern California
Keywords: macro variable %LET %SYMPUT input stack macro processor INTO clause SQL DATA step compiler
Pages: 18 Size: 268 Kb 
tweet!  So, You've Got Data Enterprise Wide (SAS, ACCESS, EXCEL, MySQL, Oracle, and Others); Well, Let SAS Enterprise Guide Software Point-n-Click Your Way to Using It
  William Benjamin Jr, Owl Computer Consultancy LLC
Keywords: Enterprise Guide non-SAS files SQL
Pages: 10 Size: 1272 Kb 

Pharmaceutical SAS Users Group 2009   May 31 - June 3, 2009 - Portland, Oregon

tweet!  A SAS Macro for Creating AE dataset
  Daniel Li
Keywords: Adverse Events PROC SQL DO LOOP PROC REPORT macro
Pages: 10 Size: 93 Kb 
tweet!  Automating the pooling of variables across multiple datasets using Proc SQL and SAS Macro
  Sanjiv Ramalingam
Keywords: SQL macro
Pages: 10 Size: 176 Kb 
tweet!  Demystifying PROC SQL® Join Algorithms
  Kirk Paul Lafler
Keywords: join join algorithms Cartesian product inner joins outer joins SQL
Pages: 6 Size: 55 Kb 
tweet!  Things Dr Johnson Did Not Tell Me:An Introduction to SAS® Dictionary Tables
  Peter Eberhardt
Keywords: SQL dictionary lookup
Pages: 15 Size: 263 Kb 

Pharmaceutical SAS Users Group 2008   June 1-4, 2008 - Atlanta, Georgia

tweet!  SQL or not SQL When Performing Many-to-Many Merge — A Realistic Example
  Jade(xiqun) Huang, Merck Co.
Keywords: SQL
Pages: 6 Size: 52 Kb 
tweet!  Single Page Graphical Display of Multiple Subjects' Time Pattern on Studies
  Louie Huang, Baxter International Inc.
Keywords: PROC GPLOT ANNOTATION PROC SQL MACROS SAS/GRAPH
Pages: 9 Size: 100 Kb 
tweet!  A Hands-On Tour Inside the World of PROC SQL®
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: SQL, PROC SQL, query, subset, ordering data, duplicate rows, DISTINCT, LIKE operator, phonetic matching, CASE logic, CASE expressions, views, indexes, joins, Cartesian Product, inner joins, outer j ...
Pages: 18 Size: 86 Kb 
tweet!  An Animated Guide: Explaining SQL to Beginners
  Russell Lavery, Self
Keywords: SQL
Pages: 19 Size: 155 Kb 
tweet!  Labor-saving SQL Constructs
  Brian Fairfield-Carter, ICON Clinical Research
Keywords: SQL
Pages: 11 Size: 285 Kb 
tweet!  Undocumented and Hard-to-find PROC SQL® Features
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: SQL PROC SQL CASE logic CASE expression COALESCE function _METHOD _TREE Dictionary tables Macro interface performance tuning strategies
Pages: 11 Size: 381 Kb 

Pharmaceutical SAS Users Group 2007   June 3-6, 2007 - Denver, Colorado

tweet!  Create Metadata Documentation Using ExcelXP
  Christine Teng, Merck & Co., Inc.
Keywords: ExcelXP SAS DICTIONARY SQL
Pages: 8 Size: 619 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 E Fogleman, Harvard Clinical Research Institute
Keywords: generation datasets proc sql compare
Pages: 3 Size: 36 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 and Prevention
Keywords: data review dynamic programming list processing do loop macro SQL
Pages: 10 Size: 129 Kb    Download the presentationdownload (.pdf, 129 Kb)
tweet!  Undocumented and Hard-to-Find PROC SQL Features
  Kirk P Lafler, Software Intelligence Corporation
Keywords: SQL PROC SQL query CASE Dictionary Tables _METHOD _TREE
Pages: 10 Size: 381 Kb 
tweet!  The SQL Optimizer Project: _Method and _Tree in SAS 9.1
  Russ M Lavery, self
Keywords: SQL optimizer options
Pages: 12 Size: 44 Kb 
tweet!  Leveraging Base SAS for Constructing a Low-Cost, Data Clarification Request Generation and Tracking System Independent of a Clinical Data Management System
  David M Escobar, TDNCC - Seattle Children's Hospital Research Institute; Barbara Mathewson, TDNCC - Seattle Children's Hospital Research Network,; George Strang, TDNCC - Seattle Children's Hospital Research Institute
Keywords: Proc SQL Data Management Poster Microsoft Access Edit Checks
Pages: 7 Size: 690 Kb 
Best Paper
tweet!  Hypothesis Testing: An SQL Analogy
  Paul D Sherman, self; Leroy Bracken, self
Keywords: missing data Null hypothesis outer join consolidated pivot table SQL
Pages: 5 Size: 173 Kb    Download the presentationdownload (.zip, 632 Kb)
tweet!  Secret Sequel: Keeping Your Password Away From the LOG
  Paul D Sherman, self; Arthur L Carpenter, California Occidental Consultants
Keywords: PROC SQL SQL pass through password SYMBOLGEN
Pages: 10 Size: 271 Kb 
Best Paper
tweet!  Proc SQL Versus the DATA Step
  JoAnn R Matthews, Highmark Blue Shield
Keywords: PROC SQL DATA step processing
Pages: 39 Size: 4601 Kb 

Pharmaceutical SAS Users Group 2006   May 21-24, 2006 - Bonita Springs, Florida

tweet!  Back From The Future: Different Ways to Transfer the Values from Later to Earlier Visits
  Alexander Feigin, Synthes USA
Keywords: PROC SORT SQL Macro
Pages: 8 Size: 204 Kb 
tweet!  Base SAS v. SAS Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It
  Danny Grasse, ThotWave Technologies, LLC.; Greg S. Nelson, ThotWave Technologies, LLC.
Keywords: Data Integration Studio ETL Studio BASE SAS SQL data warehousing slowing changing dimensions ETL
Pages: 20 Size: 614 Kb 
tweet!  PROC SQL: An Efficient Tool for Creating Macro Variables
  Louie Huang, Baxter BioScience
Keywords: PROC SQL SAS Macros Call Symput data _null_ select group by having order by merge concatenate
Pages: 6 Size: 191 Kb 
tweet!  SAS Proc SQL or Vanilla Flavor
  Cecilia Mauldin, PPD
Keywords: SQL keep drop having rename where PDV
Pages: 9 Size: 46 Kb 
tweet!  CFB: A Programming Pattern for Creating "Change from Baseline" Datasets
  Lei Zhang, Celgene Corporation
Keywords: Programming Pattern Change from Baseline SQL Subquery UML Model
Pages: 12 Size: 115 Kb 
tweet!  A Comparison Between SQL and Data Step and Some SAS Procedures
  LaTonya Murphy, PPD; Lan Tran, PPD
Keywords: SQL Sort or order group and by
Pages: 6 Size: 42 Kb 
tweet!  Simple Ways to Use PROC SQL and DICTIONARY TABLES to Verify Data Structure of the Electronic Submission Data Sets
  Christine S. Teng, Merck & Co., Inc.; Wenjie Wang, Merck & Co., Inc.
Keywords: SAS PROC SQL DATA DICTIONARY
Pages: 10 Size: 49 Kb 

Pharmaceutical SAS Users Group 2005   May 22-25, 2005 - Phoenix, Arizona

tweet!  Storing and Using a List of Values in a Macro Variable
  Art Carpenter, CA Occidental Consultants
Keywords: Macro variables %SCAN &&VAR&I PROC SQL INTO CALL SYMPUT %DO
Pages: 6 Size: 111 Kb 
tweet!  Programming Gems that are worth learning SQL for!
  Pamela L. Reading, Rho, Inc.
Keywords: SQL fuzzy merge Cartesian merge merging
Pages: 5 Size: 378 Kb 
tweet!  Everything You Always Wanted to Know About Fuzzy Merges But Were Afraid to Ask - A Guide to Merging Datasets with Non-Exact Keys Using SAS Proc SQL
  Robert W. Graebner, Quintiles
Keywords: SQL Fuzzy Merge
Pages: 4 Size: 72 Kb 
tweet!  The Power of PROC SQL Techniques and SAS Dictionary Tables in Handling Data
  MaryAnne D. Hope, Health Services Advisory Group Fen Fen Li, Health Services Advisory Group
Keywords: PROC SQL Dictionary Tables VCOLUMN VTABLE
Pages: 6 Size: 115 Kb 
tweet!  SAS Macros to Match Data from External Data Sources
  Arkady M. Kushnir, AmEx
Keywords: SAS macro %LET PROC FORMAT PROC SQL
Pages: 6 Size: 54 Kb 
tweet!  Creating Efficient SQL - The De-normalize Transpose
  Paul D. Sherman, Independent
Keywords: SQL query database beancounting data modeling data warehouse normalization pass-through table select
Pages: 14 Size: 199 Kb 
tweet!  The Use and Abuse of the Program Data Vector (The Procs)
  Jim Johnson, Covance
Keywords: Print Sort Freq SQL program data vector
Pages: 17 Size: 187 Kb 
tweet!  Selected Macro and SQL Techniques For Efficient SAS Programming
  Brian P. Fairfield-Carter, PRA International; Sam Wang, PRA International
Keywords: SQL interpolation macro
Pages: 12 Size: 97 Kb 
tweet!  SAS and Oracle PL/SQL: Partners or Competitors?
  Stanley E. Fogleman, HCRI
Keywords: SQL PL/SQL ORACLE
Pages: 5 Size: 46 Kb 
tweet!  What Would I Do without PROC SQL and the Macro Language?
  Jeffrey M. Abolafia, Rho, inc.
Keywords: SQL Macro
Pages: 5 Size: 193 Kb 
tweet!  ADVANCE TIPS for Manipulating Data in Commonly used Procedures.
  RAJ S. SULIGAVI, HTC Global Services Inc.; Jyotheeswara N. Yellanki, Systems analyst
Keywords: Abort Stop Propcase Scan Substr If Where OBS FIRSTOBS DO Leave List Informat Put Colon Opeartor MOD operator In operator PROC SQL PROC SORT PROC REPORT
Pages: 11 Size: 243 Kb 
2nd Best Paper
tweet!  Retaining, Lagging, Leading, and Interleaving Data
  Toby Dunn, Texas Eductation Agency; Chang Chung, Office of Population Research, Princet
Keywords: RETAIN statement LAG function lead technique interleaving Schreier Self-interleave DoW Double DoW SQL
Pages: 8 Size: 47 Kb 

Pharmaceutical SAS Users Group 2004   May 23-26, 2004 - San Diego, California

tweet!  Create All Those Tables and Call PROC SQL Once!
  Stanley E. Fogleman, Harvard Clinical Research Institute
Keywords: MACRO PROC SQL DATABASE TABLES
Pages: 3 Size: 32 Kb 
tweet!  Automating the Documentation of Oracle Clinical Database Specifications
  Kyle McBride, Instat Consulting, Inc.
Keywords: Oracle Clinical ODS SQL SAS MACRO Specifications Report
Pages: 9 Size: 215 Kb 
tweet!  Helpful Hints on Developing a User Friendly Database with SAS/AF
  Sy J. Truong, Meta-Xceed, Inc.
Keywords: user friendly applications SAS/AF SCL SQL
Pages: 8 Size: 265 Kb 
tweet!  Version 9 Changes and Enhancements
  Dana Rafiee, Destiny Corporation
Keywords: Open Metadata Architecture, Version 9.1, SAS Management Console, Application Response Measurement, Cross Environment Data Access, ADA 508, Installation, directory, Enhanced Editor, ActiveX, Configu ...
Pages: 19 Size: 527 Kb 
tweet!  SAS and Microsoft Excel for Tracking and Managing Clinical Trial Data: Methods and Applications
  Na Li, Pharmacyclics, Inc.; Kathy Boussina, Pharmacyclics, Inc.
Keywords: Excel DDE SQL ODS ACCESS DBLOAD
Pages: 11 Size: 217 Kb 
tweet!  Undocumented and Hard-to-Find PROC SQL Features
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: PROC SQL CASE _METHOD _TREE DICTIONARY TABLES MACRO VARIABLES PERFORMANCE
Pages: 9 Size: 35 Kb 
Best Paper
tweet!  A Visual Introduction to SQL Joins
  Kirk Paul Lafler, Software Intelligence Corporation; Charles Edwin Shipp, Shipp Consulting
Keywords: JOINS EQUI-JOINS INNER JOINS OUTER JOINS CARTESIAN PRODUCT SQL
Pages: 5 Size: 36 Kb 

Pharmaceutical SAS Users Group 2003   May 4-7, 2003 - Miami, Florida

tweet!  A One-Step Method for Finding the Closest Match
  Erin Christen, STATPROBE, Inc.
Keywords: SQL closest match merge close merge near merge
Pages: 2 Size: 77 Kb 
tweet!  Application of Some Advanced PROC SQL Features in Clinical Trial Programming
  Changhong Shi, Merck & Co; Sylvianne Roberge, Merck & Co.
Keywords: PROC SQL DATA Step Clinical Trials Macro Variable(s) Merge Missing Data
Pages: 6 Size: 141 Kb 
tweet!  Nine Steps to Get Started using SAS® Macros
  Jane Stroupe, SAS Institute
Keywords: macro variables macro programs symput sql
Pages: 6 Size: 141 Kb 
Best Paper
tweet!  The Use and Abuse of the Program Data Vector
  Jim Johnson, Covance
Keywords: PVD program data vector efficiency RETAIN KEEP option/statement DROP option/statement RENAME option/statement WHERE option/statement PROC SQL merge
Pages: 10 Size: 116 Kb 
tweet!  Data Extraction & MedDRA: A SAS Coding Shortcut
  Fang Dong, Pfize; Saket Badola, STATPROBE
Keywords: SAS Macros SAS/Access SQL Passthrough MedDRA Lookup Function
Pages: 4 Size: 164 Kb 
Best Paper
tweet!  SQL for People Who Don't Think They Need SQL
  Erin Christen, STATPROBE, Inc.
Keywords: SQL data step efficiency shortcuts
Pages: 8 Size: 119 Kb 

Pharmaceutical SAS Users Group 2002   May 5-8, 2002 - Salt Lake City, Utah

Best Paper
tweet!  SAS® Techniques to Get the Most out of Oracle Clinical®
  David Johndrow, Analytical Sciences, Inc.
Keywords: SAS Oracle Clinical Extract Custom Reporting ODS SQL Study Tracking
Pages: 8 Size: 67 Kb 
tweet!  Serology Inventory System
  Mariya Charny, NAB; Ala Sweidan, NABI
Keywords: SAS/AF ORACLE proc SQL clintrial messagebox inventory serology NABI table attribute
Pages: 8 Size: 163 Kb 
tweet!  Save Time Today Using SAS® Views
  Robert Ray, SAS Institute Inc
Keywords: Sure SQL DATA Step view
Pages: 4 Size: 138 Kb 
tweet!  Punctuation in SAS Programming
  John Morrill, Quintiles, Inc; George Li, Quintiles, Inc.
Keywords: automatic variable double multiple operator punctuation sign special character SQL
Pages: 6 Size: 96 Kb 
tweet!  Expanding the Functionality of Min()/Max(): Finding Tied Minimum or Maximum Values and Their Contributing Variables
  Kent Nassen, Pfizer Global Research & Development -- Ann Arbor Laboratories; Subra Pilli, Pfizer Global Research & Development -- Ann Arbor Laboratories; Luai Alzoubi, Pfizer Global Research & Development -- Ann Arbor Laboratories
Keywords: Macro min() max() tied minimum tied maximum iterative processing array proc sql nested do loop
Pages: 8 Size: 105 Kb 
tweet!  Data Dependent Footers using Proc Report
  Angelina Cecilia Casas, PPD Development
Keywords: proc report break footer header proc sql
Pages: 4 Size: 48 Kb 
Best Paper
tweet!  Access to Relational Databases Using SAS ®
  Frederick Pratter, University of Montana
Keywords: SAS/Access Oracle RDBMS SQL
Pages: 4 Size: 122 Kb 

Pharmaceutical SAS Users Group 2001   May 20-23, 2001 - Boston, Massachusetts

tweet!  The Efficiency of Proc SQL in Place of Traditional Procedures for Large Data Sets
  Cindy Stroupe, ClinTrials Research, Inc., Cary, NC
Keywords: SQL
Pages: 4 Size: 15 Kb 
tweet!  A Comparison of Cross-Database Access Techniques Using SAS® with SAS/ACCESS® Version 6.12 and SAS with SAS/ACCESS Version 8.1
  Karen Glenn, netRegulus Inc., Denver, CO
Keywords: ODBC SAS Access SQL
Pages: 2 Size: 97 Kb 
tweet!  Digging for Gold: SAS® Tools for Extracting Clinical Study Information from Oracle Clinical
  Nancy Brucken, Pfizer Global R&D OE Ann Arbor Laboratories, Ann Arbor, MI
Keywords: SQL SAS/ACCESS Passthrough
Pages: 4 Size: 69 Kb 
tweet!  Enhancing Code with the SQL Procedure
  Jeff Goodrich, STATPROBE, Inc., Lexington, KY; Jon Fowler, STATPROBE, Inc., Lexington, KY
Keywords: SQL summary
Pages: 6 Size: 113 Kb 

Pharmaceutical SAS Users Group 2000   May 7-10, 2000 - Seattle, Washington

tweet!  An Integrated Review TM Tool: Using the SAS® SQL Library for C to Access SAS® Data
  Andrea L. Contino
Keywords: SQL
Pages: 1 Size: 16 Kb 
Best Paper
tweet!  Using the Host Variable INTO: in PROC SQL
  Thiru Satchi
Keywords: SQL
Pages: 1 Size: 52 Kb 
tweet!  Removing Duplicates: PROC SQL Can Help You "See"
  Vicki Siemers; Brian Nash
Keywords: SQL
Pages: 2 Size: 21 Kb 

Pharmaceutical SAS Users Group 1998   May 17-20, 1998 - San Francisco, California

tweet!  Uses of PROC SQL as a Reporting Tool and For Joining Data
  John Hotaling, Quintiles, Inc., Boston, MA
Keywords: Magic SQL
Pages: 3 Size: 26 Kb 
Generating Multiple SQL Modules from a Single SAS Program
  Diana L. Williams, ClinTrials Research, Inc.; Drew K. Edwards, Research Triangle Park, NC
Keywords: SQL
tweet!  A Technique for Importing External Data into a Relational Database Using PROC SQL, the Pass-Through Facility and the Macro Language
  Paul Doucette, PAREXEL International Corporation, Media, Pennsylvania
Keywords: SQL macro
Pages: 7 Size: 24 Kb 
tweet!  Proc SQL Dictionary Tables - A Great Source of Information about Data Sets
  Wendih S. Yao, PAREXEL International Corp, Northbrook, IL
Keywords: SQL
Pages: 4 Size: 31 Kb 

Pharmaceutical SAS Users Group 1997   May 11-14, 1997 - Hilton Head, South Carolina

tweet!  Some Less Known but Powerful Proc SQL Features
  Jun Zhao, Boehringer Ingelheim Pharmaceuticals, Inc. Ridgefield, CT
Keywords: SQL
Pages: 4 Size: 181 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-2017 Lex Jansen. All rights reserved.