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

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Discussion stats
  • 0 replies
  • 490 views
  • 0 likes
  • 1 in conversation