Hello, I am looking to fill a 4 by 5 matrix with the descriptive statistics (e.g. number of obs, max, min, sd, mean) of each variable. The objective is to fill each column with each variables statistics and utilize each row as a way to differentiate each variable. I would believe my code to be correct but every time I attempt to run it an "unexpected end of file" error occurs. If someone could help me out it would be excellent. The code is below:
I attempt to sum each variable separately through the tokenize, following this I attempt to utilize another foreach to extract scalars from the "sum" return and insert these values in the matrix, nevertheless, although I can extract the desired statistics the second loop, where I attempt to extract each statistic and insert it fails.
//
global areauso "area_uso_12 area_uso_14 area_uso_16 area_uso_17"
global numeroaños: word count $areauso
global colnames mean sd max min N
matrix stats = J($numeroaños,5,.)
matrix list stats
tokenize $areauso
foreach x of numlist 1/$numeroaños {
local j=0
sum ``x''
foreach y of global colnames {
local j=`j'+1
matrix stats[`n',`j']=r(`y')
}
}
//
Related Posts with Difficulties with loop in a loop, feeding a matrix values through a loop
Changing the Column Titles and adding notes using Outreg2I am trying to export a table of summary statistics using the following command: outreg2 using "res…
Constructing real rate of return variableDear Community, I am trying to construct a real rate of return on a bond of 2 years to maturity. Th…
IV estimation - panel data 2SLS and LIML model are giving me the same exact results, when i am trying to control for weak instruments.When i ran my panel IV estimation, using xtivreg2, I saw my instruments were very weak and thus trie…
How to identify if each ID has two unique values for a variableHello! I am somewhat new to Stata and have tried to find an answer to this on other threads but have…
drop observationsHello! I am new in STATA. Please help me with this issue I need to drop observations with "choice" …
Subscribe to:
Post Comments (Atom)
0 Response to Difficulties with loop in a loop, feeding a matrix values through a loop
Post a Comment