Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: creating matrix


From   "Austin Nichols" <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: creating matrix
Date   Tue, 9 May 2006 11:07:04 -0400

mdgross/mdgrosscuff--
It's not clear exactly what you want here, or why, but let's suppose
you've already -infile-d your text file matrix (see -help infiling-)
and you want to reshape your data, which looks like this at the start:

row        v1        v2        v3        v4        v5
  1   0.00000   0.12704   0.06991   0.00000   0.09954
  2   0.21727   0.00000   0.18285   0.00000   0.29448
  3   0.26031   0.26513   0.00000   0.00000   0.29448
  4   0.00000   0.00000   0.00000   0.00000   0.00000
  5   0.27872   0.30490   0.25021   0.00000   0.00000

so you can -reshape- your data,
and then -generate- variables to get what you want:

reshape long v, i(row) j(col)
gen why=string(col)+char(96+row)
gen not=v if row!=col
replace not="x" if mi(not)
sort why
li, noo clean
row   col         v   why       not
  1     1   0.00000    1a         x
  2     1   0.21727    1b   0.21727
  3     1   0.26031    1c   0.26031
  4     1   0.00000    1d   0.00000
  5     1   0.27872    1e   0.27872
  1     2   0.12704    2a   0.12704
  2     2   0.00000    2b         x
  3     2   0.26513    2c   0.26513
  4     2   0.00000    2d   0.00000
  5     2   0.30490    2e   0.30490
  1     3   0.06991    3a   0.06991
  2     3   0.18285    3b   0.18285
  3     3   0.00000    3c         x
  4     3   0.00000    3d   0.00000
  5     3   0.25021    3e   0.25021
  1     4   0.00000    4a   0.00000
  2     4   0.00000    4b   0.00000
  3     4   0.00000    4c   0.00000
  4     4   0.00000    4d         x
  5     4   0.00000    4e   0.00000
  1     5   0.09954    5a   0.09954
  2     5   0.29448    5b   0.29448
  3     5   0.29448    5c   0.29448
  4     5   0.00000    5d   0.00000
  5     5   0.00000    5e         x

On 5/8/06, mdgross@comcast.net <mdgrosscuff@comcast.net> wrote:
I am trying to create a variable to represent a matrix.
I have the following text files:
<snip>
Any suggestions as to the general direction I should pursue would be greatly appreciated.
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index