topic Re: Automatic update on table_2 from table_1 in SAS Programming

Automatic update on table_2 from table_1

Sathish_jammy — Tue, 29 Oct 2019 05:59:01 GMT

Dear Experts,

I attend a telephonic interview with CSS Corp. They ask me technical questions from MS-SQL Server.

I need to know whether the method is possible in SAS.

The question is: Assume you have 2 tables which have the same rows and columns.

If I modify the existing value / Add the new row in Table_1, how the table_2 automatically update the new value?.

Is there any possible methods to do automatic updates.

Please share your ideas.

Thanks in advance!

Re: Automatic update on table_2 from table_1

SASKiwi — Tue, 29 Oct 2019 05:50:49 GMT

I'm guessing that you are talking about the capability of many relational databases, including SQL Server, to automatically replicate tables between databases so that the target table is an exact copy of the source one. Is this what you mean? This feature is particularly useful when synchronising data between primary and secondary data centres.

SAS doesn't have this capability built into the product. You could build your own version of it if required though.

Re: Automatic update on table_2 from table_1

ScottBass — Tue, 29 Oct 2019 06:21:12 GMT

As @SASKiwi said, SAS does not support replication in the way SQL Server does.

"Table"_2 could be a view of table 1 though. But that's not the same as two separate physical tables that are automatically kept in sync by configuration at the table or database level.