| Date: | Thu, 14 Apr 2005 17:57:50 -0700 |
|---|
| Reply-To: | juanwu36@HOTMAIL.COM |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | juanwu36@HOTMAIL.COM |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Why cann't I use Oracle database view the same way as SAS view? |
|---|
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
All great SAS-Ls,
When I submit the following code in SAS, I get an error message in the
log, and no data set is created. Here oralib is a library to a oracle
database, and test_results_v is a view in this oracle database. The log
messages are also included below.
Can anybody explain why I cann't treat orale database view the same way
as we usually work on normal sas data step view? Is there any way to
get information from an oracle database view?? Any help is great
appreciated!
Juan
data one;
set oralib.test_results_v ;
run;
ERROR: Invalid sequence of commands for file
ORALIB.TEST_RESULTS_V.DATA.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ONE may be incomplete. When this step was
stopped there were 0
observations and 119 variables.
WARNING: Data set WORK.ONE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.05 seconds
| 
