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 (November 2005, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 18 Nov 2005 19:28:56 -0500
Reply-To:   Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:   Re: Modify structure of data file
Comments:   To: sas-l@uga.edu

Keith,

Are you looking for something like the following?

data want (drop=Bandnum); retain Recorder Bander Bandnum2 Wing Weight Year Month Day; set have; Bandnum2=bandnum+0; format Bander $4.; format Bandnum2 9.; format Wing 3.; format Weight 6.1; format Year 4.; format Month 2.; format Day 2.; label Bandnum2='Band Number'; run;

Art --------- ""Keith W. Larson"" <keith_w_larson@YAHOO.COM> wrote in message news:20051118215050.65919.qmail@web51413.mail.yahoo.com... > Dear list, > > I have imported a DBF file. Now I would like to > rearrange the order, change the format, convert some > from character to numeric, and create labels. > > the variables and order are: > > Bandnum $9. > Recorder $3 > Bander $4 > Wing 20.5 > Weight 20.5 > Month 20.5 > Day 20.5 > Year 20.5 > > I would like: > > Recorder $3 > Bander $3 > Bandnum 9. > Wing 3. > Weight 6.1 > Year 4. > Month 2. > Day 2. > > With the following labels: > 'Recorder' 'Bander' 'Band Number' 'Wing' 'Weight' > 'Year' 'Month' 'Day' > > Cheers, > Keith > > > > __________________________________ > Start your day with Yahoo! - Make it your home page! > http://www.yahoo.com/r/hs


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