Hartford Area SAS User Group

From sasCommunity

For more information about our group and to review our newsletter, The Flash, please go to our website: (Hartford Area SAS User Group - HASUG) --

[edit] HASUG MEETING ANNOUNCEMENT AND DIRECTIONS

Our next meeting is
Thursday, August 21, 2008
from 9:00 am to noon
at Yale New Haven Health System
300 George Street, First Floor
New Haven, CT 06511

Our Topics and Speakers are:

Creating Complex Reports, Cynthia Zender, SAS Institute, Inc., Cary, NC

Are you confused about whether you need a detail report or a summary report? Do you wonder whether you're using the right reporting procedure for your report? Have you ever spent a lot of time going down the road with one procedure, only to discover that you need to switch to a different procedure to get what you want or closer to what you want? This paper is for intermediate SAS(R) programmers who want to see a gallery of complex reports and review the code that produced them. We will cover the pros and cons of PROC REPORT, PROC TABULATE, and DATA _NULL_ for each report. All report output will be produced using ODS (rather than LISTING) output. Get out your wrenches and tool belts, and fasten your seat belt for the ride; this is going to be a real nuts-and-bolts paper presentation.

Cynthia Zender, the ODS and Report Writing Curriculum Manager, has been using SAS for over 20 years and is responsible for the ODS curriculum development, including topics that range from introductory ODS to advanced topics such as ODS and XML. Cynthia divides her time between instructing and curriculum development. Cynthia is a SAS Certified Professional. Prior to joining SAS, she worked with a variety of industries using SAS for application development and report writing.

New Architecture and Speed with In-Database Processing on Netezza and Teradata Data Warehouse Appliances, Dana Rafiee, Destiny Corporation, Rocky Hill, CT

One of the biggest challenges organizations have is how they store and retrieve for analysis large amounts of data. This problem has plagued industries for years. As data sizes grow into Terabytes and Petabytes, organizations continue to face these challenges as users want to analyze and report on 'the whole data'. SAS has partnered with both Teradata and Netezza, Data Warehouse Appliance vendors. These vendors are pioneers of the self-contained warehouse appliance, which contains a database, storage and SQL processing. Each appliance contains multiple computers and storage disks to offer intelligent, massive parallel processing with load rates of 500GB per hour. The largest worldwide data customers such as Google, AOL and the NYSE had no other choices but to look to new, innovative technology to allow them to not only store enormous amounts of data, but to also reduce their query times from 24 hours down to 4 minutes. They outgrew the traditional Oracle and DB2 types of environments. SAS R&D has also jumped on board to work with these vendors to perform traditional SAS processing such as scoring 'IN' the database, hence gaining incredible speed for SAS customers.

Dana Rafiee is an IT Principal, Sr. Systems Designer, and Sr. SAS Instructor for Destiny Corp. He has over 19 years experience training individuals on all aspects of SAS Software. He also consults in the areas of applications development and design in 4th Generation Languages, Operating Systems, Networking, and Communications. Dana has been a consultant, systems designer, and trainer on many applications development projects and implementations for several concerns including U.S. Census Bureau; RAND Corporation; the States of CA, NY, & FL; BMG; EMI; Pfizer; and other Fortune 500 companies. His expertise brings together an understanding of system configurations, web-based delivery and optimization, efficient access to relational databases, and decision support tools, including SAS, Cognos, Oracle, Business Objects, Brio, and Futrix.

Directions

FROM POINTS ALONG I-91 SOUTH

   Take Exit 1, and then follow from all points.

FROM I-95 SOUTH

   Take Exit 47, continuing onto CT-34 (N. Frontage Rd) toward DOWNTOWN NEW HAVEN. 
   Take exit 3. Then follow directions below.

FROM ALL POINTS

   Take exit 3 (NORTH FRONTAGE ROAD) moving into the right-most lane. 
   Turn right at the first traffic light, turning onto YORK STREET.  
   Turn right at the first traffic light onto GEORGE STREET. 
   300 GEORGE STREET is the gray paneled building on the right hand side of the street,
   directly before the light.

Public parking is located on the left hand side of the street, at Pro-Park,
at the corner of George Street and College Street.