Announcement

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

  • Export Variable Labels

    I have a large dataset with 200,000 observations. I have made a new variable that indicates unique combinations of two variables using the below code:
    egen combo=group(var1 var2), label

    There are over 3000 unique combinations.

    How do I export those unique combinations to excel? I want the information in Variable Manager>Manage value labels>combo>edit label into an excel sheet.

  • #2
    Code:
    preserve
    duplicates drop combo, force
    gen value = combo
    export excel value combo using "combinations", replace
    restore

    Comment

    Working...
    X