Announcement

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

  • List of institutes

    Hiii,
    I have data of various institutes month wise. There is a column named institute code and another column named institute name. The data is month wise so there are repeated institutes. I want list of Institute with there code in next column. Could any one help me out with this??. I tried list command it didn't work.
    Thank you.

  • #2
    Code:
    tabdisp institute, c(code)

    Comment


    • #3
      Maybe something like
      Code:
      egen byte first = tag(institute_name institute_code)
      list institute_* if first, noobs abbreviate(20)
      or
      Code:
      bysort institute_name institute_code: generate byte first = _n == 1
      list institute_* if first, noobs sepby(institute_name) abbreviate(20)

      Comment


      • #4
        Thanks Nick, It worked and very helpful and easy to understand.
        also thanks to Joseph

        Comment

        Working...
        X