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.

How do i create a variable from a longitudinal dataset where i have one row for all the times a unique individual appears more than once
How do i create a variable from a longitudinal dataset where i have one row for all the times a unique individual appears more than once

Hi everyone, first time here
I have a longitudinal data set with 3500 unique individuals that looks like something below but i want to have a new variable where each unique individual will be represented in one row and not appear multiple times.

I used this code [generate subjectID: subjectid = subjectid] to create the new variable which is a replica of the old variable but don't seem to know how to exclude all the repeat subjectid that appear more than once.
How do i proceed?

subjectid
1
1
2
3
4
4
4
5
...
3500

Thanks

BJ Data Tech Solution

0 Response to How do i create a variable from a longitudinal dataset where i have one row for all the times a unique individual appears more than once

Post a Comment