Date: Fri, 23 Jul 1999 11:23:23 -0500
Reply-To: Curt Squires <csquires@MAROON.TC.UMN.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Curt Squires <csquires@MAROON.TC.UMN.EDU>
Subject: Twin Cities Area SUG July 29 Meeting Announcement
Content-Type: text/plain; charset="us-ascii"
From Eric Metz <EricMetz@DynaMark.com> of Twin Cities Area SAS Users Group:
Twin Cities Area SAS Users' Group
July 29, 1999
WHERE: Fingerhut Corporation
4400 Baker Road
Minnetonka, MN 55343
Directions: From 494, take Hwy 7 heading east. After a
short distance, take the exit on the right 'To Baker Road' which will loop
to Baker Rd. Head South (or take left) on Baker Road to Fingerhut on the
right. Look for the TCASUG designated parking. Main Phone (612) 932-3100
1:30 - 1:55 "Functioning JCL Into a SAS? Relational Database Table:
Your Portable Tutorial On Character Functions, Plus
an MVS? Batch Bonus" by Doug Zirbel (1)
2:00 - 2:15 Results of SAS Salary Survey by Fred Dalleska
2:20 - 3:15 "Customer Relationship Management: Using an integrated
SAS CRM solution to improve ROI by Jeff Livermore (2)
3:30 - 3:55 "SAS Macros Iterative Task" by Paul Coleman (3)
4:00 Drawing of 1 free book and closing
(1). This SAS 6.09e Base SAS software program running on IBM? mainframe
OS390? (MVS) gives you plenty of explained examples of useful SAS string
functions and others, as well as a handy PROC REPORT example. As an added
bonus, it crunches that old mainframe mystery, JCL (Job Control Language),
into a denormalized SAS file (table) / report which almost anyone in your
IBM mainframe shop can understand.
(2) Exploring the CRM process to better manage the collection of data,
turning that data into knowledge to better understand customer
behavior in order to build more profitable customer relationships.
(3) The SAS macro language enables iterative tasks. It works easily with
variables or data items named in sequence (i.e. var1, var2, var3, etc.).
One use for such a macro is for a PROC SQL, when the variable used to GROUP
BY or WHERE changes for each iteration in a series of queries. The macro
contains a DATA STEP that reads a list of variables and hands off, one at a
time, one variable per iteration to the PROC SQL. This same algorithm can be
used to provide input into any PROC STEP.
Doug Zirbel has been using SAS for 9 years to make mainframe and unix data
warehouses more useful to clients. He lives in Duluth, has a degree in
Computer Information Systems and a Masters in International Management.
Fred Dalleska is a Sr. Analyst for Nephrology Analytic Services of the
Minneapolis Medical Research Foundation. Fred's responsibilities include
development of new systems, maintenance of existing systems, and continued
improvement in programming standards.
Jeff Livermore is a Systems Engineer in the Minneapolis Regional Office.
His main responsibility is Data Mining with an additional focus on
SAS/Intrnet to web enable SAS applications across all platforms(Mainframe,
Unix, NT, PC).
Paul Coleman is a Sr. Analyst working for Fingerhut in the Corporate
Research and Analysis department. His background is primarily in biomedical
research and has an interest in working with relational databases.