National_Pride_Large

	Data/import.do:235
→	Data/EVC_da..at CP PPPs 2000 US.csv	↘
	Data/import.do:234		Data/EVC_da..at CP PPPs 2000 US.csv Data/EVC_da..at CP PPPs 2000 US.dta

Data/EVC_data/OECD data/Social Expenditure/Social Expenditure - Aggregated data-Per head at constant prices (2000) and constant PPPs (2000) - in US dollars/SOCX_AGG_Data_Public_Per head at CP PPPs 2000 US.csv open
file:data:csv

All properties
key	content
N	13110
_runCommand	import delimited
datasignature	13110:9(98603):3658896337:1012638009
date	Sun Oct 20 23:26:20 EST 2013
lastmodified	1382275580000
variables	9

Variable Graph Type N Descriptives Label

[+] branch
@SOCX_AGG_Data_Public_..00 US.csv

category
(str31)

13110
(10)

"Active labour market programmes".. "Unemployment"

Branch

All properties
key	content
N	13110
N_unique	10
class	category
freq	1589, 1624, 598, 990, 2229, 1620, 1422, 1417, 612, 1009
label	Branch
type	str31
values	"Active labour market programmes", "Family", "Health", "Housing", "Incapacity related", "Old age", "Other social policy areas", "Survivors", "Total", "Unemployment"

Data Manipulations with branch
file	#	command

Script Output

@freq 1589, 1624, 598, 990, 2229, 1620, 1422, 1417, 612, 1009
@values "Active labour market programmes", "Family", "Health", "Housing", "Incapacity related", "Old age", "Other social policy areas", "Survivors", "Total", "Unemployment"
@type str31
@label Branch
@class category
@N_unique 10
@N 13110

[+] country
@SOCX_AGG_Data_Public_..00 US.csv

string
(str15)

13110
(31)

Country

All properties
key	content
N	13110
N_unique	31
class	string
example0	Australia
label	Country
type	str15

Data Manipulations with country
file	#	command

Script Output

@example0 Australia
@type str15
@label Country
@class string
@N_unique 31
@N 13110

[+] flags
@SOCX_AGG_Data_Public_..00 US.csv

category
(str1)

2785
(3)

"a", "m", "x"

Flags

All properties
key	content
N	2785
N_unique	3
class	category
freq	2007, 613, 165
label	Flags
type	str1
values	"a", "m", "x"

Data Manipulations with flags
file	#	command

Script Output

@freq 2007, 613, 165
@values "a", "m", "x"
@type str1
@label Flags
@class category
@N_unique 3
@N 2785

[+] source
@SOCX_AGG_Data_Public_..00 US.csv

constant
(str6)

13110
(1)

"Public"

Source

All properties
key	content
N	13110
N_unique	1
class	constant
example0	Public
freq	13110
label	Source
type	str6
values	"Public"

Data Manipulations with source
file	#	command

Script Output

@freq 13110
@values "Public"
@example0 Public
@type str6
@label Source
@class constant
@N_unique 1
@N 13110

[+] typeofexpenditure
@SOCX_AGG_Data_Public_..00 US.csv

category
(str16)

13110
(3)

"Benefits in kind", "Cash benefits", "Total"

Type of Expenditure

All properties
key	content
N	13110
N_unique	3
class	category
freq	4450, 5234, 3426
label	Type of Expenditure
type	str16
values	"Benefits in kind", "Cash benefits", "Total"

Data Manipulations with typeofexpenditure
file	#	command

Script Output

@freq 4450, 5234, 3426
@values "Benefits in kind", "Cash benefits", "Total"
@type str16
@label Type of Expenditure
@class category
@N_unique 3
@N 13110

[+] typeofprogramme
@SOCX_AGG_Data_Public_..00 US.csv

string
(str73)

13110
(38)

Type of Programme

All properties
key	content
N	13110
N_unique	38
class	string
example0	Total
label	Type of Programme
type	str73

Data Manipulations with typeofprogramme
file	#	command

Script Output

@example0 Total
@type str73
@label Type of Programme
@class string
@N_unique 38
@N 13110

[+] unit
@SOCX_AGG_Data_Public_..00 US.csv

constant
(str75)

13110
(1)

"Per head, at constant prices (2000) and constant PPPs (2000), in US dollars"

Unit

All properties
key	content
N	13110
N_unique	1
class	constant
example0	Per head, at constant prices (2000) and constant PPPs (2000), in US dollars
freq	13110
label	Unit
type	str75
values	"Per head, at constant prices (2000) and constant PPPs (2000), in US dollars"

Data Manipulations with unit
file	#	command

Script Output

@freq 13110
@values "Per head, at constant prices (2000) and constant PPPs (2000), in US dollars"
@example0 Per head, at constant prices (2000) and constant PPPs (2000), in US dollars
@type str75
@label Unit
@class constant
@N_unique 1
@N 13110

[+] value
@SOCX_AGG_Data_Public_..00 US.csv

other
(float)

10325
(.)

(x̄=474.519, 1073.865) [0.000,16313.000]

Value

All properties
key	content
N	10325
N_unique	.
class	other
example0	691.59998
histh	.00187209, .00020519, .00009024, .00007386, .00005438, .00003657, .00003135, .00001544, .00001472, 9.024e-06, 9.024e-06, 9.737e-06, 4.275e-06, 4.512e-06, 4.037e-06, 1.187e-06, 4.037e-06, 1.900e-06, 9.499e-07, 2.137e-06, 1.900e-06, 1.187e-06, 9.499e-07, 9.499e-07, 1.425e-06, 2.375e-07, 2.375e-07, 2.375e-07, 2.375e-07
histw	203.91251, 611.73749, 1019.5625, 1427.3875, 1835.2125, 2243.0376, 2650.8625, 3058.6875, 3466.5125, 3874.3374, 4282.1626, 4689.9873, 5097.8125, 5505.6377, 5913.4624, 6321.2876, 6729.1123, 7136.9375, 7544.7627, 7952.5874, 8360.4121, 8768.2373, 9176.0625, 9583.8877, 9991.7129, 10807.362, 12846.487, 15701.263, 16109.088
label	Value
max	16313.000
mean	474.519
min	0.000
sd	1073.865
type	float

Data Manipulations with value
file	#	command

Script Output


value:  Value                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative           -         -          -
|  #                         Zero             557       557          -
|  #                         Positive        9768       911       8857
|  #                                        -----     -----      -----
|  #                         Total          10325      1468       8857
|  #   .   .   .   .         Missing         2785
+----------------------                     -----
0                 16313                     13110
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       value |     10325    474.5187    1073.865          0      16313
@mean   474.519
@sd  1073.865
@min     0.000
@max 16313.000
@example0 691.59998
@histh .00187209, .00020519, .00009024, .00007386, .00005438, .00003657, .00003135, .00001544, .00001472, 9.024e-06, 9.024e-06, 9.737e-06, 4.275e-06, 4.512e-06, 4.037e-06, 1.187e-06, 4.037e-06, 1.900e-06, 9.499e-07, 2.137e-06, 1.900e-06, 1.187e-06, 9.499e-07, 9.499e-07, 1.425e-06, 2.375e-07, 2.375e-07, 2.375e-07, 2.375e-07
@histw 203.91251, 611.73749, 1019.5625, 1427.3875, 1835.2125, 2243.0376, 2650.8625, 3058.6875, 3466.5125, 3874.3374, 4282.1626, 4689.9873, 5097.8125, 5505.6377, 5913.4624, 6321.2876, 6729.1123, 7136.9375, 7544.7627, 7952.5874, 8360.4121, 8768.2373, 9176.0625, 9583.8877, 9991.7129, 10807.362, 12846.487, 15701.263, 16109.088
@type float
@label Value
@class other
@N_unique .
@N 10325

[+] year
@SOCX_AGG_Data_Public_..00 US.csv

category
(int)

13110
(8)

"1980", "1985", "1990", "1995", ".. "2009", "2010"

Year

All properties
key	content
N	13110
N_unique	8
class	category
freq	1610, 1613, 1788, 1919, 1935, 1936, 1872, 437
label	Year
max	2010
mean	1995.959
min	1980
names	"1980", "1985", "1990", "1995", "2000", "2005", "2009", "2010"
sd	9.817
type	int
values	1980, 1985, 1990, 1995, 2000, 2005, 2009, 2010

Data Manipulations with year
file	#	command

Script Output


year:  Year                                     Number of Observations
-----------                                 ------------------------------
                                            Total   Integers   Nonintegers
|                  #         Negative           -         -          -
|                  #         Zero               -         -          -
|  #               #         Positive       13110     13110          -
|  #               #                        -----     -----      -----
|  #   #   #   #   #         Total          13110     13110          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
1980               2010                     13110
   (8 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |     13110    1995.959    9.817133       1980       2010
@mean  1995.959
@sd     9.817
@min      1980
@max      2010
@values 1980, 1985, 1990, 1995, 2000, 2005, 2009, 2010
@names "1980", "1985", "1990", "1995", "2000", "2005", "2009", "2010"
@freq 1610, 1613, 1788, 1919, 1935, 1936, 1872, 437
@type int
@label Year
@class category
@N_unique 8
@N 13110

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
> */
(9 vars, 13110 obs). 

Contains data
  obs:        13,110                          
 vars:             9                          
 size:     2,923,530                          
Sorted by:  
     Note:  dataset has changed since last saved
@N 13110
@variables 9
  13110:9(98603):3658896337:1012638009
@datasignature 13110:9(98603):3658896337:1012638009
panel variable not set; use xtset varname ...
.

File SOCX_AGG_Data_Public_Per head at CP PPPs 2000 US.csv

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens