using eg effectively - Stratia

using SAS Enterprise Guide EffectivelyWho Does What Where ?Now What ?EG Default BehaviourEG Default SetupEG SASUSER EG ProfilesEG ProfilesEG AUTOEXEC --- kindaEG Who Does What Where ? different libraries different databases millions of rows SY tomorrow !EG Who Does What Where ? same library same database candidate for pass-throughWhat is Pass-Through ? SAS Access engines for RDBMS eg. Teradata, Oracle, ODBC essentially APIs to communicate with the DB explicit pass-through explicit pass-throughoSAS program connects to DBoSQL is passed through to DB SQL must be native to DB implicit pass-throughoSAS decidesand takes care of it for youExplicit Pass-Through open a program window in EGproc sql;connect toteradata ( user=&user pass="&pass"server= create tablepp_sum_cubeasselect* fromconnection to teradataselect* fromconnection to teradata( , m.))

EG –Who Does What Where ? • same library • same database • candidate for pass-through

Loading..

Tags:

  Using, Effectively, Using eg effectively

Information

Related search queries