BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Generating a yearly count variable based on a string identifier
Generating a yearly count variable based on a string identifier

Hi Everyone,

I am looking to create a yearly count and cumulative sum variable based on a string identifier, CUSIP. Following is the example generated by dataex:

input long patent_num int cites str8 CUSIP str4 year
3915372 16 "00003210" "1975"
3946915 37 "00003210" "1976"
3935990 20 "00003210" "1976"
3935991 17 "00003210" "1976"
4039119 12 "00003210" "1977"
4039121 19 "00003210" "1977"
5839505 34 "00036020" "1998"
5826641 24 "00036020" "1998"
5738167 10 "00036020" "1998"

So for example, for the CUSIP code 00036020, the count for patent would be 3 and the cumulative cite would be 68 (34+24+10). What should be the appropiate code to generate such count variables for inputs like patent, cites etc?

Thanks in advance!

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Generating a yearly count variable based on a string identifier
Generating a yearly count variable based on a string identifier

0 Response to Generating a yearly count variable based on a string identifier

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Generating a yearly count variable based on a string identifier Generating a yearly count variable based on a string identifier

0 Response to Generating a yearly count variable based on a string identifier