Date: Fri, 10 Sep 2004 11:53:01 -0400 From: basugwm Subject: 3rd quarter meeting announcement *==================================================================== BASUG QUARTERLY MEETING *==================================================================== WHAT: BASUG QUARTERLY MEETING THEME: Reporting WHEN: Tuesday, October 5, 2004 Quarterly Meeting: 8:30AM - 12:00PM WHERE: Holiday Inn Newton (Directions are included below.) 399 Grove Street Newton, MA 02462 (617-969-5300) INDIVIDUAL, ON-LINE REGISTRATION IS REQUIRED. NO EMAIL. Please do not reply to this message. To register for the meeting, visit http://www.basug.org/register.php3 CONTACT for the quarterly meeting: Lori Goldman: lgoldman@ihcis.com An email will be sent to confirm all online registrations. Please Note the following: This meeting is appropriate for all levels of SAS. /******************************************************************/ AGENDA: 8:30 – 8:45 Sign in and Coffee Break 8:45 - 9:00 Meeting Announcements and Introductions 9:00 – 12:00 Speakers /******************************************************************/ PROCs PRINT, TABULATE and REPORT: A Functional Comparison Paul Grant, SAS Institute PROCs PRINT, TABULATE and REPORT are the three main reporting procedures in SAS. Each was created with a specific purpose in mind. Accordingly, each has its strengths and limitations. A certain type of report may be very easy to produce with one procedure but difficult or impossible to produce with another. This presentation will look at the capabilities and limitations of each of these three procedures in terms of their ability to produce reports with specific requirements such as nested column labels, cross-tabs, multiple lines per observation,and customized data values on the report. Intended audience: Programmers who have a basic understanding of the syntax of each of these procedures who want to know which procedure is best to use for certain kinds of reports. Bio: Paul Grant is a Systems Engineer at the SAS Boston regional office. He chaired SUGI 21 in Chicago in 1996 and co-chaired NESUG '94 in Philadelphia. He has been active in the Boston Area SAS Users Group for many years. He originated Coders’ Corner and the Sunday Workshops at SUGI and NESUG. Paul has been using SAS software in a variety of industries since 1981. /******************************************************************/ Let SAS® Build Your Dynamic Web Site from the Data! Jennifer Sinodis, Bank One, Phoenix, AZ In today’s environment, the web has become the best channel to view meaningful information. Let SAS do the work and produce your web output straight from the data! It can do most of the work involved in creating great looking, maintenance-free, dynamic web pages for your users. This paper will show how to use Version 8 SAS/Base to build static HTML output to your web site with HTML formatting macros and ODS (Output Delivery System) and how to use SAS/IntrNetTM to create output dynamically from your web site. It will also introduce JavaScript code and show how SAS/Base can produce JavaScript to generate drop-down menu options built directly from your data to access static HTML output, or create dynamic HTML. For the purpose of this paper most of the SAS programs shown are simplified. The paper illustrates SAS/Base macro code, HTML, ODS, JavaScript and SAS/IntrNet code. This paper assumes an experienced/advanced knowledge of SAS/Base Version 8 and some knowledge of HTML. Bio: Jennifer Sinodis has a Bachelor of Science degree in Information Systems and has worked with SAS for over six years. She was trained and mentored by Vanessa Hayden - "SAS Queen" when they worked together at Bank One. Jennifer has presented several times at the Western Users of SAS Software and SAS User Group International conferences and also coordinates the Valley of the Sun SAS User Group. She currently works as a Senior Business Analyst at Metris Companies. She has used SAS on PC, mainframe and Unix. /******************************************************************/ Skinning the Cat This Way and That: Using ODS to Create Word Documents that Work for You Elizabeth Axelrod, Abt Associates Inc. David Shamlin, SAS Institute By supporting formats like Rich Text Format (RTF) and HyperText Markup Language (HTML), the SAS Output Delivery System (ODS) makes turning SAS output into Word documents easy. Tabular output from SAS procedures can be sent directly to a file that Word can read. However, the resulting Word document might fall short of your expected results. For example, we needed to create a Word document that would serve as a user guide (or codebook), describing over 400 variables in a survey study. The body of the document needed to include detailed information for each variable. The Table of Contents needed to list the page numbers for the sections including the detailed information for each variable. As a result, we experienced several formatting challenges. Long values in section titles did not wrap correctly, and there was too much white space between sections, to name a few. In the course of creating a solution, we discovered a number of useful ODS tricks when creating a Word document using SAS output. We researched ways to automate the creation of the document and to minimize the amount of manual formatting in Word. Bio: Elizabeth Axelrod is a Lead Programmer Analyst at Abt Associates Inc.. She has been using SAS for over 20 years, and she's been a SAS fan(atic) for almost that long! She is currently the Chairwoman for BASUG - the Boston Area SAS Users Group. David Shamlin joined SAS Institute in 1987 as a member of the VMS Host group, where he helped develop low-level file systems. He also did a tour of duty with the SAS IO development team, becoming a pioneer in industry-standard data access interfaces to SAS data stores. David brings these experiences to his current role as R&D Director for Base Table Services where he leads the development of fundamental SAS technology related to the data step, Base PROCs, the LIBNAME supervisor, data set and catalog IO, SAS/SHARE and other client/server components related to SAS data access. David has a bachelor's degree in computer science from North Carolina State University. /******************************************************************/ DIRECTIONS: Holiday Inn Newton 399 Grove Street Newton, MA 02462 (617-969-5300) DRIVING: FROM BOSTON: Take I-90 West to Exit 15, then take Route 128 South (I-95)1/4 mile to Exit 22. When you exit, stay right and bear right at the fork onto Grove Street. The hotel is on your left. FROM SOUTH OF BOSTON: Take Route 128 North (I-95) to Exit 22. When you exit, stay right and bear right at the fork onto Grove Street. The hotel is on your left. FROM WESTERN MASS: Take I-90 East to Exit 14, then take Route 128 South (I-95) 1/4 mile to Exit 22. When you exit, stay right and bear right at the fork onto Grove Street. The hotel is on your left. FROM NEW HAMPSHIRE: Take I-93 South to Route 128 South (I-95), follow for approximately 15 miles to Exit 22. When you exit, stay right and bear right at the fork onto Grove Street. The hotel is on your left. FROM RHODE ISLAND: Take I-95 North to Route 128 North (I-95). Follow to Exit 22. When you exit, stay right and bear right at the fork onto Grove Street. The hotel is on your left. PUBLIC TRANSPORTATION: The hotel is adjacent to the Riverside T Station. From Kenmore Square take the Green Line - D (Riverside) to the Riverside stop. The hotel is adjacent to the T Station. The hotel is also accessible from downtown Boston via Express Bus #500 (EXPRESS BUS Riverside - Downtown via Mass. Turnpike). The bus drops off at Riverside T Station, which is adjacent to the hotel. For a detailed bus route and schedule, go to http://www.mbta.com/schedmaps/bus/index.cfm *==================================================================== BASUG INFORMATION *==================================================================== MAILING ADDRESS: BASUG PO Box 253 Boston, MA 02117 WEBMASTER: webmaster@basug.org MEMBERSHIP: If would would like to join BASUG or need to pay dues for the 2004 calendar year, please print this membership form and follow the instructions on the form: http://www.basug.org/MemForm2004.doc If you are unsure if you are a member or you do not know if your company has paid its 2004 calendar year corporate dues, please contact Robert Rosofsky: robert.rosofsky@verizon.net SUBSCRIBE TO OUR EMAIL LIST: Subscribers receive automatic e-mail notification of upcoming meetings, courses, and conferences of interest to local SAS users. To subscribe to the BASUG message list, send a message to majordomo@basug.org, and in the BODY of the message specify: subscribe basugnews To unsubscribe to the BASUG message list, send a message to majordomo@basug.org, and in the BODY of the message specify: unsubscribe basugnews