How do i store data that is executed in pass through statement?

WorkingMan — Fri, 11 Jan 2019 06:10:30 GMT

Hi. I have a pass through statement to connect to hadoop server.

The code is as below:

proc sql;
   connect to hadoop (
      server="myserver" port=10000 schema=myschema);
execute
(
select * from `myschema`.`table1` wherecofee = 'mocha'
) by hadoop;
disconnect from hadoop;

QUIT;

If i want to store the result into a SAS work table or a proper SAS table with library, how do i do so?

Re: How do i store data that is executed in pass through statement?

SASKiwi — Fri, 11 Jan 2019 08:25:33 GMT

libname MySASLib "c:\MySASFolder";

proc sql;
   connect to hadoop (
      server="myserver" port=10000 schema=myschema);
create table MySASLib.MySASTable as
select * 
from connection to hadoop
(
select * from `myschema`.`table1` wherecofee = 'mocha'
);
disconnect from hadoop;

QUIT;

topic Re: How do i store data that is executed in pass through statement? in SAS Programming

How do i store data that is executed in pass through statement?

Re: How do i store data that is executed in pass through statement?