SAS® PROFILE
Name: Eddie De La Cadena,
Account Executive
Location: Miami
Company: SAS
SAS® History: Have
been with SAS since 1999.
Pets: One
Australian shepherd. She’s seven years
old and her name is Reina (Reina
is Queen in Spanish).
Family: My
wife Elizabeth worked for SAS from 1999
to 2003. I also have two sons, Nicolas
and Julian.
Sports/Hobbies: I
have been studying Gracie Jiu-Jitsu for eight
years.
:Ideal Weekend: Going to
the beach with my family.
Favorite
Food: Jamaican jerk chicken.
One thing
everyone using or managing a SAS®
environment should know about SAS®: SAS
users should not forget the importance
and power of SAS Enterprise Guide®.
One of my customers was having difficulty
generating one particular report.
It was taking her up to four days
just to produce this one report.
Once we introduced her to SAS Enterprise
Guide, four days was cut down to
four hours. SAS Enterprise Guide
is a simple-to-use wizard-driven
Windows application designed to
enable quick and easy access to
the SAS system. Everyone from business
analysts to SAS programmers will
benefit from the simple and intuitive
interfaces that SAS Enterprise Guide
delivers. Leveraging the power of
SAS across the enterprise – all
from your local PC – SAS Enterprise
Guide enables users to access, manage,
transform, analyze, summarize and
report, utilizing the highest quality
SAS graphics, and then easily publish
your results. With the new stored
process server in SAS®9, the work
you do in SAS Enterprise Guide can
also be easily shared with other
SAS users.
Techie Tip: How
to perform a many-to-many merge
based upon common variables.
Combine multiple data sets based upon common
variables when duplicates exist in more than one data set.
Note: In this scenario, a NOTE will be issued
to the log which states “NOTE: MERGE statements has more than one
data set with repeats of BY values.” This message is meant to be
informational.
A DATA step that performs a many-to-many
merge does not produce a Cartesian
product across a BY-Group. Understanding the nature of a many-to-many
MERGE will ensure you have chosen the correct method to combine
your data to get the desired results.
|
