Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: converting many rows into one


From   Arina Viseth <arina@UDel.Edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: converting many rows into one
Date   Tue, 2 Dec 2008 12:22:17 -0500 (EST)

I apologize for such short question. Hopefully, I explain better what I am looking for below. 


Here is how my dataset currently looks like:

"column 1"    "column 2"
Location A    goods1
Location A    goods2
Location A    goods3
Location B    goods2
Location B    goods3
Location B    goods4
Location B    goods6


I would like to have only one row for each location so the data would look like the following:

Location A    goods1/goods2/goods3
Location B    goods2/goods3/goods4/goods6


Any suggestion would be welcome. Thanks a lot again. 

Arina

---- Original message ----
>Date: Tue, 2 Dec 2008 18:09:09 +0100
>From: owner-statalist@hsphsun2.harvard.edu (on behalf of "Martin Weiss" <martin.weiss1@gmx.de>)
>Subject: st: RE: converting many rows into one  
>To: <statalist@hsphsun2.harvard.edu>
>
>Line for the server...
>
>Remember the FAQ, 3.2:
>
>"Many questions do not get answered because they are too short". Why do you
>want to convert your data into a single row? It is hard to think of a
>practical use for such a procedure...
>
>HTH
>Martin
>
>
>-----Original Message-----
>From: owner-statalist@hsphsun2.harvard.edu
>[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Arina Viseth
>Sent: Tuesday, December 02, 2008 6:06 PM
>To: statalist@hsphsun2.harvard.edu
>Subject: st: converting many rows into one
>
>Dear Stata users,
>
>I am trying to convert many rows into one row. 
>Any idea of how I could do it? 
>
>Thanks a lot in advance.
>
>Arina
>*
>*   For searches and help try:
>*   http://www.stata.com/help.cgi?search
>*   http://www.stata.com/support/statalist/faq
>*   http://www.ats.ucla.edu/stat/stata/
>
>*
>*   For searches and help try:
>*   http://www.stata.com/help.cgi?search
>*   http://www.stata.com/support/statalist/faq
>*   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index