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 (October 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 25 Oct 2002 06:50:23 -0700
Reply-To:     Will Dwinnell <predictr@BELLATLANTIC.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Will Dwinnell <predictr@BELLATLANTIC.NET>
Organization: http://groups.google.com/
Subject:      How to write multiple dest. records from a single source?
Content-Type: text/plain; charset=ISO-8859-1

I was hoping someone could at least get me started with solving this problem:

The source data set has 300 columns, which represent 3 measurements on 100 distinct items. The destination data set should have 3 columns (one for each measurement) and 100 times the number of records as the source. So, the first record in the destination data set will have 3 fields: fields number 1, 101 and 201 from the first record of the source data set. The second record of the destination data set will have fields 2, 102 and 202 from the first record of the source data set, and so on.

I have looked through the SAS help a little, and thought that I might be able to use ARRAYs with TRANSPOSE, but I'm not sure how to output multiple records from a single source record. Any suggestions?

Thanks!


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