Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Encode/destring


From   "Giorgia Maffini" <[email protected]>
To   <[email protected]>
Subject   st: Encode/destring
Date   Sat, 25 Feb 2006 11:07:49 +0000

Hi,

is anybody aware of how I could solve the following problem: 
I am working with a panel of more than 70,000 firms. 
When running FE and RE I need to specify the panel unit (firms in my dataset). The panel unit has to be recorded a numeric variable, as I understand. 

In my data the firm idendifier is a STRING variable with both numbers and letters. Example: firm with identifier FR12345 is different from firm with identifier GB12345. 

I used DESTRING-IGNORE but 
1) it is difficult to track down all the characters present in the firm identifier variable
2) Different firms will get the same id number. Example: FR12345 and GB12345.

I used ENCODE but I got the following error message (134): You attempted to encode a string variable that takes on more than 65,536 unique values. 

Thanks,

Giorgia

*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index