Automatic update on table_2 from table_1

[Sathish_jammy]

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!

[SASKiwi · Accepted solution]

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.

[ScottBass]

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.