BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8
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!
6 REPLIES 6
Doc_Duke
Rhodochrosite | Level 12
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.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
JackHamilton
Lapis Lazuli | Level 10
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?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
JackHamilton
Lapis Lazuli | Level 10
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.
LinusH
Tourmaline | Level 20
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

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 745 views
  • 0 likes
  • 5 in conversation