Date:         Thu, 7 Jun 2001 14:19:32 +0100
Reply-To:     "Dick, Paul" <Paul.Dick@UK.NYCOMED-AMERSHAM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dick, Paul" <Paul.Dick@UK.NYCOMED-AMERSHAM.COM>
Subject:      Help with accessing Oracle Clinical using SAS
Content-Type: multipart/alternative;

Hi SAS-L,

The OC consultant here is having difficulty running the sas programs OC
assembles to create sas datasets.

the code starts like this

libname extract
'/fal024/u01/app/opapps/sas_views/sas_view/ocn2/training_std/current/';
 proc sql;
 connect to oracle(path='OCN2');
create view EXTRACT.AE as select
STUDY     as STUDY   label ="Clinical Study"  format  $15.
....
rest of variables

finishes
 from TRAINING_STD$CURRENT.AE);
 disconnect from oracle;
 quit;

The problem is when I try to run this on the same unix system it comes up
with errors. There is obviously something i need to add to the program eg
what OCN2 is. Also what SAS modules do i need for this operation.

Thanks in advance,
Paul.

[text/html]