BASUG
The
www.basug.org
WHAT: The
WHEN:
TOPIC: ODS, ODS, and more ODS!
WHERE: Holiday Inn,
Riverside Room
617-969-5300
HOW: INDIVIDUAL, ON-LINE REGISTRATION REQUIRED. NO EMAIL!
To register for
this meeting, please visit: http://www.basug.org/register.php3
CONTACT: If you have questions about the meeting contact:
Kimball
Lewis (
AGENDA:
10:15 - 10:30 Coders Corner: "From Here to There: Getting Numbers
into pre-made Word Tables: an Alternative to Brute Force", by Elizabeth Axelrod, Abt Associates Inc.
ABSTRACTS AND BIOS:
"Using ODS to Extract Data from SAS Statistical
Procedures" by Jack Shoemaker, Wellcare Health Plans
The Output Delivery System (ODS) separates the results or
data produced by various SAS procedures from the mechanism used to render those
results. One advantage of this approach
is that it provides the user complete control over the final presentation and
format of the data. Another advantage is
that all of the wonderful statistics produced by the statistical procedures are
available as SAS data. In other words,
with ODS, every procedure essentially has an OUTPUT= option. This presentation will provide the details on
how to use ODS to extract these data from SAS statistical procedures.
Jack Shoemaker has been an active member of the SAS
community for over two decades. He has worked on a variety of large-scale data
projects in the health, finance, and energy industries, where he has used SAS
to manipulate, analyze, and surface information to key decision makers. Jack is
presently a Vice President at WellCare Health Plans,
Inc., a multi-state HMO based in
Coders Corner:
"From Here to There: Getting Numbers into pre-made Word Tables: an
Alternative to Brute Force", by Elizabeth Axelrod,
Abt Associates Inc.
This paper presents a solution to a problem from the field,
using ODS output
destinations, HTML, Excel,
and WORD.
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 Chairperson
for the Boston Area SAS Users Group (BASUG).
"Tips & Tricks for sending SAS PROC Output to
Microsoft Excel Using ODS" by David Shamlin,
SAS Institute
Presenting reports in Excel spreadsheets is often highly
desirable in today's workplace. ODS provides some quick and easy ways to do
this for a majority of cases. In addition there are some tricks that can help
you scratch those hard to reach places. In this talk we'll review the basics of
turning tabular PROC output into Excel files with ODS's
HTML destination. We'll follow that up with a survey of some additional
techniques for customizing your output. For the grand finale, we'll demo the
new SAS Add-In for Microsoft Office that makes integration with Excel a snap!
David Shamlin joined SAS® 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 Research and Development
Director for Base Table Services, where he leads the development of fundamental
SAS® technology related to the data step, BASEPROCs,
the LIBNAME supervisor, data set and catalog IO, SAS/SHARE and other
client/server components related to SAS® data access. David holds a bachelor's
degree in computer science from
DIRECTIONS TO THE HOLIDAY INN
Holiday Inn,
Riverside
Room
617-969-5300
DRIVING:
From
From South of
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
From
From
PUBLIC TRANSPORTATION
The
hotel is adjacent to the Riverside T Station. From
The
hotel is also accessible from downtown
See
http://www.mbta.com/schedmaps/bus/index.cfm for detailed bus route and
schedule. Bus drops off at Riverside T Station. Hotel is adjacent to the T
Station.
BASUG
GENERAL INFORMATION
BASUG is a local volunteer users group begun to further the interests of users of The SAS System in eastern
Our meetings are held quarterly,
typically at the Holiday Inn in
Membership: First-time attendees are
always welcome at our meetings. Payment of $25 and completion of an application
form are required for permanent retention on the group mailing list. Alternate
corporate membership is available ($125) for all users at one site (see
attached membership form.)
BASUG's Mailing Address:
BASUG
BASUG's Webmaster: To contact our Webmaster, send an e-mail to:
SUBSCRIBE TO OUR EMAIL LIST:
Subscribers receive automatic e-mail notification of
upcoming meetings, courses, and conference/es 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
UNSUBSCRIBE TO OUR EMAIL LIST:
To UNsubscribe
to the BASUG message list, send a message to majordomo@basug.org, and in the
BODY of the message specify:
unsubscribe basugnews
Boston Area SAS Users Group
New / Renewal Membership
Application and Invoice
2003
Payment of membership
dues ($25) and completion of the application form below is required for
retention on the group mailing list.
Alternate corporate membership is available ($125) for all SAS users at
that site.
Individual Membership
Dues for 2003 --------------------
$25.00 “
or
Corporate Membership
Dues for 2003 -------------------- $125.00
“
(BASUG’s
Federal tax ID# is 04-2964625)
Make checks payable to
"BASUG", complete the form below so we know who you are, and return
to the address at the bottom.
Name
__________________________________________________________
Company ________________________________________________________
Street Address:
___________________________________________________
City, State, Zip
___________________________________________________
Daytime Phone:
_________________________ Fax:______________________
E-mail Address:
___________________________________________________
Check this box if you
require a written receipt “
Suggestions
for meeting topics:
________________________________________________________________________________________________________________________________________________________________________________________________
Topics
you would be willing to present at a meeting:
________________________________________________________________________________________________________________________________________________________________________________________________
No cash,
please!
Mail this form and your check to:
BASUG