NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M4)
      Licensed to ASSYSTEM IBERIA SL - TECHEDGE, Site 70217892.
NOTE: This session is executing on the X64_7PRO  platform.



NOTE: Updated analytical products:

      SAS/STAT 14.2

NOTE: Additional host information:

 X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

NOTE: SAS initialization used:
      real time           1.15 seconds
      cpu time            0.59 seconds

1
2    filename prueba  pipe 'dir "\\tsclient\C\Transferencia de Archivos\IMPORT TO
2  ! SAS\siam\*.xml" /b';
3
4    data file_list;
5    length fname $20;
6    infile prueba truncover; /* infile statement for file names */
7    input fname $20.; /* read the file names from the directory */
8    call symput ('num_files',_n_); /* store the record number in a macro variable */
9    run;

NOTE: Numeric values have been converted to character values at the places given by:
      (Line):(Column).
      8:26
NOTE: The infile PRUEBA is:
      Unnamed Pipe Access Device,
      PROCESS=dir "\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\siam\*.xml" /b,
      RECFM=V,LRECL=32767

NOTE: 4 records were read from the infile PRUEBA.
      The minimum record length was 24.
      The maximum record length was 24.
NOTE: The data set WORK.FILE_LIST has 4 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           1.78 seconds
      cpu time            0.04 seconds


10
11
12   %macro fileread;
13   %do j=1 %to &num_files;
14
15   data _null_;
16   set file_list;
17   if _n_=&j;
18   call symput ('filein',fname);
19   run;
20
21
22
23   filename  SXLELIB "\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\SIAM\&filein..xml"
23 ! ;
24   filename  SXLEMAP '\\tsclient\C\Transferencia de Archivos\IMPORT TO
24 ! SAS\SIAM\siammapV2.map';
25   libname   SXLELIB xmlv2 xmlmap=SXLEMAP ;
26
27
28   proc datasets lib=SXLELIB; run;
29
30   proc contents data=sxlelib._all_ varnum; run;
31
32
33
34   proc copy in=sxlelib out=work;
35   run;
36
37
38   %end; /* end of do-loop with index j */
39   %mend fileread;
40   %fileread;

NOTE: There were 4 observations read from the data set WORK.FILE_LIST.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


NOTE: Processing XMLMap version 2.1.
NOTE: Libref SXLELIB was successfully assigned as follows:
      Engine:        XMLV2
      Physical Name: \\tsclient\C\Transferencia de Archivos\IMPORT TO
      SAS\SIAM\02303_20171015083020.xml
NOTE: Writing HTML Body file: sashtml.htm


NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.29 seconds
      cpu time            0.15 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.06 seconds
      cpu time            0.03 seconds



NOTE: Copying SXLELIB.alerta to WORK.ALERTA (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
      System Option for BUFSIZE was used.
NOTE: There were 9 observations read from the data set SXLELIB.alerta.
NOTE: The data set WORK.ALERTA has 9 observations and 7 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           1.65 seconds
      cpu time            0.01 seconds



NOTE: There were 4 observations read from the data set WORK.FILE_LIST.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


NOTE: Processing XMLMap version 2.1.
NOTE: Libref SXLELIB was successfully assigned as follows:
      Engine:        XMLV2
      Physical Name: \\tsclient\C\Transferencia de Archivos\IMPORT TO
      SAS\SIAM\02303_20171015132340.xml


NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.05 seconds
      cpu time            0.01 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds



NOTE: Copying SXLELIB.alerta to WORK.ALERTA (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
      System Option for BUFSIZE was used.
NOTE: There were 8 observations read from the data set SXLELIB.alerta.
NOTE: The data set WORK.ALERTA has 8 observations and 7 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           1.65 seconds
      cpu time            0.01 seconds



NOTE: There were 4 observations read from the data set WORK.FILE_LIST.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds


NOTE: Processing XMLMap version 2.1.
NOTE: Libref SXLELIB was successfully assigned as follows:
      Engine:        XMLV2
      Physical Name: \\tsclient\C\Transferencia de Archivos\IMPORT TO
      SAS\SIAM\02303_20171015170200.xml


NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.05 seconds
      cpu time            0.00 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.07 seconds
      cpu time            0.01 seconds



NOTE: Copying SXLELIB.alerta to WORK.ALERTA (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
      System Option for BUFSIZE was used.
NOTE: There were 0 observations read from the data set SXLELIB.alerta.
NOTE: The data set WORK.ALERTA has 0 observations and 7 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           1.60 seconds
      cpu time            0.00 seconds



NOTE: There were 4 observations read from the data set WORK.FILE_LIST.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


NOTE: Processing XMLMap version 2.1.
NOTE: Libref SXLELIB was successfully assigned as follows:
      Engine:        XMLV2
      Physical Name: \\tsclient\C\Transferencia de Archivos\IMPORT TO
      SAS\SIAM\02303_20171016070200.xml


NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.07 seconds
      cpu time            0.03 seconds



NOTE: Copying SXLELIB.alerta to WORK.ALERTA (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
      System Option for BUFSIZE was used.
NOTE: There were 10 observations read from the data set SXLELIB.alerta.
NOTE: The data set WORK.ALERTA has 10 observations and 7 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           1.64 seconds
      cpu time            0.00 seconds