BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
senu188
Quartz | Level 8

Hi,

 

What is SAS database used ? For eg SAp is using db2.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

While SAS does provide some elements typically present in database systems (like integrity rules), it is not a replacement for such.

But you do not need a DBMS to run successfully; in fact it has been my experience that running SAS with only its native table format is more efficient.

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

SAS does not rely on an external DBMS. SAS tables are stored as files.

 

But you can connect SAS to a DBMS (with the respective SAS/ACCESS module) and use its tables as if they were stored in SAS.

senu188
Quartz | Level 8
Hi,

So, we can SAS it self a database . Please correct me i am wrong
Kurt_Bremser
Super User

While SAS does provide some elements typically present in database systems (like integrity rules), it is not a replacement for such.

But you do not need a DBMS to run successfully; in fact it has been my experience that running SAS with only its native table format is more efficient.

ballardw
Super User

@senu188 wrote:
Hi,

So, we can SAS it self a database . Please correct me i am wrong

I think someone would require your definition of "database" to know if that would be wrong or not. That definition might have to very detailed because you may be covering a lot of areas.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 624 views
  • 0 likes
  • 3 in conversation