LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 -


Back to: Top of message | Previous page | Main SAS-L page