Announcement

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

  • Panel Data Help Regarding Inserting Percentile Information From 1 time period to another

    Hi All,

    Just a quick question and any help would be greatly appreciated! I have included a screenshot of the data for your convenience and illustration.

    I have a panel dataset and have created deciles for income by year as shown, I need to fill in the blanks so that I may proceed with the rest of my analysis. Is there any way to 'fill in the blanks' using the observation from the same ID for the other year?

    Thank you for any and all your help!

    All the best,

    J
    Attached Files

  • #2
    Please use dataex in future to present data examples (see FAQ Advice #12). Assuming you have only these two variables starting with "Income_"

    Code:
    egen wanted=rowmax(Income_*)

    Comment


    • #3
      Hi Andrew,

      Future reference regarding the data presentation is well noted (excuse my novelty to Stata and this forum)

      That has worked! Thank you very much for your help - you're a lifesaver.

      All the best,

      J

      Comment

      Working...
      X