Prev: Help in reading a flat file.
Next: transport format catalog from sas v6 to v9
From: rjf2 on 11 Dec 2009 09:34
passing along a user note:

> From: A Concerned Reader
> Subject: SAS -> XML

> I discovered a difference in the way SAS 9.1.3
> creates the XML file and the way SAS 9.2 creates it.
> It's not a big deal,
> but users will need to make adjustments in the programs
> that read the XML file.

> SAS 9.1.3:

> <?xml version="1.0" encoding="windows-1252" ?>
> <TABLE>
> <PROVIDERTEST>
> <ID_num>01D0026356</ID_num>
> .
> .
> .
> </PROVIDERTEST>
> </TABLE>

> SAS 9.2
>
> <?xml version="1.0" encoding="windows-1252" ?>
> <LIBRARY type="GENERIC" version="9.2">
> <PROVIDERTEST>
> <clia_num>01D0026356</clia_num>
> <region>04</region>
> .
> .
> .
> </PROVIDERTEST>
> </LIBRARY>
>

summary:

> Where SAS 9.1.3 uses the delimiter 'TABLE' alone
> while SAS 9.2 uses 'LIBRARY' and other text using the same SAS code.
> While the MS SQL Server Integration Service process
> runs correctly (i.e. no error report),
> no data load into the table.
> It might be useful to let other SAS users
> know about this before they spend half a day
> figuring out why their data transfer process doesn't work.
 | 
Pages: 1
Prev: Help in reading a flat file.
Next: transport format catalog from sas v6 to v9