Hallo everybody and thanks in advance for any kind of suggestion.
I am working on a large dataset about investors in mutual funds (more than 10 millions obs); every person in my dataset is currently identified by an ID code (numeric) built merging asset manager code, customer code and year code. This means that the usual shape is like 370000002973312003 (firm 37, customer 297331, year 2003): i do not have the single parts of the code, but only the whole code.
Now, the issue is that i have several observations for each person in every year, but i need to work with a typical panel setup. Usually i solve the issue using a tag command that gives me a unique identifier of each person-year combination; this time, however, i fail in using this shortcut... In particular the issue seems to be the way Stata uses to store this ID code; when i use concatenate or destring commands i obtain strange results. I was wondering if there is a way to re-code all the customers in a more convenient way through a single command.
Thanks
Simone
Related Posts with Identifier with huge codes
Identifying Total Amount for Closest Contributing Year to the Fiscal YearHi all, I have a sample data that shows the donation amount of a contributor. It is a combination o…
Selection by zone and rank Hi, I want to select 10 districts out of 24 districts by zone and a rank variable. There are 5 zon…
Interpreting quadratic terms in a multiple linear regression.Hi everyone on Statalist, I am working on a project and have run into a few obstacles. The purpose…
Xtreg output: standard errorDear Statalists, I have a basic question for which I can't find an anwer. I am using the Monte Car…
Graphing three-way interactionHi Statalist, In one of my models I include a three way interaction between two dichotomous variabl…
Subscribe to:
Post Comments (Atom)
0 Response to Identifier with huge codes
Post a Comment