BookmarkSubscribeRSS Feed
robrill
Calcite | Level 5

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!

R