Hi
I need help and to be sure, an explanation 🙂
I would like to get in SAS two inputStreams and I get this error without to understand why and actually I don't find a example with two or more inputStreams.
20 libname stream1 xml;
NOTE: Libref STREAM1 was successfully assigned as follows:
Engine: XML
Physical Name: STREAM1
21 libname stream2 xml;
NOTE: Libref STREAM2 was successfully assigned as follows:
Engine: XML
Physical Name: STREAM2
22
23 data myexceldata1;
24 set stream1.&_WEBIN_SASNAME;
25 run;
NOTE: There were 10 observations read from the data set STREAM1.EXCEL_TABLE.
NOTE: The data set WORK.MYEXCELDATA1 has 10 observations and 4 variables.
NOTE: Compressing data set WORK.MYEXCELDATA1 increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
Le Système SAS
cpu time 0.00 seconds
26
27 data myexceldata2;
28 set stream2.&_WEBIN_SASNAME;
29 run;
ERROR: Undetermined I/O failure.
ERROR: Detected during parsing of XMLInput on or near line 1, column 1.
ERROR: The definition of the table "EXCEL_TABLE" is incorrect or corrupted.
NOTE: The DATA step has aborted abnormally.
basically i try to :
libname stream1 xml;
libname stream2 xml;
data myexceldata1;
set stream1.&_WEBIN_SASNAME;
run;
data myexceldata2;
set stream2.&_WEBIN_SASNAME;
run;
proc sort data=myexceldata1;
by clef;
run;
proc sort data=myexceldata2;
by clef;
run;
Data ensemble;
merge myexceldata1 myexceldata2;
by CLEF;
run;
proc print data=ensemble;
run;
So I declare that to try with same range just to check :
...
Dim inputStreams As SASRanges
Set inputStreams = New SASRanges
nputStreams.Add "stream1", Worksheets("Feuil1").Range("A1 : D 11")
inputStreams.Add "stream2", Worksheets("Feuil1").Range("A1 : D 11")
Set stp = sas.InsertStoredProcess("/My Folder/Merge de 2 stream", Worksheets("Feuil1").Range("L1"), , , inputStreams)