Date:         Thu, 3 Jul 2008 13:58:51 -0700
Reply-To:     Lex Jansen <lexjansen@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lex Jansen <lexjansen@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: SAS -> XML problem
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Oops, I meant: xmltype=ORACLE

On Jul 3, 4:56 pm, Lex Jansen <lexjan...@gmail.com> wrote:
> Try this option on the libname: xmltype=generic
>
> It will give: <typeact />
>
> Lex Jansen
>
> On Jul 3, 3:31 pm, r...@CDC.GOV ("Fehd, Ronald J. (CDC/CCHIS/NCPHI)")
> wrote:
>
>
>
> > I have a Concerned User who writes:
>
> > > Perhaps you know some SAS programmers who have dealt with this.
> > > The following code is one way to produce XML from a SAS dataset:
>
> > > libname Library2 'c:\temp';
>
> > > libname xmlTest xml "..\TestData.xml";
>
> > > proc copy in     = Library2
> > >           out    = xmlTest;
> > >           select   TestData;
> > > run;
>
> > > There's one difficulty with the output, however.
> > > In the following sample,
> > > the format for a record where data exists
> > > is different from the format where there's a missing value.
> > > I can't find the options or the controls to tell SAS
> > > to output each item the same way
> > > regardless of whether a value is missing.
>
> > > <?xml version="1.0" encoding="windows-1252" ?>
> > > <TABLE>
> > >    <PROVTEST>
> > >       <clia_num>01D0098765</clia_num>
> > >       <region>99</region>
> > >       <state>GA</state>
> > >       <category>99</category>
> > >       <typeact Missing=" " />
> > >       <termcd1>00</termcd1>
> > >       <currdt Missing=" " />
> > > Etc.
>
> > > We want to use the XML file to update the data on an SQL Server.
>
> > given the well-formed xml assignment:
>
> > >       <category>99</category>
>
> > I think that the Q is:
> > "Why is this happening?"
>
> > >       <typeact Missing=" " />
>
> > rather than a complete open and close
>
> > >       <typeact>" ">/typeact>
>
> > Anyone know enough xml and SAS to offer commentary?
>
> > Ronald J. Fehd, IT Spec
> > HelpDesk Level 3: SAS- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -