| Date: | Mon, 18 Sep 2006 16:32:37 -0700 |
|---|
| Reply-To: | Stanley Gorodenski - ASRX <gorodenskis@MAIL.MARICOPA.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Stanley Gorodenski - ASRX <gorodenskis@MAIL.MARICOPA.GOV> |
|---|
| Subject: | Re: Sas Question (Re-organizing dataset) - Email has different
SMTP TO: and MIME TO: fields in the email addresses |
|---|
| In-Reply-To: | A<1158621927.514427.221330@k70g2000cwa.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of wardnine@HOTMAIL.COM
> Sent: Monday, September 18, 2006 4:25 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: [SPAM:] - Sas Question (Re-organizing dataset) -
> Email has different SMTP TO: and MIME TO: fields in the email
> addresses
>
> Suppose I have a dataset with the variables name, code1,
> code2, code3, and amount. The dataset is thousands of lines
> long, but here is a 3-line sample (the order of the 5
> variables of data is the same as the order of the variables I
> list in the first sentence of the post)...
>
> Leroy X13 H42 G91 $4,900
> Mary D14 X42 X41 $8,100
> Lynn C45 X41 H99 $3,000
>
> I need to re-arrange the data so that the name and each code
> on each row is assigned the amount on that row and for each
> variable and corresponding amount to appear on a separate
> line. So, I would need the following dataset:
>
> Leroy X13 $4,900
> Leroy H42 $4,900
> Leroy G91 $4,900
> Mary D14 $8,100
> Mary X42 $8,100
> Mary X41 $8,100
> Lynn C45 $3,000
> Lynn X41 $3,000
> Lynn H99 $3,000
>
> Is it possible to do this?
Yes.
Stan
>
> Julie
>
|
