Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: RE: changing observations under one variable
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
RE: st: RE: changing observations under one variable
Date
Tue, 24 Apr 2012 14:39:51 +0100
You can apply a different -format- to get a display of just year and month.
. di %tdCCyyNN mdy(4,24,2012)
201204
You can get a date variable that is just year and month by using -mofd()- as in
gen monthdate = mofd(date)
. di %tm mofd(mdy(4,24,2012))
2012m4
This is all documented.
Nick
[email protected]
Rudy Hover
The variable 'date' has type -long-.
The format is -%d-
The label is -Date of Observation-
On Apr 24, 2012, at 2:08 PM, Nick Cox wrote:
> The word format means so many things! "29jan1999" is not a format in the sense of -format-. It might the result of setting a particular format?
>
> Is -date- a string variable? Is it a numeric variable with a date format assigned.
>
> Do you want another string variable? Do you want a numeric variable with a specified display -format-?
>
> Nick
> [email protected]
>
> Rudy Hover
>
> I have one variable called 'date' with observations in the format '29jan1999' until '19dec2006', so the last working day of the month, the month and then the year. I want to change this to the format '199901' or '200612', so I don't need the day anymore, only the year and then the month. Could you help me how to replace?
>
*
* 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/