| Date: | Wed, 1 Jul 2009 11:49:17 -0700 |
|---|
| Reply-To: | "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM> |
|---|
| Subject: | Re: expanding a range into values with a flag |
|---|
| In-Reply-To: | <15f3c045-a01d-4e69-a738-428b353ed63f@18g2000yqa.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
In a data step
read an observation
loop from f2 to f3
output id, loop value, f4, f5, and f6
end loop
-----Original Message-----
From: chumba
Sent: Wednesday, July 01, 2009 2:18 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: expanding a range into values with a flag
Hi All,
Here is my problem,
I have got an excel file with data like following,
id F2 F3 F4 F5 F6
aaa 1 200 2530 timbuktu
A
aaa 201 400 2500 jhumri taliya F
aaa 401 600 2110 mount abu C
aaa 1000 1999 1010 majnu ka tila X
aaa 3000 3999 1200 haldwani
F
aaa 4000 4999 1310 capo
W
aaa 9000 9999 7700 teemu G
aaa 10000 10250 2530 haifa A
aaa 10251 10500 2500 chores T
Now, F2 and F3 are low and high limits of a range, ie. for range 1-
200, F4, F5 and F6 have certain values,
in this case '2530', 'timbuktu' and 'A'.
I need to expand the range 1 - 200 into vertical values
1,2,3,4,5,6,.....200 and have '2530', 'timbuktu' and 'A' values
for F4,F5 & F6 for all values 1 to 200.
I need to have the same kind of thing for the rest of the ranges like
401-600, etc.
Now I know I would need some kind of looping for this, but my main
glitch for this is that the rnage differences are not uniform.
Can anyone please take out the time for this ridiculous problem,
hahahaha
|
