Date:         Wed, 23 Mar 2005 14:59:40 -0800
Reply-To:     David Fickbohm <davefickbohm@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     DomainKeys? See http://antispam.yahoo.com/domainkeys
From:         David Fickbohm <davefickbohm@YAHOO.COM>
Subject:      Re: SAS Views in Proc SQL
Comments: To: harry.droogendyk@RBC.COM
In-Reply-To:  6667
Content-Type: text/plain; charset=us-ascii

Harry,
Your comment about being able to create sas views peaked my interest.  I found an excellant article on sas views in SUGI17 article 19-27 "Save Time Today Using SAS views".  It was written by a SAS employee so it pushes more software but I found it useful.
Thanks again
Dave

Harry Droogendyk <harry.droogendyk@RBC.COM> wrote:
You'll probably still want to create SAS datasets ( though you can create SAS views if you want, not sure what that gains you ).

To take advantage of the views created by the DBA, specify the Oracle view names in the FROM clause of the pass-thru query, eg.

proc sql;
connect to oracle ( );
create table your_sas_dataset as
select * from connection to oracle (
select fld1, fld2, fld3, fld4 from new_oracle_view
);
disconnect from oracle;
quit;

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David Fickbohm
Sent: Wednesday, March 23, 2005 3:00 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS Views in Proc SQL

People,
My ORACLE DBA created two views from one Oracle table. If I can figure out how to use them it will save me a great deal of time each day.
Currently I use code such as the following to access an oracle table or tables and then create a sas dataset. Can I just change "create table" to "create view" ?


PROC SQL;

connect to oracle(user='xxxxxxxx' pass='yyyyyyyyyyyy' path='aaaaaaaaa'); create table HOLD4.A00_buyers_ctag as select ...

Thanks

Dave





Dave Fickbohm
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice

---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!



------------------------------------------------------------

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================


Dave Fickbohm
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com