BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi all
i am using SAS Access to extract the data from oracle clinical database
can any one tell me the code to know "what all the tables are present in the database" and how to know the contents of each table
thank you
2 REPLIES 2
deleted_user
Not applicable
First you need to define your database as a SAS library, then you could use proc contents. You can learn how to define the library here:

http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_relationdb_6988.pdf
http://www.nesug.info/Proceedings/nesug05/io/io8.pdf

PROC CONTENTS does not show the number of observations, indexes, and creation and modification dates for tables in oracle databse.

I don't know how to get the details on indexes for tables in oracle database. Does anyone know? -------
Message was edited by: Nilan

added 'tables in oracle databse' twice as my original message wasn't clear.
deleted_user
Not applicable
I don't have any Oracle Clinical databases to work with, but on SQLServer you can send an SQL Passthrough command to read the definition of the table. A number of commands work to give you table order, indexes and blocking / physical information.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 2 replies
  • 853 views
  • 0 likes
  • 1 in conversation