Hi everyone, we are using SaS Viya and CAS, and for some data preparation tasks my peers use proc sql (create table as select col1, col2 ... from table2). Once I checked the automatically created tables, these always use the Data type CHAR(n) fixed length string for text/character attributes. This causes a very big table in CAS. I am Data Engineer, if I create a new Table on a database (sql,nosql, streaming), i will always define a DDL (Data definition language) script with exact data types and length for the table. But I didn't find official documents from SAS for this, in most of Example the tables will be just created by data step, CASl, Proc SQL/Fedsql What are your strategies for creating & managing Tables in CAS? Do you use a DDL for a new Table? Have you some best practices? Thanks
... View more