Announcement

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

  • Combining observations with different years' data

    I have a dataset with time series information about a group of universities. Each institution has its own unitid, which doesn't change. Each institution has its own name, but some names change, e.g. "Podunk State College" to "Podunk State University." If I reshape from tall to wide using unitid and institutitionname as my 'i' variables, it keeps the data for Podunk State College on one line and Podunk State U. on another. Is there a simple way to retain the name while getting all the data on one line? Thanks in advance!

  • #2
    use unitid only?

    Comment


    • #3
      "Is there a simple way to retain the name while getting all the data on one line?"

      Comment


      • #4
        There are 2 names. Which one do you want?

        Comment


        • #5
          when you reshape, add (first) institutitionname

          Comment


          • #6
            .
            Last edited by Welch Suggs; 08 May 2024, 11:00. Reason: (still working)

            Comment

            Working...
            X