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

[AllanBowe]

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

[Abelp9]

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         

[AllanBowe]

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.

[Abelp9]

It seems that the macro no longer gives me errors, but nevertheless these errors appear, could you tell me what they are due to? thank you very much in advance for everything

NOTE: Table WORK.DATA2 se ha suprimido.
2         + 
%mp_dirlist(path=/modelo140_202112_i2.sas7bdat,outds=work.MC2a2c57b982f308489bce3ee8061974,getattrs=NOXX,level=1,maxdepth=MAX)
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,749+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 25858048| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 0| _DISARM| 33312| _DISARM| 0.000000| _DISARM| 
      0.001318| _DISARM| 1961765693.748172| _DISARM| 1961765693.749490| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: PROCEDIMIENTO SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: La compresión del conjunto de datos WORK.DATA3  está deshabilitada porque aumentaría el tamaño del  conjunto de datos.
NOTE: The data set WORK.DATA3 has 1 observations and 0 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,752+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 1| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 136| _DISARM| 33456| _DISARM| 0.000000| _DISARM| 
      0.000871| _DISARM| 1961765693.751364| _DISARM| 1961765693.752235| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,752+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 25858048| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 136| _DISARM| 33456| _DISARM| 0.000000| _DISARM| 
      0.001962| _DISARM| 1961765693.750455| _DISARM| 1961765693.752417| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: Argument 1 to function DOPTNUM(0) at línea 24859 columna 63 is invalid.
ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, 
       or invalid.
directory=  filepath=  fref=#LN00022 fref2=  file_or_folder=  filename=  ext=  msg=  foption=  level=1 rc=0 did=0 numopts=. i=1
dnum=. midd=. dmsg=  midf=. fmsg=  _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to 
      missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      1 en 24859:63   
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DATA3 may be incomplete.  When this step was stopped there were 0 observations and 7 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,756+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33464| _DISARM| 0.000000| _DISARM| 
      0.000909| _DISARM| 1961765693.755347| _DISARM| 1961765693.756256| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: El conjunto de datos WORK.DATA3 no se ha reemplazado porque este paso se ha parado.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,756+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 25858048| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33464| _DISARM| 0.000000| _DISARM| 
      0.003239| _DISARM| 1961765693.753233| _DISARM| 1961765693.756472| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,758+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| -1| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 0| _DISARM| 33464| _DISARM| 0.000000| _DISARM| 
      0.000191| _DISARM| 1961765693.758225| _DISARM| 1961765693.758416| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
ERROR: La variable filepath no está en el archivo WORK.DATA3.

NOTE: La compresión del conjunto de datos WORK.DATA3  está deshabilitada porque aumentaría el tamaño del  conjunto de datos.
17                                                          Sistema SAS                                 15:54 Tuesday, March 1, 2022

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DATA3 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:54:53,759+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33472| _DISARM| 0.000000| _DISARM| 
      0.000561| _DISARM| 1961765693.758878| _DISARM| 1961765693.759439| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: El conjunto de datos WORK.DATA3 no se ha reemplazado porque este paso se ha parado.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,759+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 25858048| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33472| _DISARM| 0.000000| _DISARM| 
      0.002108| _DISARM| 1961765693.757494| _DISARM| 1961765693.759602| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: Sentencia DATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,762+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 326| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 0| _DISARM| 33472| _DISARM| 0.000000| _DISARM| 
      0.001293| _DISARM| 1961765693.760850| _DISARM| 1961765693.762143| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,762+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 1| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 0| _DISARM| 33480| _DISARM| 0.000000| _DISARM| 
      0.000314| _DISARM| 1961765693.762674| _DISARM| 1961765693.762988| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
base string (str1)=
compare string (str2) = directory filepath file_or_folder filename ext msg level

NOTE: Appending WORK.DATA3 a WORK.MC2A2C57B982F308489BCE3EE8061974.
NOTE: There were 1 observations read from the data set WORK.DATA3.
NOTE: 1 observations added.
NOTE: The data set WORK.MC2A2C57B982F308489BCE3EE8061974 has 327 observations and 7 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,765+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 327| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33488| _DISARM| 0.000000| _DISARM| 
      0.001154| _DISARM| 1961765693.764380| _DISARM| 1961765693.765534| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,765+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 1| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33488| _DISARM| 0.000000| _DISARM| 
      0.001123| _DISARM| 1961765693.764753| _DISARM| 1961765693.765876| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: PROCEDIMIENTO APPEND used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2022-03-01T15:54:53,766+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 25858048| _DISARM| 25591808| _DISARM| 12| _DISARM| 12| _DISARM| 8| _DISARM| 33488| _DISARM| 0.000000| _DISARM| 
      0.002249| _DISARM| 1961765693.763805| _DISARM| 1961765693.766054| _DISARM| 0.000000| _DISARM| | _ENDDISARM 

ERROR: La variable file_or_folder no está en el archivo WORK.DATA3.

[Abelp9]

It has created 160 empty folders for me, I guess what the macro will do is create 160 folders and inside the excel in question, how can I make it not create folders for me? and only copy the xlsx?

Another option will be to copy the most external folder directly

[AllanBowe]

I have not seen this behaviour before - can you share exactly what you submitted? The following extract implies you were trying to copy a file, rather than a folder, and that file is in your _root_ directory: `%mp_dirlist(path=/modelo140_202112_i2.sas7bdat`

I'm happy to jump on a call to help you debug this. Just send me a PM.

If you want to copy files rather than folders, you could use this macro: https://core.sasjs.io/mp__binarycopy_8sas.html

[Kurt_Bremser]

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

[AllanBowe]

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.