*===================================================================*
* BASUG Full-Day Training Workshop
*===================================================================*
TOPIC: USING SQL IN SAS PROGRAMMING
INSTRUCTOR: Chris Yindra
WHEN: Friday, June 10, 2005
8:30AM - 5:00PM
WHERE: Holiday Inn Newton (Directions are included below)
399 Grove Street
Newton, MA 02462
617-969-5300 (phone)
PRICE: See below
*===================================================================*
INDIVIDUAL, ON-LINE PRE-REGISTRATION REQUIRED. NO EMAIL. Please do not
reply to this message. See details below.
CONTACTS for the training:
Lori Goldman: lgoldman@ihcis.com
Bruno Berszoner: bberszoner@rcn.com
*====================================================================*
Details
*====================================================================*
This full-day training workshop is open to BASUG members only. If you are
not currently a member, you may join BASUG at this time. See details
below.
PRICE: $125 (if paid by check, post-marked by 6/1/2005)
$150 (at the door)
plus any membership fees due for 2005
SCHEDULE:
8:30 - 9:00 Sign in and Coffee Break
9:00 - 12:00 Using SQL in SAS programming class time
12:00 - 1:30 Lunch break (on your own see details below)
1:30 - 5:00 More Using SQL in SAS programming class time
Class Description:
Structured Query Language (SQL) is available in the base SAS system in
order to take advantage of this standardized structured coding language. No
additional purchase is necessary for you to use this tool. PROC SQL is a
natural for individuals who are already familiar with SQL coding as well as
new users to whom it would be valuable to learn this ubiquitous language.
SQL allows ready access to many different file types and data bases with
the same general metaphor of relational design and data representation of
tables of rows and columns. This language also has the particular
advantage in SAS of both a simpler and sometimes more efficient alternative
to the match-merge.
This course focuses on using Structured Query Language (SQL) for data
retrieval from SAS datasets and relational databases (SQL Server).
Emphasis will be placed on extracting and manipulating data from multiple
files or tables with simple and concise queries.
Course objectives: Upon completion, the student will be able to perform
queries on data using:
Column and row selection
Use column calculations and functions
Summarize data
Retrieve data from multiple sources using JOINs, UNIONs and other
methods
Create views, tables and indices
Prerequisites:
Knowledge of basic SAS programming including:
Submitting SAS programs on your operating system
Creating and accessing SAS datasets
Invoking SAS Procedures
Using arithmetic, comparison, and logical operations
Bio:
Chris Yindra, principal of C Y Associates Inc. and Nauset Software Inc.,
has been a Speaker, Trainer, and Data Solution Provider for over 14 years.
SAS has been a reliable tool in the many projects he has completed. Chris
has taught at hundreds of corporate facilities across the nation and has
provided numerous papers on the strengths and techniques he has utilized in
the SAS language. Techniques that have enable his company to implement
solutions across several platforms.
In addition to being a SAS Certified Professional in V8, Chris has
extensive background in database architecture, UDB SQL, Transact SQL and
other programming languages. His exceptional written and verbal skills and
ability to lead a dynamic team environment are exemplified in his skill to
share technical information and explain complicated processes. When Chris
is not expounding on the abilities of SAS, designing a data
mart, or mentoring other programmers, he is playing hard in the mountains
and lakes of Vermont, sailing off the Connecticut shore or supporting his
daughters' love of softball, skiing and road trips to Montreal.
*====================================================================*
Registration process for the Training Session
*====================================================================*
PLEASE READ THIS ENTIRE SECTION!
*====================================================================*
To register for Using SQL in SAS programming, please follow these steps:
1. Go online to pre-register by clicking the following link:
http://www.basug.org/register.php3
INDIVIDUAL, ON-LINE PRE-REGISTRATION REQUIRED FOR TRAINING. NO EMAIL! All
registrants will receive an immediate email confirmation of their
pre-registration.
Within 72 hours you will then receive another e-mail, with a customized
invoice for the training based on your membership status.
Seats are limited, so register early! Seating is guaranteed only for
pre-paid registrants.
2. Complete the invoice form and mail it along with your check by June
1, 2005 to our Treasurer, Karen Olsen at:
BASUG
PO Box 253
Boston, MA 02117
3. Note that this class is open to BASUG members only, meaning your 2005
dues must be paid up in order to attend! If you are not currently a
member, your invoice will include the 2005 BASUG membership due.
If you have any questions about your BASUG membership status, please
contact our Membership Coordinator (Robert Rosofsky)at:
Robert.Rosofsky@Verizon.net
4. Please do not mail any checks after June 1, 2005. If you miss the
mail-in deadline, bring your completed invoice form and a check made
payable to BASUG to cover the at-the-door tuition rate of $150 plus any
membership fees due as specified in your invoice form.
Full payment is due by the day of the class. There will be NO EXCEPTIONS
to this. No credit cards, no cash please!
5. REFUND POLICY: IF WE HAVE RECEIVED YOUR CHECK AND YOU NOTIFY LORI
GOLDMAN (lgoldman@ihcis.com) BY 5 P.M. ON JUNE 3, 2005, YOU WILL RECEIVE A
FULL REFUND. There are no refunds after this date.
*====================================================================*
DIRECTIONS
*====================================================================*
Holiday Inn Newton
399 Grove Street
Newton, MA 02462
617-969-5300 (phone)
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. 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. 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. 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. 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. 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. 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.). 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.
*====================================================================*
Miscellaneous
*====================================================================*
BASUG's Mail Address:
BASUG
PO Box 253
Boston, MA 02117
To email our Webmaster: webmaster@basug.org
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