Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Collapsing dataset


From   Richard Williams <[email protected]>
To   [email protected]
Subject   Re: st: Collapsing dataset
Date   Wed, 20 Jul 2005 12:53:11 -0500

At 01:36 PM 7/20/2005 -0400, kelly johnson wrote:
Hi,

Suppost I have data like this:


Date            Var1
07/24/2002      10
07/24/2002      10
...
07/25/2002      12
07/25/2002      12
...
07/25/2002      14
07/25/2002      14
...

How do i get a data set like this:

Date    Var1

07/24/05  10
07/25/05  12
07/26/05  14

Thanks!
Well, I guess I would start by adding 3 to each year (do you maybe mean /02 instead of /05)? You can also use -duplicates drop- to get rid of the duplicated cases, if that is indeed what you want to do (I'm not sure; you might have typos in the data you typed in, or maybe I misunderstand what you want). See -help dfmt- for info on formatting dates.


-------------------------------------------
Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
FAX: (574)288-4373
HOME: (574)289-5227
EMAIL: [email protected]
WWW (personal): http://www.nd.edu/~rwilliam
WWW (department): http://www.nd.edu/~soc

*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/




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