proc sql;
 connect to hadoop (user="myusr1" pw="mypwd1"
 server=hxpduped port=10000 schema=default);
create table test as
(select * from connection to hadoop
(select * from dataset limit 100;
));
disconnect from hadoop;
quit;

proc sql;
 connect to hadoop (user="myusr1" pw="mypwd1"
 server=hxpduped port=10000 schema=default);
create table test as
select * from connection to hadoop
(
select * from dataset limit 100 %str(;)
);
quit;