I'm trying to create a table in a SQL database using proc SQL. My dataset is 200K records and has twenty variables. However, some of them are free text variables and have huge informats like $3000 -- So my final file ends up being about 2GB. I don't have any meta information on the source file so I'm not able to say if I can save space anywhere. The problem is that the table takes too long to load, about 5 hours run time.
Am I able to adjust the auto-growth? Or check what the default is?
Would the explicit SQL pass-thru be any help?
Also, not helping things is the SAS Server is in the EU and SQL Server is in the US.
I haven't tried adding these options but maybe they would help:
options compress=yes sastrace=',,,d' sastracelog=log notsuffix;
My code looks like this:
libname DB odbc noprompt="driver=XXX server=XXX database=XXX"; proc sql;
create table DB.BigTable;
as select *
from work.BigDataSet;
quit;
Edited post to include information from @ChrisNZ questions
... View more