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>
Subject: Can some one help me to develop a macro to do this job
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