SAS - Create Table

What is it?

• SAS does alot of things in memory, which makes it fast, including the creation of tables which dissapear once the session ends
• Generally, I prefix "in-memory" tables with the word "work".
• Alternatively, you don't need to prefix a table, although it may aid readability amongst your team.
• Alternatively, you can create a table, and create a physical dataset within SAS, the following will show all three examples.

Create Table Example: (In-Memory & or Physical Storage)

  Example: Prefixed

libname ABCDEFGH postgres server="Server_Address.com" port=5432 user=kevin password="P@ssW0rd" database=DBName schema=SchemaName; Proc SQL;    CREATE table work.my_temporary_table as (Select * from ABCDEFG.your_table); Quit;

  Example: Non-Prefixed

libname ABCDEFGH postgres server="Server_Address.com" port=5432 user=kevin password="P@ssW0rd" database=DBName schema=SchemaName; Proc SQL;    CREATE table my_temporary_table as (Select * from ABCDEFG.your_table); Quit;

  Example: Physical Storage

libname ABCDEFGH postgres server="Server_Address.com" port=5432 user=kevin password="P@ssW0rd" database=DBName schema=SchemaName; Proc SQL;    CREATE table my_temporary_table as (Select * from ABCDEFG.your_table); Quit; cas casauto; caslib _all_ assign; proc casutil outcaslib="ABCDEFG" sessref=casauto; load data=WL_JOB_HISTORY casout="Name_of_output" promote COPIES=0; quit;