The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form when you want to create a new table with columns ...

To use DICTIONARY tables in other SAS procedures or in the DATA step, use PROC SQL views that are based on the DICTIONARY tables. You can either create a PROC SQL view on a DICTIONARY table or you can ...

SwiftLearn. Contribute to jakwetey/swiftlearnSessions development by creating an account on GitHub.

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]. Creates a [!INCLUDEtsql] or common language runtime (CLR) stored procedure in [!INCLUDEssNoVersion], [!INCLUDE ssazure-sqldb], and [!INCLUDEssPDW] ...

In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." Advertisement. Article continues below this ad.

Just use an sql INSERT statement, I guess.<BR><BR>I would recommend linking the table, copying it, then deleting the link if you really don't want the link there.