Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to remove a duplication from time series data

    Dear Sir,
    I have a Quarterly labour force data with different Years from 2015Q1 to 2019Q4
    the problem : the IDSAM variable repeated some times in different Quarter of the same Year, also repeated in the same Quarter for the same Year, and repeated some times in the different Quarters for different Years, so that make a duplication and no real findings
    the Question :
    how to make a command in STATA to remove this duplications in this situation?? may be loop command??
    hint: HR0A:# number of the children for the IDSAM household
    SR: serial number for all Quarters from 2015Q1 -2019Q4
    idsamHR0A : new variable for IDSAM & HR0A
    this is a variables page on stata:
    thanks alot
    Attached Files

  • #2
    I need only to stay the observations of IDSAM that not repeated and the observations that comes in the first time if in Quarter or in a Year

    Comment

    Working...
    X