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: Unique identifier from a string name


From   Barry Quinn <[email protected]>
To   "[email protected]" <[email protected]>
Subject   RE: st: Unique identifier from a string name
Date   Thu, 24 Nov 2011 16:58:23 +0000

Brendan thanks  a lot for further comments.

Barry Quinn
Lecturer in Finance

Queens University Belfast              Tel: 028 9097 4824
Riddel Hall                                       www.qub.ac.uk/mgt
185 Stramillis Road                         www.barryquinn.com
Belfast                                             [email protected]
Northern Ireland                             @niperino
BT9 5EE                      


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Brendan Halpin
Sent: 24 November 2011 16:19
To: [email protected]
Subject: Re: st: Unique identifier from a string name

If you really need a deterministic mapping between string and integer, it might be worth dumbing down the strings as much as possible first (e.g. remove spaces, punctuation, make lowercase). Then map each symbol (in the much reduced set, perhaps only 26) to a single integer and proceed as I suggested before, but with 26 (or whatever) as the multiplier instead of 256.

I am presuming that you have strings in different datasets that you want to match, so that encode won't work because it assigns integers on the basis of the strings currently available to it. It might be worth, though, seeing if you can create a master data set (e.g. by appending rather than merging) and then encoding. You could then split out the original data sets and merge. 

Brendan
-- 
Brendan Halpin,   Department of Sociology,   University of Limerick,   Ireland
Tel: w +353-61-213147  f +353-61-202569  h +353-61-338562;  Room F1-009 x 3147
mailto:[email protected]    ULSociology on Facebook: http://on.fb.me/fjIK9t
http://teaching.sociology.ul.ie/bhalpin/wordpress         twitter:@ULSociology
*
*   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