-duplicates drop- is the safest way to handle these situations; if for
example you actually have var2, var3, var4..., duplicates drop will only
function (without a varlist) if all observations truly are identical
across all variables.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Richard
Williams
Sent: Wednesday, July 20, 2005 10:53 AM
To: [email protected]
Subject: Re: st: Collapsing dataset
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/
*
* 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/
