Announcement

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

  • convert membership to group to member-member network

    Hello everyone,
    I have data on membership of self-help group and their members in which all member of group are connected through group. i want to convert this group membership to member-member connectivity. I have data in excel in the given below format
    group member
    shg1 k0015
    shg1 k0023
    shg1 k0051
    shg1 k0118
    and i want to convert this data into following format
    member1 member2
    k0015 k0023
    k0015 k0051
    k0015 k0118
    k0023 k0051
    k0023 k0118
    k0051 k0118
    can you please help me write a stata code to convert the data

  • #2
    I'm presuming you are comfortable getting your Excel file into Stata, so I have started here with a -dataex- data illustration.

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input str4 group str5(member member2)
    "shg1" "k0015" "k0118"
    "shg1" "k0015" "k0051"
    "shg1" "k0015" "k0023"
    "shg1" "k0023" "k0051"
    "shg1" "k0023" "k0118"
    "shg1" "k0051" "k0118"
    end
    //
    tempfile temp
    preserve
    rename member member2
    save `temp'
    restore
    // All pairs of observations that have the same value of group.  -joinby- is a built-in Stata command.
    joinby group using `temp' 
    // Drop re-ordered and self pairs
    drop if (member >= member2)
    list

    Comment


    • #3
      Thanks a lot Mike
      It works

      Comment

      Working...
      X