Date:         Tue, 20 Mar 2007 15:16:58 -0700
Reply-To:     Seeliger.Curt@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Seeliger.Curt@EPAMAIL.EPA.GOV
Subject:      Re: SAS vs. MS SQL
Comments: To: Sigurd Hermansen <HERMANS1@WESTAT.com>
In-Reply-To:  <CA8F89971ADA9F47A6C915BA2397844203713FBA@MAILBE2.westat.com>
Content-type: text/plain; charset=US-ASCII

Sigurd writes:
> >SAS doesn't have built in table integrity checks, yet.
>
> Curt:
> SAS does have optional data integrity constraints that become
mandatory
> when implemented. One can set up constraints on an empty dataset
> (relation) so that the constraints work as if built in. Are you
looking
> for additional capability such as identity column variables?

Hmm.  Apparently you're correct, and these have been around both longer
and more fully than I'd realized.  I'll have to take some time to mess
with these and see how they compare to some of the other databases we
have here.

Thanks for the heads up!

cur

--
Curt Seeliger, Data Ranger
CSC, EPA/WED contractor
541/754-4638
seeliger.curt@epa.gov