National_Pride_Large

	Data/import.do:89
→	Data/EVC_da..Health_Expenditure.csv	↘
	Data/import.do:88		Data/EVC_da..th_Expenditure2013.csv Data/EVC_da..th_Expenditure2013.dta Data/EVC_da..Health_Expenditure.csv Data/EVC_da..Health_Expenditure.dta

Data/EVC_data/OECD data/Health Expenditure Main Indicators/SHA_Data_Health_Expenditure.csv open
file:data:csv

All properties
key	content
N	33399
_runCommand	import delimited
datasignature	33399:8(98964):3607025194:4244092417
date	Thu Dec 12 00:51:36 EST 2013
lastmodified	1386773496000
variables	8

Variable Graph Type N Descriptives Label

[+] country
@SHA_Data_Health_Expenditure.csv

string
(str15)

33399
(34)

Country

All properties
key	content
N	33399
N_unique	34
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 34
@N 33399

[+] financingagent
@SHA_Data_Health_Expenditure.csv

category
(str27)

33399
(3)

"General government", "Private se..ture HF.1-HF.3"

Financing Agent

All properties
key	content
N	33399
N_unique	3
class	category
freq	11029, 11029, 11341
label	Financing Agent
type	str27
values	"General government", "Private sector", "Total expenditure HF.1-HF.3"

Data Manipulations with financingagent
file	#	command

Script Output

@freq 11029, 11029, 11341
@values "General government", "Private sector", "Total expenditure HF.1-HF.3"
@type str27
@label Financing Agent
@class category
@N_unique 3
@N 33399

[+] flags
@SHA_Data_Health_Expenditure.csv

category
(str2)

24161
(8)

" ", "B", "BD", "Bd", "D", "DE", "E", "d"

Flags

All properties
key	content
N	24161
N_unique	8
class	category
freq	19879, 1180, 28, 80, 301, 120, 682, 1891
label	Flags
type	str2
values	" ", "B", "BD", "Bd", "D", "DE", "E", "d"

Data Manipulations with flags
file	#	command

Script Output

@freq 19879, 1180, 28, 80, 301, 120, 682, 1891
@values " ", "B", "BD", "Bd", "D", "DE", "E", "d"
@type str2
@label Flags
@class category
@N_unique 8
@N 24161

[+] function
@SHA_Data_Health_Expenditure.csv

dummy
(str75)

33399
(2)

"Total expenditure HC.1-HC.9; HC..e health care)"

Function

All properties
key	content
N	33399
N_unique	2
class	dummy
freq	14592, 18807
label	Function
type	str75
values	"Total expenditure HC.1-HC.9; HC.R.1", "Total current expenditure HC.1-HC.9 (Individual and collective health care)"

Data Manipulations with function
file	#	command

Script Output

@freq 14592, 18807
@values "Total  expenditure HC.1-HC.9; HC.R.1", "Total current expenditure HC.1-HC.9 (Individual and collective health care)"
@type str75
@label Function
@class dummy
@N_unique 2
@N 33399

[+] provider
@SHA_Data_Health_Expenditure.csv

constant
(str27)

33399
(1)

"Total expenditure HP.1-HP.9"

Provider

All properties
key	content
N	33399
N_unique	1
class	constant
example0	Total expenditure HP.1-HP.9
freq	33399
label	Provider
type	str27
values	"Total expenditure HP.1-HP.9"

Data Manipulations with provider
file	#	command

Script Output

@freq 33399
@values "Total expenditure HP.1-HP.9"
@example0 Total expenditure HP.1-HP.9
@type str27
@label Provider
@class constant
@N_unique 1
@N 33399

[+] unit
@SHA_Data_Health_Expenditure.csv

category
(str36)

33399
(16)

"% current expenditure on health"..currency units"

Unit

All properties
key	content
N	33399
N_unique	16
class	category
freq	1176, 2392, 1176, 1176, 1176, 2383, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392
label	Unit
type	str36
values	"% current expenditure on health", "% gross domestic product", "% of financing agent", "% of function", "% of provider", "% total expenditure on health", "/capita, NCU at 2005 CPI level", "/capita, NCU at 2005 GDP price level", "/capita, US$ at 2005 PPP rates", "/capita, US$ purchasing power parity", "/capita, national currency units", "Million NCU at 2005 CPI level", "Million NCU at 2005 GDP price level", "Million US$ at 2005 PPP rates", "Million US$, purchasing power parity", "Million of national currency units"

Data Manipulations with unit
file	#	command

Script Output

@freq 1176, 2392, 1176, 1176, 1176, 2383, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392, 2392
@values "% current expenditure on health", "% gross domestic product", "% of financing agent", "% of function", "% of provider", "% total expenditure on health", "/capita, NCU at 2005 CPI level", "/capita, NCU at 2005 GDP price level", "/capita, US$ at 2005 PPP rates", "/capita, US$ purchasing power parity", "/capita, national currency units", "Million NCU at 2005 CPI level", "Million NCU at 2005 GDP price level", "Million US$ at 2005 PPP rates", "Million US$, purchasing power parity", "Million of national currency units"
@type str36
@label Unit
@class category
@N_unique 16
@N 33399

[+] value
@SHA_Data_Health_Expenditure.csv

other
(float)

33399
(.)

(x̄=4.89e+05, 4.16e+06) [0.584,9.59e+07]

Value

All properties
key	content
N	33399
N_unique	.
class	other
example0	66.812401
histh	4.603e-07, 2.051e-09, 5.479e-10, 1.012e-09, 1.545e-10, 2.810e-11, 1.545e-10, 1.545e-10, 1.545e-10, 2.669e-10, 1.967e-10, 1.686e-10, 1.264e-10, 2.388e-10, 4.355e-10, 5.339e-10, 3.231e-10, 4.215e-10, 3.793e-10, 4.215e-10, 2.388e-10, 1.686e-10, 7.024e-11, 5.620e-11, 5.620e-11, 1.405e-11, 5.620e-11, 4.215e-11, 4.215e-11, 4.215e-11, 1.405e-11, 4.215e-11, 2.810e-11, 4.215e-11, 2.810e-11, 5.620e-11, 1.405e-11, 2.810e-11, 2.810e-11, 2.810e-11, 1.405e-11, 1.405e-11, 1.405e-11
histw	1065598.3, 3196793.8, 5327989, 7459184.5, 9590380, 11721575, 13852770, 15983966, 18115162, 20246356, 22377552, 24508748, 26639942, 28771138, 30902334, 33033528, 35164724, 37295920, 39427116, 41558312, 43689504, 45820700, 47951896, 50083092, 52214288, 54345484, 56476676, 58607872, 60739068, 62870264, 65001460, 67132656, 69263848, 71395048, 73526240, 75657440, 77788632, 79919824, 82051024, 86313416, 90575800, 92707000, 94838192
label	Value
max	9.59e+07
mean	4.89e+05
min	0.584
sd	4.16e+06
type	float

Data Manipulations with value
file	#	command

Script Output


value:  Value                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative           -         -          -
|  #                         Zero               -         -          -
|  #                         Positive       33399      4920      28479
|  #                                        -----     -----      -----
|  #                         Total          33399      4920      28479
|  #   .   .   .   .         Missing            -
+----------------------                     -----
.5837          9.59e+07                     33399
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       value |     33399      489040     4157230      .5837   9.59e+07
@mean  4.89e+05
@sd  4.16e+06
@min     0.584
@max  9.59e+07
@example0 66.812401
@histh 4.603e-07, 2.051e-09, 5.479e-10, 1.012e-09, 1.545e-10, 2.810e-11, 1.545e-10, 1.545e-10, 1.545e-10, 2.669e-10, 1.967e-10, 1.686e-10, 1.264e-10, 2.388e-10, 4.355e-10, 5.339e-10, 3.231e-10, 4.215e-10, 3.793e-10, 4.215e-10, 2.388e-10, 1.686e-10, 7.024e-11, 5.620e-11, 5.620e-11, 1.405e-11, 5.620e-11, 4.215e-11, 4.215e-11, 4.215e-11, 1.405e-11, 4.215e-11, 2.810e-11, 4.215e-11, 2.810e-11, 5.620e-11, 1.405e-11, 2.810e-11, 2.810e-11, 2.810e-11, 1.405e-11, 1.405e-11, 1.405e-11
@histw 1065598.3, 3196793.8, 5327989, 7459184.5, 9590380, 11721575, 13852770, 15983966, 18115162, 20246356, 22377552, 24508748, 26639942, 28771138, 30902334, 33033528, 35164724, 37295920, 39427116, 41558312, 43689504, 45820700, 47951896, 50083092, 52214288, 54345484, 56476676, 58607872, 60739068, 62870264, 65001460, 67132656, 69263848, 71395048, 73526240, 75657440, 77788632, 79919824, 82051024, 86313416, 90575800, 92707000, 94838192
@type float
@label Value
@class other
@N_unique .
@N 33399

[+] year
@SHA_Data_Health_Expenditure.csv

category
(int)

33399
(13)

"2000", "2001", "2002", "2003", ".. "2011", "2012"

Year

All properties
key	content
N	33399
N_unique	13
class	category
freq	2680, 2680, 2728, 2752, 2800, 2800, 2800, 2800, 2752, 2716, 2620, 2416, 855
label	Year
max	2012
mean	2005.614
min	2000
names	"2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012"
sd	3.513
type	int
values	2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012

Data Manipulations with year
file	#	command

Script Output


year:  Year                                     Number of Observations
-----------                                 ------------------------------
                                            Total   Integers   Nonintegers
|          #                 Negative           -         -          -
|  #       #                 Zero               -         -          -
|  #       #       #         Positive       33399     33399          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total          33399     33399          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
2000               2012                     33399
  (13 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |     33399    2005.614    3.513386       2000       2012
@mean  2005.614
@sd     3.513
@min      2000
@max      2012
@values 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012
@names "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012"
@freq 2680, 2680, 2728, 2752, 2800, 2800, 2800, 2800, 2752, 2716, 2620, 2416, 855
@type int
@label Year
@class category
@N_unique 13
@N 33399

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

Contains data
  obs:        33,399                          
 vars:             8                          
 size:     6,279,012                          
Sorted by:  
     Note:  dataset has changed since last saved
@N 33399
@variables 8
  33399:8(98964):3607025194:4244092417
@datasignature 33399:8(98964):3607025194:4244092417
panel variable not set; use xtset varname ...
.

- - Tokens
    csv Data Data Health Expenditure Expenditure csv Health Health Expenditure SHA SHA Data

File SHA_Data_Health_Expenditure.csv

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens