I have the following code: PROC SQL; CONNECT TO ODBC(dsn='SomeDataSource'); CREATE TABLE Data_1 AS SELECT * FROM CONNECTION TO ODBC(select col1, col2, col3 from SomeTable); QUIT; In the source DB col1, col2, col3 are all varchar(255) It is MS SQL Server if that matters. My problem is that the size of the created table in SAS is very large relative to the data. More specifically, it looks like the table is creating all columns as char instead of varchar. We do not have any records where the length of the contents of col1, col2, or col3 are the full 255 characters. If I change the SQL portion to convert(varchar(10), col1) the resulting table is much smaller, and no data is lost as these columns are short. I don't have the ability to modify the source DB, and am forced to convert many of the columns to reduce the size of the table. I am able to get it down to under 20 MB instead of over 100 MB. I am sure I am doing something wrong and that there must be a better way for me to do it but I can't for the life of me figure it out. Any help would be appreciated.
... View more