topic Re: SAS database in Administration and Deployment

SAS database

senu188 — Tue, 16 Feb 2021 11:10:52 GMT

Hi,

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

Re: SAS database

Kurt_Bremser — Tue, 16 Feb 2021 11:16:52 GMT

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.

Re: SAS database

senu188 — Tue, 16 Feb 2021 11:27:34 GMT

Hi,

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

Re: SAS database

Kurt_Bremser — Tue, 16 Feb 2021 11:37:55 GMT

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.

Re: SAS database

ballardw — Tue, 16 Feb 2021 15:28:18 GMT

@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.