DATA Step, Macro, Functions and more

Data base

Reply
Super Contributor
Posts: 673

Data base

When SAS can do all the work that a database can,Why do we still need a database to load data from/to SAS?Excuse my ignorance!
Trusted Advisor
Posts: 2,115

Re: Data base

Not so. There is overlap in what SAS and various database products can do, but neither is completely subsumed by the other. And, even in the areas that they overlap, one might do the job better/easier/faster than the other.
Super Contributor
Super Contributor
Posts: 3,174

Re: Data base

Also, you will want to define what you mean by "database" (or data base). The SAS database architecture is not truly relational, so a suitable DBMS or RDBMS replacement with SAS would ned to be determined on an individual basis.

Scott Barry
SBBWorks, Inc.
Frequent Contributor
Posts: 102

Re: Data base

What you mean when you say that the SAS database architecture is not truly relational? You can create fifth normal form databases with indexes and constraints in SAS, and you can create completely denormalized databases in Oracle. So what is the essential difference?
Super Contributor
Super Contributor
Posts: 3,174

Re: Data base

Posted in reply to JackHamilton
I'm not going to debate this point - fundamentally we're talking about rows and columns with some enhanced functionality on top implemented through software engineering.

If you choose to say that SAS is relational, so be it.

Scott Barry
SBBWorks, Inc.

Relational database
http://en.wikipedia.org/wiki/Relational_database
Frequent Contributor
Posts: 102

Re: Data base

I wouldn't say that SAS is always relational, but it can be relational, just as Oracle can be relational (or not).

Saying that a relational database can't be implemented in SAS (especially if you have some of the newer SAS products like TSPL) would be overreaching. Saying that all Oracle or DB2 or (fill in commonly used commercial database name here) databases are relational would be just as much of a stretch.

In other words, it's the design that makes something relational, not (just) the platform.
Super User
Posts: 5,426

Re: Data base

Posted in reply to JackHamilton
I agree with Jack on the relational part. Relational models can be implemented un SAS. Database functionality to support the integrity of relational models exist in Base SAS, not in SPDE/SPDS.
What I think is not fully implemented in SAS is MS part of RDBMS, which means integrated user management, storage management, logging, change tracking etc. So I think when building mission critical systems, one tend to look for other storage solutions than SAS.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 6 replies
  • 132 views
  • 0 likes
  • 5 in conversation