SAS:using sas to connect hadoop

Geo- — Wed, 15 Aug 2018 07:01:03 GMT

Use implicit pass-through SQL to extract only 10 rows from the newtab table and load the work SAS data set with the results.

proc sql;
connect to hadoop (server=hxpduped);
create table work.a as
select * from connection to hadoop (select * from newtab limit 10);

and the connection information is the case of our school,how should I write a right connection code in sas?

Re: SAS:using sas to connect hadoop

ChrisNZ — Tue, 14 Aug 2018 11:52:18 GMT

If you already have the libname defined, just use it:

libname HAD001 hadoop ... ;

proc sql;
connect using HAD001;

create table A as select * from connection to HAD001 (select * from newtab limit 10);

quit;