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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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