Using Data Step to load hadoop data in CAS

robrill — Mon, 17 Feb 2020 19:43:14 GMT

Hi,

I am working in Viya V.03.05M0P110619.

I can see and load tables that are in a connected hadoop server with the following code:

proc casutil sessref="casauto";

list files incaslib="hadoopname";

run;

CAS File Information
 
                       Name                             Catalog         Schema          Type     Description
                       xxxx_baseline_xxxxx_288888_xx   XXXX_XXX_XXX    xxxx_xxx_xxx    TABLE

proc casutil sessref="casauto";
load casdata="table_from_list"
incaslib="hadoopname"
casout="loaded_table_name"
outcaslib="mycas"

promote;
run;

But I wonder if there is a way to load a file from the list produced by "list files" using a data step instead of proc casutil. Is that something that can be done, or am I stuck using proc casutil?

Thanks!

topic Using Data Step to load hadoop data in CAS in SAS Viya

Using Data Step to load hadoop data in CAS