Date:         Mon, 18 Aug 2008 17:04:50 -0700
Reply-To:     Sri <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sri <subhadrasri@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: XML help plzzz
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Aug 18, 5:42 pm, savian...@GMAIL.COM (Alan Churchill) wrote:
> Read it in as normal and then simply write it out using the SAS XML libname
> engine.
>
> libname test xml 'c:\temp' ;
>
> data test.MyTable ;
>    set sashelp.shoes; *replace this with your code.
> run;
>
> Alan
>
> Alan Churchill
> Savianwww.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of Sri
> Sent: Monday, August 18, 2008 12:48 PM
> To: SA...@LISTSERV.UGA.EDU
> Subject: XML help plzzz
>
> Hello All,
> I'm trying to create an XML file from my SAS dataset, using PUT
> statements.
>
> My sample dataset is:
>
> data my_xml_data;
> input Region $2. +1 Student $5. +1 Location $3. +1 Score_week 2. +1
> Score_month 2. +1 Amount_week 7.2 +1 Amount_month 7.2;
> cards;
> 01 Tom   RIC 19 66  986.00 1977.52
> 01 Tom   BLA 17 59 1210.00 3048.01
> 02 Nancy FCH 21 82 1300.00 3126.56
> 02 Nancy HER 12 48 1129.00 2075.98
> ;
>
> My goal is to create an XML file that arranges the above data in the
> format as shown below:
>
>                 Score   Amount
> Region 01
>
> Student Tom
>
> Location RIC
> Week            19      986
> Month           66      1977.52
>
> Location BLA
> Week            17      1210
> Month           59      3048
>
> Student Nancy
>
> Location FCH
> Week            21      1300
> Month           82      3126.56
>
> Location HER
> Week            12      1129
> Month           48      2075.98
>
> I'm new to XML, any help in this matter is highly appreciated.
>
> Regards
> Sri- Hide quoted text -
>
> - Show quoted text -

Thanks Alan, but i can't use either this or tagsetExcelXp as i'm
running
this on UNIX and i want to format my individual cells which can only
be
achieved using PUT statements and different tagsets of XML.

And if you take a close look at my question, i want to transpose the
data. I was told that this can be acheived using PUT statements in
XML.

I appreciate your response.