By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Does anyone have to deal with SAS and data?

P: n/a
We have always just built databases and the Statistics people would
import the data into sas.
Now they want us to supply table names, autoid information, link
information as well as 1 to 1 and 1 to many information for each
table.

I understand that sometimes a BIG database might have 20 + tables and
some are 1 to 1 and 1 to many links.

Has anyone worked on a way to gather this information?

Table names and link information are not a problem. But the
relationship information I have no idea.

thanks for any information, links or names of books or articles I can
read up on exactly what I can supply to them.

I want to try and make this automatic so I can do it to any existing
database.. ps if there are things I can put in tables for future use
please let me know.
Aug 6 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
rkc
On Aug 6, 10:10 am, sparks <spa...@comcast.netwrote:
We have always just built databases and the Statistics people would
import the data into sas.
Now they want us to supply table names, autoid information, link
information as well as 1 to 1 and 1 to many information for each
table.

I understand that sometimes a BIG database might have 20 + tables and
some are 1 to 1 and 1 to many links.

Has anyone worked on a way to gather this information?

Table names and link information are not a problem. But the
relationship information I have no idea.

thanks for any information, links or names of books or articles I can
read up on exactly what I can supply to them.

I want to try and make this automatic so I can do it to any existing
database.. ps if there are things I can put in tables for future use
please let me know.
What format do they want it in?

The no work for you method would be to use the Documenter feature that
is
built into the Access GUI.

There are also third party documenters available.

There's also code floating around that will generate DDL statements
for
the tables including Indexes and contraints.

Aug 7 '08 #2

P: n/a
I believe that I have most of what they want done.
The main thing is I can't supply what they want in relationships.

TblMAIN
Autoid 1 ---- 1_______ Autoid TblSub
______1----- Many____ Autoid TblSub2

this type of thing.

I have given them pictures of the relationships...well we can look at
them ourselves (I wanted to say then why ask me) BUT we need it in a
nice text format so we can see it visually without all the clutter.
I do understand that sometimes a big database is confusing on this
screen and MS should give an option to just display the tables and
links. WHY show all the other stuff mades no since to me.


On Thu, 7 Aug 2008 05:15:19 -0700 (PDT), rkc <rk*@rkcny.comwrote:
>On Aug 6, 10:10 am, sparks <spa...@comcast.netwrote:
>We have always just built databases and the Statistics people would
import the data into sas.
Now they want us to supply table names, autoid information, link
information as well as 1 to 1 and 1 to many information for each
table.

I understand that sometimes a BIG database might have 20 + tables and
some are 1 to 1 and 1 to many links.

Has anyone worked on a way to gather this information?

Table names and link information are not a problem. But the
relationship information I have no idea.

thanks for any information, links or names of books or articles I can
read up on exactly what I can supply to them.

I want to try and make this automatic so I can do it to any existing
database.. ps if there are things I can put in tables for future use
please let me know.

What format do they want it in?

The no work for you method would be to use the Documenter feature that
is
built into the Access GUI.

There are also third party documenters available.

There's also code floating around that will generate DDL statements
for
the tables including Indexes and contraints.

Aug 7 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.