Date:         Mon, 3 Jan 2005 21:44:01 GMT
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      how to read a xml-file into a SAS dataset

You have your table names backwards. This code works for me:

libname testdata xml 'c:\temp\test.xml' ;

proc copy in=testdata out=work ;
   select report ;
run;


Thanks,
Alan
Savian
"Bridging SAS and Microsoft Technologies"


?
nntp://news.qwest.net/comp.soft-sys.sas/
Hi,
I am trying to read a xml-file into a SAS dataset.

This is the datafile named loc_copy.xml:
----------------------------------------



GENEVA
61


HONG KONG
17


JOHANNESBURG
7


NEW YORK
92



I am running the following code:
--------------------------------
libname xmlfile xml "d:\loc_copy.xml";

proc copy in=work out=xmlfile;
select report;
run;



This is the message from the log:
---------------------------------
14 libname xmlfile xml "d:\loc_copy.xml";
NOTE: Libref XMLFILE was successfully assigned as follows:
Engine: XML
Physical Name: d:\loc_copy.xml
15
16 proc copy in=work out=xmlfile;
17 select report;
18 run;

ERROR: The file WORK.REPORT (memtype=ALL) was not found, but appears on
a SELECT statement.
WARNING: Input library WORK is empty.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds

NOTE: The SAS System stopped processing this step because of errors.

--------------


Why don't I succeed to read the file into a SAS table ?
Can anyone suggest a code that will work ?

Regards
Rune Runnest?

[comp.soft-sys.sas]