topic Please just get the only file in the folder, since I don't have a filename yet.... in SAS Programming

Please just get the only file in the folder, since I don't have a filename yet....

NKormanik — Sat, 13 Feb 2021 13:34:14 GMT

See the following code:

proc import datafile="c:\2\(not sure yet).csv"
out=sas_1.really_want_this_data
dbms=csv
replace;
getnames=no;
guessingrows=max;
run;

Is there any way of asking SAS to simply grab the .csv file in C:\2\, and use whatever name it has, since I don't yet know the name of that file (or the name changes all the time)?

It is the one and only file in C:\2\.

Thanks much!

Nicholas Kormanik

Re: Please just get the only file in the folder, since I don't have a filename yet....

maguiremq — Sat, 13 Feb 2021 14:49:11 GMT

This should get you on the right path:

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=mcrolref&docsetTarget=n0js70lrkxo6uvn1fl4a5aafnlgt.htm&locale=en

It returns the file name. You might be able to store it as a macro variable and pull it based on that. Here's the code on the site:

%macro list_files(dir,ext);
  %local filrf rc did memcnt name i;
  %let rc=%sysfunc(filename(filrf,&dir));
  %let did=%sysfunc(dopen(&filrf));      

   %if &did eq 0 %then %do; 
    %put Directory &dir cannot be open or does not exist;
    %return;
  %end;

   %do i = 1 %to %sysfunc(dnum(&did));   

   %let name=%qsysfunc(dread(&did,&i));

      %if %qupcase(%qscan(&name,-1,.)) = %upcase(&ext) %then %do;
        %put &dir\&name;
      %end;
      %else %if %qscan(&name,2,.) = %then %do;        
        %list_files(&dir\&name,&ext)
      %end;

   %end;
   %let rc=%sysfunc(dclose(&did));
   %let rc=%sysfunc(filename(filrf));     

%mend list_files;
%list_files(c:\temp,sas)

Re: Please just get the only file in the folder, since I don't have a filename yet....

Reeza — Sun, 14 Feb 2021 04:52:46 GMT

Asterisks function as a wildcard. Not sure if you need the extension though or not.

/file/demo/*.CSV

Note that it will read ALL CSV if there are multiple.

Re: Please just get the only file in the folder, since I don't have a filename yet....

NKormanik — Sun, 14 Feb 2021 07:38:38 GMT

You da man, Reeza. Thanks, as always.