keep original filename while importing using macro

april_cz — Thu, 25 Jul 2019 01:27:51 GMT

Hi,

I am trying to import all csv files under a folder using macro. I want to keep the original file name. (for example: original file name: data11.csv importedsas data file name: data11 .

I find following macro program can import the files, my question is how can modify it to retain the original file name rather than generate a new name.

The macro I find on line:

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0ctmldxf23ixtn1kqsoh5bsgmg8.htm&docsetVersion=9.4&locale=en

%macro drive(dir,ext); 
   %local cnt filrf rc did memcnt name; 
   %let cnt=0;          

   %let filrf=mydir;    
   %let rc=%sysfunc(filename(filrf,&dir)); 
   %let did=%sysfunc(dopen(&filrf));
    %if &did ne 0 %then %do;   
   %let memcnt=%sysfunc(dnum(&did));    

    %do i=1 %to &memcnt;              
                       
      %let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.);                    
                    
      %if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do;
       %if %superq(ext) = %superq(name) %then %do;                         
          %let cnt=%eval(&cnt+1);       
          %put %qsysfunc(dread(&did,&i));  
          proc import datafile="&dir\%qsysfunc(dread(&did,&i))" out=dsn&cnt /*this is name part I want to change*/
           dbms=csv replace;            
          run;          
       %end; 
      %end;  

    %end;
      %end;
  %else %put &dir cannot be open.;
  %let rc=%sysfunc(dclose(&did));      
             
 %mend drive;
 
%drive(c:\temp,csv)

Re: keep original filename while importing using macro

Patrick — Thu, 25 Jul 2019 08:29:24 GMT

That's a duplicate with answers already here:

https://communities.sas.com/t5/SAS-Data-Management/use-original-filename-while-importing-using-macro/m-p/576426#M17670

topic keep original filename while importing using macro in SAS Programming

keep original filename while importing using macro

Re: keep original filename while importing using macro