In reply to Chris Hemedinger.

Thanks Chris, I was able to list the files in my user folder in viya using this logic:

filename myfldr filesrvc folderPath='/Users/jwalker/My Folder/My Data';
data FILES_LISTED (keep=filename);
did = dopen('myfldr');
mcount = dnum(did);
put 'MYFLDR contains ' mcount 'member(s)...';
do i=1 to mcount;
filename = dread(did, i);
put filename;
output;
end;
rc = dclose(did);
run;
PROC SQL;
CREATE TABLE WORK.NEW_FILES AS SELECT
t1.filename
FROM WORK.FILES_LISTED t1
WHERE t1.filename LIKE "ACHA%";
QUIT;

struggling to figure out how to refer to these filename in the infile statement. I've tried:
data dsn;
set NEW_FILES;
infile myfldr(filename);

ERROR: Physical file does not exist, filename.DATA.

tried this based on my EG code that works with using a dataset to import files:
data dsn;
length location $1000;
set NEW_FILES;
location=cats("/Users/jwalker/My Folder/My Data/",filename);
infile dummy filevar=location end=done;

ERROR: Physical file does not exist, /Users/jwalker/My Folder/My Data/ACHAJ01125109019PDIN20211014164703987.ach.prd.

tried this:
data dsn;
length location $1000;
set NEW_FILES;
location=cats("/Users/jwalker/My Folder/My Data/",filename);
infile location end=done;

ERROR: No logical assign for filename LOCATION.

Any Help would be appreciated. Thanks