itsp

ldinvest.dta		ch8.2.do:77
	→	ldinvest.dta	↘
		ch8.2.do:72		ldinvest.dta
		ch8.2.do:79		check82

```
ldinvest.dta open
file:data:dta
```

All properties
key	content
N	160
datasignature	160:4(64551):3933631731:2277314437
date	Wed Sep 23 21:31:41 EST 2015
lastmodified	1443007901000
panelvar	company
timevar	year
variables	4

Variable Graph Type N Descriptives Label

[+] company
@ldinvest.dta

category
(float)

160
(10)

"1", "2", "3", "4", "5", "6", "7", "8", "9", "10"

All properties
key	content
N	160
N_unique	10
class	category
freq	16, 16, 16, 16, 16, 16, 16, 16, 16, 16
max	10.000
mean	5.500
min	1.000
names	"1", "2", "3", "4", "5", "6", "7", "8", "9", "10"
sd	2.881
type	float
values	1, 2, 3, 4, 5, 6, 7, 8, 9, 10

file # command

ch8.2.do:

55 [+]

tsline invrate if inrange(company, 1, 4) & year >= 1937 , by(company, ti(" ")) /// yline(0) ysc(range(-0.2 0.3)) ytick(-0.2(0.1)0.3) ylab(-0.2(0.1)0.3) /// scheme(s2mono)

Data Manipulations with company
file	#	command

Script Output


company:                                        Number of Observations
----------                                  ------------------------------
                                            Total   Integers   Nonintegers
|  #   #   #   #   #         Negative           -         -          -
|  #   #   #   #   #         Zero               -         -          -
|  #   #   #   #   #         Positive         160       160          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total            160       160          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1                    10                       160
  (10 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
     company |       160         5.5    2.881299          1         10
@mean     5.500
@sd     2.881
@min     1.000
@max    10.000
@values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
@names "1", "2", "3", "4", "5", "6", "7", "8", "9", "10"
@freq 16, 16, 16, 16, 16, 16, 16, 16, 16, 16
@type float
@label 
@class category
@N_unique 10
@N 160

[+] rolling_ldinvest
@ldinvest.dta

other
(float)

160
(.)

(x̄=0.060, 0.130) [-0.229,0.475]

r(mean)

All properties
key	content
N	160
N_unique	.
class	other
example0	-.06966559
histh	.74510694, .74510694, 2.022433, 2.3417647, 2.76754, 2.8739839, 2.4482086, 2.022433, .42577538, .42577538, .10644384, .10644384
histw	-.1999256, -.1412092, -.0824928, -.0237764, .03494001, .09365641, .15237282, .21108922, .26980561, .32852203, .38723844, .44595483
label	r(mean)
max	0.475
mean	0.060
min	-0.229
sd	0.130
type	float

file # command

ch8.2.do:

81 [+]

summarize invrate rolling_ldinvest

file # command

ch8.2.do:

74 [+]

rename _stat_1 rolling_ldinvest

Script Output


rolling_ldinvest:  r(mean)                      Number of Observations
--------------------------                  ------------------------------
                                            Total   Integers   Nonintegers
|      #                     Negative          52         -         52
|      #   #                 Zero               1         1          -
|      #   #                 Positive         107         -        107
|      #   #                                -----     -----      -----
|      #   #   #             Total            160         1        159
|  #   #   #   #   .         Missing            -
+----------------------                     -----
-.2292838       .475313                       160
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
rolling_ld~t |       160    .0602769    .1303373  -.2292838    .475313
@mean     0.060
@sd     0.130
@min    -0.229
@max     0.475
@example0 -.06966559
@histh .74510694, .74510694, 2.022433, 2.3417647, 2.76754, 2.8739839, 2.4482086, 2.022433, .42577538, .42577538, .10644384, .10644384
@histw -.1999256, -.1412092, -.0824928, -.0237764, .03494001, .09365641, .15237282, .21108922, .26980561, .32852203, .38723844, .44595483
@type float
@label r(mean)
@class other
@N_unique .
@N 160

[+] start
@ldinvest.dta

category
(float)

160
(16)

"1937", "1938", "1939", "1940", ".. "1951", "1952"

All properties
key	content
N	160
N_unique	16
class	category
freq	10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10
max	1952.000
mean	1944.500
min	1937.000
names	"1937", "1938", "1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952"
sd	4.624
type	float
values	1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952

Data Manipulations with start
file	#	command

Script Output


start:                                          Number of Observations
--------                                    ------------------------------
                                            Total   Integers   Nonintegers
|                  #         Negative           -         -          -
|                  #         Zero               -         -          -
|  #   #   #   #   #         Positive         160       160          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total            160       160          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1937               1952                       160
  (16 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       start |       160      1944.5    4.624246       1937       1952
@mean  1944.500
@sd     4.624
@min  1937.000
@max  1952.000
@values 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952
@names "1937", "1938", "1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952"
@freq 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10
@type float
@label 
@class category
@N_unique 16
@N 160

[+] year
@ldinvest.dta

category
(float)

160
(16)

"1939", "1940", "1941", "1942", ".. "1953", "1954"

All properties
key	content
N	160
N_unique	16
class	category
freq	10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10
max	1954.000
mean	1946.500
min	1939.000
names	"1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952", "1953", "1954"
sd	4.624
type	float
values	1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952, 1953, 1954

file # command

ch8.2.do:

25 [+]

levelsof year , local(yrlist)

55 [+]

tsline invrate if inrange(company, 1, 4) & year >= 1937 , by(company, ti(" ")) /// yline(0) ysc(range(-0.2 0.3)) ytick(-0.2(0.1)0.3) ylab(-0.2(0.1)0.3) /// scheme(s2mono)

file # command

ch8.2.do:

29 [+]

reshape wide expp avgsal math4sat math7sat , i(distid) j(year)

40 [+]

reshape long expp avgsal math4sat math7sat , i(distid) j(year)

54 [+]

label var invrate "Three-year average investment rate"

73 [+]

rename end year

75 [+]

keep if year >= 1939

Script Output


year:                                           Number of Observations
-------                                     ------------------------------
                                            Total   Integers   Nonintegers
|                  #         Negative           -         -          -
|                  #         Zero               -         -          -
|  #   #   #   #   #         Positive         160       160          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total            160       160          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1939               1954                       160
  (16 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |       160      1946.5    4.624246       1939       1954
@mean  1946.500
@sd     4.624
@min  1939.000
@max  1954.000
@values 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952, 1953, 1954
@names "1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952", "1953", "1954"
@freq 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10
@type float
@label 
@class category
@N_unique 16
@N 160

Content



>  * A do file to run the standard stats for a whole data set. 
>  *
>  * Note that you must delete the files in the derived directory
>  * for changes to be reflected in the output.
>  *
>  * @version 0.1
> */
(rolling: summarize)

Contains data from /Users/mas/Dropbox/Stata_conference_2015/itsp/ldinvest.dta
  obs:           160                          rolling: summarize
 vars:             4                          30 Jan 2009 15:07
 size:         2,560                          
Sorted by:  company  year
@N 160
@variables 4
  160:4(64551):3933631731:2277314437
@datasignature 160:4(64551):3933631731:2277314437
       panel variable:  company (strongly balanced)
        time variable:  year, 1939 to 1954
                delta:  1 unit
@timevar year
@panelvar company
. 
  2. 
  3. qui {
  4. local category_cutoff = 30
  5. 
  6. local unique = ""
  7. local total = ""
  8. local class = ""
  9. 
 10. local label : variable label `var' 
 11. 
 12. 
 13. if ( !_rc ) {
 14.     // we now it is a string
 15.     capture tab `var', matcell( freq )
 16.     if ( !_rc ) {
 17.     
 18.         local unique = r(r)
 19. 
 20.         forvalues i=1/`unique' {
 21.             if ( `i' == 1 ) {
 22.                 noi di "@freq " _continue
 23.             }
 24.             noi di freq[`i',1] _continue
 25.             if ( `i' == `unique' ) {
 26.                 noi di ""
 27.             }
 28.             else {
 29.                 noi di ", " _continue
 30.             }
 31.         }
 32. 
 33.         local i = 1
 34.         foreach l of local levels {
 35.             if ( `i' == 1 ) {
 36.                 noi di "@values " _continue
 37.             }
 38.             noi di `""`l'""' _continue
 39.             if ( `i' == `unique' ) {
 40.                 noi di ""
 41.             }
 42.             else {
 43.                 noi di ", " _continue
 44.             }
 45.             local i = `i' + 1
 46.         }
 47.         }
 48.         
 49.             local class = "empty"
 50.         }
 51.         else if ( `unique' == 1 ) {
 52.             local class = "constant"
 53.         }
 54.         else if ( `unique' == 2 ) {
 55.             local class = "dummy"
 56.         }
 57.         else if ( `unique' < `category_cutoff' & `unique' < `total' ) {
 58.             local class = "category"
 59.         }
 60.         else if (`unique' == `total') {
 61.             local class = "identifier"
 62.         } 
 63.         else {
 64.             local class = "string"
 65.         }        
 66.     }
 67.     else {
 68.         // lots of observations, not sure what to do yet
 69.     }
 70. }
 71. else {
 72.     // else assume it is numeric
 73. 
 74.     local unique = r(N_unique)
 75. 
 76.         local cat = "YES"
 77.     }
 78. 
 79.         if ( `total' == 0 ) {
 80.             local class = "empty"
 81.         }
 82.         else if ( `unique' == 1 ) {
 83.             local class = "constant"
 84.         }
 85.         else if ( `unique' == 2 ) {
 86.             local class = "dummy"
 87.         }
 88.         else if ( `unique' < `category_cutoff' & `unique' < `total' ) {
 89.             capture confirm string variable `var'
 90.             if ( !_rc ) {
 91.                 local class = "other"
 92.             } 
 93.             else {
 94.                 local class = "category"
 95.             }
 96.         }
 97.         else if (`r(N_unique)' == `r(N)') {
 98.             local class = "identifier"
 99.         }
100.     }
101. 
102.     local min = r(min)
103.     local max = r(max)
104.     local nobs = r(N)
105.     
106.         noi di "@mean " %9.0f r(mean)
107.     } 
108.     else {
109.         noi di "@mean " %9.3f r(mean)
110.     }
111.     noi di "@sd " %9.3f `r(sd)'
112.     // noi di "@skewness " %9.3f `r(skewness)'
113.       noi di "@min " %9.3f `r(min)'
114.       noi di "@max " %9.3f `r(max)'
115.       // noi di "@p50 " %9.3f `r(p50)'
116.     else {
117.       noi di "@min " %9.0f `r(min)'
118.       noi di "@max " %9.0f `r(max)'
119.       // noi di "@p50 " %9.0f `r(p50)'
120. }
121. 
122.     noi di "@values " `var'[1]
123. }
124. else if ( "`class'" == "category" | "`class'" == "dummy" ) {
125.     cap noi {
126.         if ( "`isstr'" != "YES" ) {
127.             cap tab `var', matcell( freq ) matrow( name )
128.             if ( _rc != 0 | ("`r(r)'" != "`unique'") ) {
129.                 local class = "other"
130.                 local unique = r(r)
131.             }
132.             else {
133.                 forvalues i=1/`unique' {
134.                     if ( `i' == 1 ) {
135.                         noi di "@values " _continue
136.                     }
137.                     noi di name[`i',1] _continue
138.                     if ( `i' == `unique' ) {
139.                         noi di ""
140.                     }
141.                     else {
142.                         noi di ", " _continue
143.                     }
144.                 }
145.                 forvalues i=1/`unique' {
146.                     if ( `i' == 1 ) {
147.                         noi di "@names " _continue
148.                     }
149.                     local val = name[`i',1]
150.                     local lab :label (`var') `val'
151.                     noi di `""`lab'""' _continue
152.                     if ( `i' == `unique' ) {
153.                         noi di ""
154.                     }
155.                     else {
156.                         noi di ", " _continue
157.                     }
158.                 }
159.                 forvalues i=1/`unique' {
160.                     if ( `i' == 1 ) {
161.                         noi di "@freq " _continue
162.                     }
163.                     noi di freq[`i',1] _continue
164.                     if ( `i' == `unique' ) {
165.                         noi di ""
166.                     }
167.                     else {
168.                         noi di ", " _continue
169.                     }
170.                 }
171.             }
172.         }
173.     }
174. }
175. else {
176.     noi di "@example0 " `var'[1]
177. }
178. 
179. cap noi {
180.     tempvar h w
181.     twoway__histogram_gen `var', gen( `h' `w' )
182.     forvalues i=1/`=r(n_x)' {
183.         if ( `i' == 1 ) {
184.             noi di "@histh " _continue
185.         }
186.         noi di `h'[`i'] _continue
187.         if ( `i' == `=r(n_x)' ) {
188.             noi di ""
189.         }
190.         else {
191.             noi di ", " _continue
192.         }
193.     }
194.     forvalues i=1/`=r(n_x)' {
195.         if ( `i' == 1 ) {
196.             noi di "@histw " _continue
197.         }
198.         noi di `w'[`i'] _continue
199.         if ( `i' == `=r(n_x)' ) {
200.             noi di ""
201.         }
202.         else {
203.             noi di ", " _continue
204.         }
205.     }
206.     }
207. }
208. 
209. noi di "@label `label'"
210. noi di "@class `class'"
211. noi di "@N_unique `unique'"
212. noi di "@N `total'"
213. 
214. noi di "_@NOTES"
215. 
216. 
217. }
218.

- - Tokens
    dta ldinvest ldinvest dta

File ldinvest.dta

Script Output

Script Output

Script Output

Script Output

Content

Tokens