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
Related Posts with 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
What is the best test to compare regression coefficients when we use a probit model?Hello, I run two regressions for the same sample when the only difference is that there I include o…
How to convert the unprojected point data in lat/lon format into projected point dat, usable in spmapHi everyone, I have a list of selected airports in lat/lon format and want to scatter these points …
fixed effects relative to the mean, help needed with felsdvregdmHello everyone, I've been working on this for two days and am failed to produce the results. I reall…
How to generate monthly time series data based on yearly time series data?Hello, I am wondering how to generate monthly time series data. For example, my current data set is…
"Missing Imputed Values Produced" Error MessageI am trying to run the following mi impute command to impute infractions (INF_M6a), psychological sy…
Subscribe to:
Post Comments (Atom)
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