|
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
|