Help using Base SAS procedures

Pass through sql or Libname

Reply
Contributor
Posts: 28

Pass through sql or Libname

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;

or

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.!!                                                                                  

PROC Star
Posts: 253

Re: Pass through sql or Libname

I would use a fast export.

Ask a Question
Discussion stats
  • 1 reply
  • 217 views
  • 0 likes
  • 2 in conversation