Hello, I'm trying to run what I thought is some quite simple code, but it's taking hours to complete. I'm trying to create a table in SAS using data from a table in Teradata. There should be around 26 million rows. Does anyone have any idea what the problem could be? I should say that I have only been using SAS for around four weeks and haven't had any training! I'm used to Oracle SQL. My code is here: %macro creator; proc sql noprint; %connect_to_teradata_dna06; create table TotalData_27NOV18 as select * from connection to tera ( select * from bsp_bd_sd_dna06.kde_cdb_pcust_totaldata_19nov18 ); disconnect from tera; quit; %mend; %creator;
... View more