Date:         Wed, 17 Sep 2008 16:07:23 -0700
Reply-To:     sri <sri114in@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sri <sri114in@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Can some one help me to develop a macro to do this job
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I have a data set present

Flightid   group   distance   Tripyear
1014         a           1000       20
1234          b          2000        30
2345        a            1234        20
4341          c             150        50
2345         d            220          45
7641         b           1680          21

Data set I need should have the following label, type and length. If
the length is not specified it should get it from given data.
If the particular variable name is absent in excel sheet it should not
take it i.e I should get the Flightid, group and distance only into
required data with given label, type and length. I have several data
sets that need to be converted like this. Can some one please some
help me to develop a macro to do this job.

The following information is in excel sheet.

Var     Label                  Type     length
flightid        Flight identifier       num
group   Group of flight char    $200.
distance        Distance traveled       num