Hello,
I have a problem I don't know how to tackle..I am using to append task to join two tables...One is a large sas permanent table which contains million of rows and 80 columns, and I have to append a table with 5000 rows and 80 columns, I am using permanent table as base and secondary table as the other one.
The base table variables on average has lengths around 300, and the secondary table is having average length of the columns around 3000.
After the append task is ran, it is truncating the columns from the secondary table(this is what I need) but the main problem is, it is changing length of variables of permanent table and replacing them with secondary tables variable lengths.
My permanent table size increased from 40 gb to 280 gb.
Is there any way to append the tables so that after the append task is done the resultant table have lengths from base table.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.