Volatile Table Error in SAS

[sophie123]

I have code that I know works in queryman. I think transfer it to sas and create a volatile table and then save those rows and put then in a table in sas that I can then manipulate. Problem is when I do this my query never finishes because it runs out of spool space.
Anyone else have this problem
THis is the only code that I added to my SAS program.


proc sql;
Connect to teradata (user='c-sophie' password=XXXXXXXX);
execute
(
create set volatile table ringtones, NO FALLBACK, NO JOURNAL AS

(

(at the top)



) with data
primary index (svc_key)
on commit preserve rows
) by teradata;

execute (commit work) by teradata;
create table playpen.Ringtones as
select * from connection to teradata (
select * from Ringtones
);
quit;
run;

(at the bottom)

 

[teralearner]

I am not sure why you need to go through volatile table. You can create a SAS table from teradata table without going through volatile table.

proc sql;
Connect to teradata (user='c-sophie' password=XXXXXXXX);
create table YOURsasTable as
select *
from connection to teradata
(select YOURcolumns
from YOURtaradataTable
Where Whatever
);
quit;