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.

Counting amount of times a specific value occurs in a variable
Counting amount of times a specific value occurs in a variable

Hi, I am trying to calculate the number of times a specific value (in this case a string) occurs in a variable, and place it in a new variable.

Code:

gen occurence_id = .

In the end I would like it to be like this:

id	occurence_id
12345678	4
45624845	1
12345678	4
51564215	3
56435158	1
12345678	4
46548675	1
51564215	3
12345678	4
51564215	3

Any ideas on how I can do this?

Kind regards,
Petar

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Counting amount of times a specific value occurs in a variable
Counting amount of times a specific value occurs in a variable

0 Response to Counting amount of times a specific value occurs in a variable

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Counting amount of times a specific value occurs in a variable Counting amount of times a specific value occurs in a variable

Related Posts with Counting amount of times a specific value occurs in a variable

0 Response to Counting amount of times a specific value occurs in a variable