SQL views evaluate the data in the tables underlying the view’s definition when they’re queried. So, the benefit of using SQL views is that they always return the latest data.

A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security to your base ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

You also don't have to specify a name for your history table, but anonymous tables make me uncomfortable so I've assigned the name SalesOrderHistorical to my table. In Azure SQL Database you can also ...