Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <njcoxstata@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: string panelvar problem with xtset |
Date | Fri, 8 Apr 2011 17:36:33 +0100 |
This is what -egen, group()- does, done more directly. We can in fact boil it down bysort string_id : gen num_id = _n == 1 replace num_id = sum(num_id) Nick On Fri, Apr 8, 2011 at 5:30 PM, Maarten buis <maartenbuis@yahoo.co.uk> wrote: > --- On Fri, 8/4/11, Dimitriy V. Masterov wrote: >> I am having trouble xtsetting my data. My panel variable >> is a concatenated 12 digit string block-group ID and a 4 digit >> store id. >> There are about 200,000 unique values. >> >> I cannot encode this variable because it has too many >> values. Sencode might be an option, but it has been chugging >> for some time. >> >> Any suggestions about how to solve this? > > sort string_id > by string_id : gen first = _n == 1 > gen num_id = sum(first) > drop first > * * 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/