BookmarkSubscribeRSS Feed
0 Likes

Using sas studio in SAS viya environment, the infile statement doesn't support wild cards see https://blogs.sas.com/content/sasdummy/2018/10/09/read-multiple-text-files/#comment-329562  to see how wildcards can be used in infile.

 

In SAS studio with SAS viya, importing one file using this logic works:

filename ACH FILESRVC folderpath = '/Users/jwalker/My Folder/My Data/';

data dsn;
infile ACH("myfile1.txt") filename=filename;

 

However when trying to use wildcards to process all the files does not work:

data dsn;
infile ACH(*.txt) filename=filename;