Bookmark and Share

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:52:06 +0100

Sorry, "before" here means "after". 

Nick 
[email protected] 


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
Sent: 24 April 2012 14:44
To: '[email protected]'
Subject: RE: st: RE: changing observations under one variable

Your reply to mine arrived before your reply to Tashi's. Similarly I have replied to that post. 

Nick 
[email protected] 

Rudy Hover

Nick I read your and Tashi's reply and answered your questions. What else do you need to know about the data? 

In stata it looks like

date
29jan1999
26feb1999
31mar1999
..

I need to replace the observations as they now contain data (the day) which I don't want it to contain. 

It should look like

date
199901
199902
199903
..

On Apr 24, 2012, at 2:29 PM, Nick Cox wrote:

> Please read my reply as well as Tashi's and pay attention to the questions asked. You are not telling us enough about your data. Alternatively, try reading the help for -format- to see what Tashi meant. 
> 
> Nick 
> [email protected] 
> 
> Rudy Hover
> 
> Thank you for the reply tashi
> 
> what do you mean with try format %tdCCYYdd ?
> How can I replace the observations as I meant?
> 
> On Apr 24, 2012, at 2:14 PM, tashi lama wrote:
> 
>> Try format %tdCCYYdd . 
> 
> From: [email protected]
> 
>>> 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/

*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index