Data extraction problem from Oracle Clincal

Hi,

I used a SQL pass-through SAS program to create SAS view from Oracle Clincal. These views creating SAS program was prepared by Oracle Clinical itself corresponding to a respective table. Then I used the SAS view to create a SAS dataset. The SAS view looks good but the data set contains only 1542 rows instead of 500K +. I am using OC 3.1.1 and SAS 6.1 on HP UNIX.

Two questions:

1. How should I proceed to diagnosis the problem other than living on my OC systme people's mercy?
2. I tried to SAS/ACCESS instead of SQL pass through to create view because I wanted to know if the old access descriptors / view descriptors work in this case. However the syntax in SAS/ACCESS (DBMS=Oracle), table = FOO$CURRENT.F1 is wrong since "table = " only handles X.X but not X$X.X ! Yes, the X.X is the refering method of Oracle table. So, to use SAS/ACCESS to handle Oracle Clinical, what can I do?

Thank you very much in advance.

MPLH -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 24 1999 - 07:41:25 CDT