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: number generation
From
Tyler Frazier <[email protected]>
To
[email protected]
Subject
Re: st: RE: number generation
Date
Sun, 30 May 2010 23:46:51 +0200
I am exporting to a text file, and while the zeros were appearing in
the stata data editor, each time I used outsheet, the leading zeros
were dropped
perhaps the %03s was the problem and when changed to "%03.0f" did it
*****
bysort plot: gen bldg=string(_n, "%03.0f")
*****
works like a charm
thanks Martin!
On Sun, May 30, 2010 at 11:33 PM, Martin Weiss <[email protected]> wrote:
>
> <>
>
> Not sure what you are trying to do. If you want the counter as strings (why
> would you want that?), you can just say
>
> ***********
> bysort plot: gen bldg=string(_n)
> ***********
>
> -string()- happily accepts -format- as well.
>
>
> -tostring-`s -format()- option accepts _numeric_ formats, as you are moving
> from numeric to string. If you want to -format- the finished results, do it
> in a separate line, just as you seem to be implying.
>
>
> HTH
> Martin
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Tyler Frazier
> Sent: Sonntag, 30. Mai 2010 22:45
> To: [email protected]
> Subject: Re: st: RE: number generation
>
> I found this works, but it seems the format option should be in the
> same line with -tostring-
>
> ******
> bysort plot: gen bldg=_n
>
> tostring bldg, gen(bldg1)
>
> format %003s bldg1
> *******
>
>
> On Sun, May 30, 2010 at 10:31 PM, Tyler Frazier <[email protected]> wrote:
>> I came up with this short code based on your recommendation -- the
>> bysort works fine, but I am having problems with the format option,
>> its syntax I believe.
>>
>> *******
>> bysort plot: gen bldg=_n
>>
>> tostring bldg, gen(bldg1) format(%3s)
>> *******
>>
>>
>> On Sun, May 30, 2010 at 7:14 PM, Martin Weiss <[email protected]>
> wrote:
>>>
>>> <>
>>>
>>> The solution could be as easy as
>>>
>>>
>>> ***********
>>> bysort block: gen bldg=_n
>>> ***********
>>>
>>> See NJC`s http://www.stata-journal.com/sjpdf.html?articlenum=pr0004
>>>
>>>
>>> HTH
>>> Martin
>>>
>>>
>>> -----Original Message-----
>>> From: [email protected]
>>> [mailto:[email protected]] On Behalf Of Tyler Frazier
>>> Sent: Sonntag, 30. Mai 2010 19:02
>>> To: [email protected]
>>> Subject: st: number generation
>>>
>>> I would like to generate a method to number buildings in sequence, but
>>> restart the sequence in accordance with a group. For example I have
>>> the following nomenclature
>>>
>>> (block) (round) (plot) (bldg)
>>> 005 050 010 xxx
>>> 005 050 020 xxx
>>> 005 050 030 xxx
>>> 005 050 040 xxx ...
>>>
>>> 005 050 150 xxx ...
>>>
>>> 005 060 010 xxx ...
>>>
>>> 010 010 010 xxx ...
>>>
>>>
>>> where xxx represents a unique object identifier. I'm thinking to use
>>> gen or egen with a cond() qualifier, but how to set the parameters for
>>> the unique object identifier such that it returns sets of the
>>> following structure
>>>
>>> 005 050 010 001
>>> 005 050 010 002
>>> 005 050 010 003 ...
>>>
>>> 005 050 010 999
>>>
>>> thank you,
>>> Ty
>>> *
>>> * 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/
>
>
> *
> * 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/