Hi Dapstat, I'm trying to clon your code and I get 0 observations in the lead table. I can't find the solution, I've tried to change single to doble quotes but no result. Can you please help me? It is my first time dealing with xml files and I have hundreds to import. Thank you very much in advance. I attach the log, no errors either. filename SXLELIB '\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\sgfxml\02303_20171016070200.xml';
filename SXLEMAP '\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\SGFXML\siammapV2.map';
libname SXLELIB xmlv2 xmlmap=SXLEMAP access=READONLY;
DATA alerta; SET SXLELIB.alerta; run;
libname siamia 'C:\Users\SAS\Desktop\siamia';
filename DIRLIST pipe 'dir "\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\sgfxml\0*.xml" /b';
data dirlist ;
infile dirlist lrecl=200 truncover;
input file_name $100.;
run;
data _null_;
set dirlist end=end;
count+1;
call symputx('read'||put(count,4.-l),cats("\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\SIAM\",file_name));
call symputx('dset'||put(count,4.-l),scan(file_name,1,'.'));
if end then call symputx('max',count);
run;
data siamia.dirlist(rename=(file_name=leadfile));
set dirlist;
order=_n_;run;
options mprint symbolgen;
%macro readin;
%do i=1 %to &max;
data siamia.leadtarget&i;
set siamia.dirlist;
if &i=order;
run;
proc sql noprint;
select leadfile
into :lf
from siamia.leadtarget&i;
quit;
filename sgfxml "C:\Users\SAS\Desktop\siamia\&lf";
filename map "\\tsclient\C\Transferencia de Archivos\IMPORT TO SAS\SGFXML\siammapV2.map";
libname sgfxml xmlv2 xmlmap=map;
data siamia.lead;
set siamia.lead;
run;
%end;
%mend readin;
%readin;
... View more
