LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (August 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 18 Aug 2008 11:48:18 -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:      XML help plzzz
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=windows-1252

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


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