'Proc sql' presentation slideshows

852 views • 59 slides

Programming tips and techniques for SAS SQL (no sqealing allowed)

Programming tips and techniques for SAS SQL (no sqealing allowed). Dan Gottlieb, MS, Research Associate Center for the Evaluative Clinical Sciences Dartmouth Medical School Hanover, NH. 3/21/03 NH/VT SAS User Group. What is SQL?

506 views • 43 slides

More On Queries with SQL

424 views • 35 slides

Displaying Query Results

Displaying Query Results. Group 8- Last but not the Least Arturo Cantillep/Greg Lynch/Nora Troy-Shaw/Yanxin Zhao. Displaying Query Results. .1 Introduction Presenting Data/What the Boss Wants .2 Its Power Ordering Data/Producing an Ordered Report Enhancing Query Output

422 views • 32 slides

Efficiencies with Large Datasets

Efficiencies with Large Datasets. Greater Atlanta SAS Users Group July 18, 2007 Peter Eberhardt. Agenda. Making large datasets smaller Sorting Issues Matching Issues General Programming Issues. What is large?. Short but Wide Tall but Thin Tall and Wide

496 views • 28 slides

Efficient SAS Coding with Proc SQL

Efficient SAS Coding with Proc SQL. When Proc SQL is Easier than Traditional SAS Approaches. Mike Atkinson, May 4, 2005. Note on Efficiency. There are at least two kinds of efficiency: SAS program efficiency and SAS programm er efficiency. This talk addresses the latter.

749 views • 28 slides

Efficient SAS Coding with Proc SQL

Efficient SAS Coding with Proc SQL. When Proc SQL is Easier than Traditional SAS Approaches. Mike Atkinson, May 4, 2005. Note on Efficiency. There are at least two kinds of efficiency: SAS program efficiency and SAS programm er efficiency. This talk addresses the latter.

384 views • 28 slides

484 views • 26 slides

Code Evolution

Code Evolution. How Programs are Developed and Refined Over Time Pantaleo Nacci, Head Statistical Reporting Berlin, 19 October 2010. Agenda. Introduction Overall Organization The Final Goal: Standard Structures Study Dimension Data Domain Dimension How I Did It

344 views • 25 slides

The Overseas Chinese Association for Institutional Research Friday SAS Salon

The Overseas Chinese Association for Institutional Research Friday SAS Salon. Annie Lin Associate Data Specialist University of Massachusetts Boston Robert W. Zhang Associate Director of Institutional Research Bowling Green State University AIR 46 th Forum Chicago, IL May 18, 2006.

413 views • 24 slides

Tips & Tricks

Tips & Tricks. MASUG 02/18/2005. Multiple Graphs on One Page. Multiple Graphs on One Page. Often it is useful to put several or even many graphs on one page Graphs are created first and stored in a SAS graphics catalog

302 views • 22 slides

Statistical Methods II

327 views • 21 slides

Statistical Methods II

258 views • 21 slides

MASUG

MASUG. December 5, 2005. Agenda. Announcements Tips & Tricks Presentation: Working Smarter, Not Harder with DDE: Did I Really Spend All That Time Formatting My Report in Excel? Giveaways Next Meeting. Announcements.

344 views • 19 slides

Proc Sql

Proc Sql. Kelly Hardman Aug. 9, 2007 BMTRY 789. What is Proc Sql?. SQL: Structured Query Language It is a procedure that combines the data and proc steps of traditional SAS code

396 views • 18 slides

Chance to make SAS-L History!

Chance to make SAS-L History!. Chance to make SAS-L history (CTMSLH). what it is. where it is some of my favorite tips. What CTMSLH is. Join me in making this the longest thread that has ever existed on SAS-L. Pick your best tip and post it. What CTMSLH is. Where you can find CTMSLH.

272 views • 16 slides

Chance to make SAS-L History!

Chance to make SAS-L History!. Chance to make SAS-L history (CTMSLH). what it is. where it is some of my favorite tips. What CTMSLH is. Join me in making this the longest thread that has ever existed on SAS-L. Pick your best tip and post it. What CTMSLH is. Where you can find CTMSLH.

271 views • 16 slides

SAS Tips & Techniques

317 views • 15 slides

Clinical Trial Data Validation Using SAS PROC SQL

Clinical Trial Data Validation Using SAS PROC SQL. Jie Liu BIOS 524 Project 2003, Fall. Background. Toxicity data are collected for NCI Sponsored clinical trials at MCC. Data are monitored by NCI/CTEP quarterly.

316 views • 15 slides

Twin Ports Area SAS Users

188 views • 7 slides