Pass through sql or Libname

LearnByMistk — Tue, 16 Jun 2015 08:23:34 GMT

Hi ,

Which approach is more suitable in extracting and processing data which is there in Teradata is this libname teralib teradata server=server user=id pwd=password;

proc sql;

connect to teradata(server=server user=id pwd=password);

create table abc as

select * from connection to teradata

(select * from employees where abcid=2);

quit;

Scenario :

I 'm extracting a huge TD table and want to do few aggregation on data but it throws me spool space error .

Fast response is really appreciable .

Thanks.!!

Re: Pass through sql or Libname

kiranv_ — Tue, 16 Jun 2015 23:13:30 GMT

I would use a fast export.

topic Re: Pass through sql or Libname in SAS Procedures

Pass through sql or Libname

Re: Pass through sql or Libname