Announcement

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

  • What should I do to achieve the following result.?

    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input str3 code str29 value
    "A " "test1test1test1test1。"
    "A " "test2test2test2test2。"
    "A " "test3test3test3test3。"
    "B " "test1test1test1test1。"
    "B " "test2test2test2test2。"
    "B " "test3test3test3test3。"
    "B " "test4test4test4test4。"
    "C " "test1test1test1test1。"
    "C "  "test2test2test2test2。"
    end

    The results I want to achieve are:
    code value
    A test1test1test1test1。test2test2test2test2。test3tes t3test3test3。
    B test1test1test1test1。test2test2test2test2。test3tes t3test3test3。test4test4test4test4。
    C test1test1test1test1。test2test2test2test2。




  • #2
    Code:
    . clear
    
    . input str3 code str29 value
    
              code                          value
      1. "A " "test1test1test1test1。"
      2. "A " "test2test2test2test2。"
      3. "A " "test3test3test3test3。"
      4. "B " "test1test1test1test1。"
      5. "B " "test2test2test2test2。"
      6. "B " "test3test3test3test3。"
      7. "B " "test4test4test4test4。"
      8. "C " "test1test1test1test1。"
      9. "C "  "test2test2test2test2。"
     10. end
    
    .
    . gen order = _n
    
    . bysort code (order) : gen j = _n
    
    . drop order
    
    . reshape wide value, i(code) j(j)
    (j = 1 2 3 4)
    
    Data                               Long   ->   Wide
    -----------------------------------------------------------------------------
    Number of observations                9   ->   3           
    Number of variables                   3   ->   5           
    j variable (4 values)                 j   ->   (dropped)
    xij variables:
                                      value   ->   value1 value2 ... value4
    -----------------------------------------------------------------------------
    
    . list
    
         +--------------------------------------------------------+
      1. | code |                 value1 |                 value2 |
         |   A  | test1test1test1test1。 | test2test2test2test2。 |
         |--------------------------------------------------------|
         |                  value3   |                   value4   |
         |  test3test3test3test3。   |                            |
         +--------------------------------------------------------+
    
         +--------------------------------------------------------+
      2. | code |                 value1 |                 value2 |
         |   B  | test1test1test1test1。 | test2test2test2test2。 |
         |--------------------------------------------------------|
         |                  value3   |                   value4   |
         |  test3test3test3test3。   |   test4test4test4test4。   |
         +--------------------------------------------------------+
    
         +--------------------------------------------------------+
      3. | code |                 value1 |                 value2 |
         |   C  | test1test1test1test1。 | test2test2test2test2。 |
         |--------------------------------------------------------|
         |                  value3   |                   value4   |
         |                           |                            |
         +--------------------------------------------------------+
    ---------------------------------
    Maarten L. Buis
    University of Konstanz
    Department of history and sociology
    box 40
    78457 Konstanz
    Germany
    http://www.maartenbuis.nl
    ---------------------------------

    Comment

    Working...
    X