topic Re: Refer to all files in a path in SAS with "path/*.xlsx" in New SAS User

Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Mon, 28 Feb 2022 14:37:57 GMT

Hello everyone, I am trying to automate a process and one of my programs generates about 50 files with different excel names in a specific folder within SAS. What I want to do is move those .xlsx from the folder where they are created, to another one inside SAS (That folder is my bridge between sas and windows).

How could I do this? I have been testing with the following code:

filename in "/opt/sas/data/xx/xx/xx/xx/FinalFolder/*.xlsx";
filename out "/opt/sas/data/xx/xx/xx/xx/BridgeFolder/*.xlsx";

            * copy the file byte-for-byte;
            data _null_;
             length filein 8 fileid 8;
             filein = fopen('in','I',1,'B');
             fileid = fopen('out','O',1,'B');
             rec = '20'x;
             do while(fread(filein)=0);
                rc = fget(filein,rec,1);
                rc = fput(fileid, rec);
                rc =fwrite(fileid);
             end;
             rc = fclose(filein);
             rc = fclose(fileid);
            run;

            filename in clear;
            filename out clear;

But it returns me many notes of this type:

NOTE: Argument 1 to function FPUT(0,'') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,' ') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'x') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'l') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'/') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'w') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'o') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'r') at línea 35 columna 22 is invalid.
NOTE: Argument 1 to function FPUT(0,'k') at línea 35 columna 22 is invalid.

I think the problem is in the asterisk that I use to refer to all the files in the folder (since they are called differently and I want to automate it) because when I put the specific name of a file it works for me.

Can someone give me a hand with this? Thank you very much in advance, greetings

Re: Refer to all files in a path in SAS with "path/*.xlsx"

LinusH — Mon, 28 Feb 2022 15:03:32 GMT

Wouldn't be easier to use OS comamnds to this?

Then you could use FILENAME PIPE, X statement or CALL SYSTEM.

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Mon, 28 Feb 2022 15:34:06 GMT

how could i do that?

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Kurt_Bremser — Mon, 28 Feb 2022 15:45:41 GMT

Wildcards do not work in file references.

Simplest method: use the UNIX mv command:

cd /opt/sas/data/xx/xx/xx/xx/FinalFolder
mv *.xlsx /opt/sas/data/xx/xx/xx/xx/BridgeFolder

With pure SAS means, read all .xlsx filenames into a dataset (FILENAME, FOPEN, DNUM, DREAD, FCLOSE functions), and then run a data _null_ step from that where you use the FCOPY and FDELETE functions to perform the move for every single file.

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Kurt_Bremser — Mon, 28 Feb 2022 15:49:02 GMT

@Abelp9 wrote:

how could i do that?

data _null_;
infile "cd /opt/sas/data/xx/xx/xx/xx/FinalFolder; mv *.xlsx /opt/sas/data/xx/xx/xx/xx/BridgeFolder 2&1" pipe;
input;
put _infile_;
run;

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Mon, 28 Feb 2022 15:59:06 GMT

Do you have any kind of documentation handy where I can read more about this? I am new programming in sas and it is the first time that I see those functions

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Mon, 28 Feb 2022 16:06:01 GMT

why it returns to me this error? "ERROR: Insufficient authorization to access PIPE."

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Reeza — Mon, 28 Feb 2022 16:35:29 GMT

Why not change the program to write directly to that location?

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Kurt_Bremser — Mon, 28 Feb 2022 18:07:06 GMT

@Abelp9 wrote:
why it returns to me this error? "ERROR: Insufficient authorization to access PIPE."

This means that the capability to run external commands has been disabled in your SAS environment (NOXCMD system option).

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Kurt_Bremser — Mon, 28 Feb 2022 18:20:40 GMT

@Abelp9 wrote:
Do you have any kind of documentation handy where I can read more about this? I am new programming in sas and it is the first time that I see those functions

Start here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p1q8bq2v0o11n6n1gpij335fqpph.htm

You first need the FILENAME function to create file references, as those are needed later for the DOPEN, FCOPY and FDELETE functions.

DOPEN creates a handle for the directory, which is needed for the DNUM (number of directory entries) and DREAD (retrieves a single entry) function. Use DCLOSE to remove the handle.

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Reeza — Mon, 28 Feb 2022 18:27:40 GMT

@Abelp9 wrote:
Do you have any kind of documentation handy where I can read more about this? I am new programming in sas and it is the first time that I see those functions

Those are not SAS functions. They're Operating System commands, literally a different language.

In a Windows box that would be either PowerShell or CMD commands that you can use SAS to execute.

In a Unix/Mac system that would be unix commands.

SAS can pass commands to the operating system to execute, things that you would do either via command line or clicks for example.

SAS Documentation seems down for me, but this page should illustrate the issue.

https://documentation.sas.com/doc/en/hostunx/9.4/p0w085btd5r0a4n1km4bcdpgqibt.htm

Re: Refer to all files in a path in SAS with "path/*.xlsx"

AllanBowe — Tue, 01 Mar 2022 11:08:11 GMT

You could copy the entire folder without the need for X command using this macro: https://core.sasjs.io/mp__copyfolder_8sas.html

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Tue, 01 Mar 2022 12:00:02 GMT

I have tried to save the 5 macros that macro uses (6 in total) and to put my source and destination path as arguments of the last macro but it does not work for me

Re: Refer to all files in a path in SAS with "path/*.xlsx"

AllanBowe — Tue, 01 Mar 2022 13:11:09 GMT

How do you mean "does not work" - can you share the relevant part of the log? Or describe what does happen?

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Tue, 01 Mar 2022 14:05:22 GMT

This is the code I entered:

%macro mp_copyfolder(source,target);
 
  %mp_abort(iftrue=(%mf_isdir(&source)=0)
    ,mac=&sysmacroname
    ,msg=%str(Source dir does not exist (&source))
  )
 
  %mf_mkdir(&target)
 
  %mp_abort(iftrue=(%mf_isdir(&target)=0)
    ,mac=&sysmacroname
    ,msg=%str(Target dir could not be created (&target))
  )
 
  /* prep temp table */
  %local tempds;
  %let tempds=%mf_getuniquename();
 
  /* recursive directory listing */
  %mp_dirlist(path=&source,outds=work.&tempds, maxdepth=MAX)
 
  /* create folders and copy content */
  data _null_;
    length msg $200;
    call missing(msg);
    set work.&tempds;
    if _n_ = 1 then dpos+sum(length(directory),2);
    filepath2="&target/"!!substr(filepath,dpos);
    if file_or_folder='folder' then call execute('%mf_mkdir('!!filepath2!!')');
    else do;
      length fref1 fref2 $8;
      rc1=filename(fref1,filepath,'disk','recfm=n');
      rc2=filename(fref2,filepath2,'disk','recfm=n');
      if fcopy(fref1,fref2) ne 0 then do;
        msg=sysmsg();
        putlog "%str(ERR)OR: Unable to copy " filepath " to " filepath2;
        putlog msg=;
      end;
    end;
    rc=filename(fref1);
    rc=filename(fref2);
  run;
 
  /* tidy up */
  proc sql;
  drop table work.&tempds;
 
%mend mp_copyfolder;
%mp_copyfolder(/opt/sas/data/xx/xx/xx/xx/FinalFolder/,/opt/sas/data/xx/xx/xx/BridgeFolder/)

And it returns this error:

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Transferencia_archivos';
4          %LET _CLIENTPROCESSFLOWNAME='Autoexec';
5          %LET _CLIENTPROJECTPATH='C:\xx\xx\xx\xxxx\xxxx.egp';
6          %LET _CLIENTPROJECTNAME='xxxx.egp';
NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
7          %LET _SASPROGRAMFILE=;
8          
9          ODS _ALL_ CLOSE;
10         OPTIONS DEV=PNG;
1          ;*';*";*/;quit;run;
                ______________
                49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
             between a quoted string and the succeeding identifier is recommended.

11         GOPTIONS XPIXELS=0 YPIXELS=0;
12         FILENAME EGSR TEMP;
13         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14             STYLE=HtmlBlue
15             STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
15             STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css"

___________________________________________________________________________________________                                         
                                                                                                                         49
15       ! )
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
             between a quoted string and the succeeding identifier is recommended.

16             NOGTITLE
17             NOGFOOTNOTE
18             GPATH=&sasworklocation
19             ENCODING=UTF8
20             options(rolap="on")
21         ;
22         
23         GOPTIONS ACCESSIBLE;
24         %macro mp_copyfolder(source,target);
25         
26           %mp_abort(iftrue=(%mf_isdir(&source)=0)
27             ,mac=&sysmacroname
28             ,msg=%str(Source dir does not exist (&source))
29           )
30         
31           %mf_mkdir(&target)
32         
33           %mp_abort(iftrue=(%mf_isdir(&target)=0)
34             ,mac=&sysmacroname
35             ,msg=%str(Target dir could not be created (&target))
NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.

I don't know very well if I have to modify something inside the macro, I'm trying to copy all the contents of a folder and move it to another path inside the SAS server

Thank you so much for help me

Re: Refer to all files in a path in SAS with "path/*.xlsx"

AllanBowe — Tue, 01 Mar 2022 14:15:12 GMT

It appears you have imbalanced quotation marks. Can you try again in a clean (new) SAS session?

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Kurt_Bremser — Tue, 01 Mar 2022 14:15:31 GMT

Start a new SAS session. You had unbalanced quotes or a missing %MEND statement (or similar) further up in your submitted code.

Re: Refer to all files in a path in SAS with "path/*.xlsx"

AllanBowe — Tue, 01 Mar 2022 14:25:45 GMT

Here is the test for the mp_copyfolder() macro: https://core.sasjs.io/mp__copyfolder_8test_8sas_source.html

We create a folder with some content, copy it, and compare the directory listing between the old and the new folder. The test is executed with every release of the core library. If there's a bug in a core macro, our first action is to reproduce it with a test, then make the fix.

Re: Refer to all files in a path in SAS with "path/*.xlsx"

Abelp9 — Tue, 01 Mar 2022 14:28:42 GMT

It returns this:

71         %mend mp_copyfolder;
72         %mp_copyfolder(/opt/sas/data/xx/xx/xx/xx/FinalFolder/,/opt/sas/data/xx/xx/xx/xxx/BridgeFolder/)

NOTE: Compression of the WORK.DATA1 dataset is disabled because it would increase the size of the dataset.
NOTE: The data set WORK.DATA1 has 1 observations and 0 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,669+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 1| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 136| _DISARM| 2032| _DISARM| 0.000000| _DISARM| 
      0.000885| _DISARM| 1961763947.668653| _DISARM| 1961763947.669538| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,669+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 144| _DISARM| 2032| _DISARM| 0.010000| _DISARM| 
      0.002187| _DISARM| 1961763947.667533| _DISARM| 1961763947.669720| _DISARM| 0.010000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            %mp_dropmembers(%scan(&outds,-1,.), libref=WORK)
              _
              180
WARNING: Apparent invocation of macro MP_DROPMEMBERS not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                              length directory
                                                                                                                ______
                                                                                                                180
72       ! filepath $500 fref fref2 $8 file_or_folder $6 filename $80     ext $20 msg $200 foption $16;   if _n_=1 then call
72       ! missing(of _all_);

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            data &out_ds(compress=no     keep=file_or_folder filepath filename ext msg directory level   );   length directory
72       ! filepath $500 fref fref2 $8 file_or_folder $6 filename $80     ext $20 msg $200 foption $16;   if _n_=1 then call
                                                                                                          __
                                                                                                          180
72       ! missing(of _all_);
ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            retain level &level;
              ______
              180
3                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022


ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              rc = filename(fref, "&path");
                __
                180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            if rc = 0 then do;
              __
              180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                   did = dopen(fref);
                                     ___
                                     180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                               numopts=doptnum(did);
                                                                 _______
                                                                 180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                         do i=1 to numopts;
                                                                                           __
                                                                                           180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                                  foption=doptname
                                                                                                                    _______
                                                                                                                    180
72       ! (did,i);       if foption=:'Directory' then i=numopts;     end;     directory=dinfo(did,foption);     if did=0 then do;

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                if foption=:'Directory' then i=numopts;

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              end;

4                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              directory=dinfo(did,foption);

_________                                                                                                                           

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              if did=0 then do;

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            if rc = 0 then do;     did = dopen(fref);          numopts=doptnum(did);     do i=1 to numopts;
72       ! foption=doptname(did,i);       if foption=:'Directory' then i=numopts;     end;     directory=dinfo(did,foption);     if
72       ! did=0 then do;       putlog
                                ______
                                180
ERROR 180-322: Statement is not valid or it is used out of proper order.


NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                              msg=sysmsg();
                                                                ___
                                                                180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                  put _all_;
                                                                                    ___
                                                                                    180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                   stop;
                                                                                                     ____
                                                                                                     180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                             end;
                                                                                                               ___
                                                                                                               180
5                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022


ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                                      rc =
                                                                                                                        __
                                                                                                                        180
72       ! filename(fref);   end;   else do;     msg=sysmsg();     put _all_;     stop;   end;   dnum = dnum(did);   do i = 1 to

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            end;

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            else do;

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              msg=sysmsg();

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              put _all_;

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              stop;

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            end;
6                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022


___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            dnum = dnum(did);

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72            do i = 1 to dnum;

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              filename =

________                                                                                                                            

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                             filepath=cats(directory,'/',filename);
                               ________
                               180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                        rc = filename(fref2,filepath);
                                                                          __
                                                                          180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                           midd=dopen(fref2);
                                                                                                             ____
                                                                                                             180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                                             
72       ! dmsg=sysmsg();     if did > 0 then file_or_folder='folder';     rc=dclose(midd);     midf=fopen(fref2);     fmsg=sysmsg()
7                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022

           ____
           180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              if did > 0 then file_or_folder='folder';

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              rc=dclose(midd);

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              midf=fopen(fref2);

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              fmsg=sysmsg();

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              if midf

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                              rc=fclose(midf);
                                                __
                                                180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
8                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022

72                                                                     if index(fmsg,'File is in use') or index(dmsg,'is not a
                                                                       __
                                                                       180
72       ! directory')       then file_or_folder='file';     else if index(fmsg,'Insufficient authorization') then

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              else if index(fmsg,'Insufficient authorization') then file_or_folder='file';

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              else if

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                if file_or_folder='file' then do;
                                                                  __
                                                                  180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                                                                        ext =
                                                                                                          ___
                                                                                                          180
72       ! prxchange('s/.*\.{1,1}(.*)/$1/', 1, filename);       if filename = ext then ext = ' ';     end;     else do;       ext=''

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                if filename = ext then ext = ' ';

__                                                                                                                                  

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              end;

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

9                                                           Sistema SAS                                 15:24 Tuesday, March 1, 2022

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              else do;

____                                                                                                                                

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                ext='';

___                                                                                                                                 

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                file_or_folder='folder';

______________                                                                                                                      

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72              end;
                ___
                180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                       output;
                         ______
                         180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                 end;
                                   ___
                                   180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                        rc = dclose(did);
                                          __
                                          180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "MP_DIRLIST".
72                                                            stop;
                                                              ____
10                                                          Sistema SAS                                 15:24 Tuesday, March 1, 2022

                                                              180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,678+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| -1| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2032| _DISARM| 0.000000| _DISARM| 
      0.000210| _DISARM| 1961763947.678400| _DISARM| 1961763947.678610| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
ERROR: La variable filepath no está en el archivo WORK.DATA1.

NOTE: La compresión del conjunto de datos WORK.DATA1  está deshabilitada porque aumentaría el tamaño del  conjunto de datos.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DATA1 may be incomplete.  When this step was stopped there were 0 observations and 0 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,679+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 8| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 
      0.000574| _DISARM| 1961763947.679081| _DISARM| 1961763947.679655| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: El conjunto de datos WORK.DATA1 no se ha reemplazado porque este paso se ha parado.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,679+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 16| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 
      0.002204| _DISARM| 1961763947.677621| _DISARM| 1961763947.679825| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

WARNING: Apparent invocation of macro MF_EXISTDS not resolved.
ERROR: Required operator not found in expression: %mf_existds(&outds) 
ERROR: The macro MP_DIRLIST will stop executing.
ERROR: El archivo WORK.MC60F77C8BAE371B48927CFA233E5F19.DATA no existe.

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      2836:190   2836:238   72:149     
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,682+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 
      0.001116| _DISARM| 1961763947.681176| _DISARM| 1961763947.682292| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

WARNING: El archivo WORK.MC60F77C8BAE371B48927CFA233E5F19.DATA no existe.
WARNING: Table WORK.MC60F77C8BAE371B48927CFA233E5F19 no se ha suprimido.
73         
74         GOPTIONS NOACCESSIBLE;
75         %LET _CLIENTTASKLABEL=;
76         %LET _CLIENTPROCESSFLOWNAME=;
77         %LET _CLIENTPROJECTPATH=;
78         %LET _CLIENTPROJECTNAME=;
79         %LET _SASPROGRAMFILE=;
80         
81         ;*';*";*/;quit;
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:25:47,688+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 21139456| _DISARM| 20086784| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 2048| _DISARM| 0.000000| _DISARM| 
      0.001127| _DISARM| 1961763947.687196| _DISARM| 1961763947.688323| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: PROCEDIMIENTO SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
11                                                          Sistema SAS                                 15:24 Tuesday, March 1, 2022

81       !                run;

82         ODS _ALL_ CLOSE;
83         
84         
85         QUIT; RUN;
86

Re: Refer to all files in a path in SAS with "path/*.xlsx"

AllanBowe — Tue, 01 Mar 2022 14:33:48 GMT

ok - getting there!

The sasjs/core macros are designed to work together. There are many ways to compile the macros - probably the most straightforward (if not the most efficient) is to run the code below:

filename mc url "https://raw.githubusercontent.com/sasjs/core/main/all.sas";
%inc mc;

Alternatively, just copy paste the code from this url: https://raw.githubusercontent.com/sasjs/core/main/all.sas

Then you can invoke the mp_copyfolder macro.