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           0.73 seconds
      cpu time            0.49 seconds

1
2    ;*%mend;*);*';*";**/;
3    run;
4
5
6    filename  SXLELIB '\\tsclient\C\Transferencia de Archivos\IMPORT TO
6  ! SAS\SIAM\02303_20171015132340.xml';
7    filename  SXLEMAP '\\tsclient\C\Transferencia de Archivos\IMPORT TO
7  ! SAS\SIAM\siammapV2.map';
8    libname   SXLELIB xmlv2 xmlmap=SXLEMAP access=READONLY;
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
9
10   /*
11    *  Catalog
12    */
13
14   proc datasets lib=SXLELIB;
NOTE: Writing HTML Body file: sashtml.htm
14 !                            run;

15
16   /*
17    *  Contents
18    */
19

NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.28 seconds
      cpu time            0.18 seconds


20   proc contents data=SXLELIB.alerta varnum; run;

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


21
22    *  Printing
23    */
24
25   title 'Table alerta';
26   proc print data=SXLELIB.alerta; run;

NOTE: Access by observation number not available.
      Observation numbers will be counted by PROC PRINT.
NOTE: There were 8 observations read from the data set SXLELIB.alerta.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           4.00 seconds
      cpu time            0.00 seconds


27   title;
28
29   /*
30    *  Local Extraction
31    */
32
33   DATA alerta; SET SXLELIB.alerta; run;

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: DATA statement used (Total process time):
      real time           1.98 seconds
      cpu time            0.00 seconds


34
35
36   filename prueba  pipe 'dir "\\tsclient\C\Transferencia de Archivos\IMPORT TO
36 ! SAS\siam\*.xml" /b';
37
38   data file_list;
39   length fname $20;
40   infile prueba truncover; /* infile statement for file names */
41   input fname $20.; /* read the file names from the directory */
42   call symput ('num_files',_n_); /* store the record number in a macro variable */
43   run;

NOTE: Numeric values have been converted to character values at the places given by:
      (Line):(Column).
      42: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.95 seconds
      cpu time            0.01 seconds


44
45
46   %macro fileread;
47   %do j=1 %to &num_files;
48
49   data _null_;
50   set file_list;
51   if _n_=&j;
52   call symput ('filein',fname);
53   run;
54
55
56
57   filename  SXLELIB "\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\SIAM\&filein..xml"
57 ! ;
58   filename  SXLEMAP '\\tsclient\C\Transferencia de Archivos\IMPORT TO
58 ! SAS\SIAM\siammapV2.map';
59   libname   SXLELIB xmlv2 xmlmap=SXLEMAP ;
60
61
62   proc datasets lib=SXLELIB; run;
63
64   proc contents data=sxlelib._all_ varnum; run;
65
66
67
68
69   %end; /* end of do-loop with index j */
70   %mend fileread;
71   %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: PROCEDURE DATASETS used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.07 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.04 seconds
      cpu time            0.01 seconds



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 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_20171015170200.xml


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



NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.05 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_20171017132423.xml


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



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


72
73
74   proc copy in=sxlelib out=work;
75   run;

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.94 seconds
      cpu time            0.00 seconds