※上記の広告は60日以上更新のないWIKIに表示されています。更新することで広告が下部へ移動します。

Research Tips



Demographic Variable

age gender marital education q1010 q1011 q1012 q1013 q1014

Regional

Australia (eight states)
Canada (12 provinces)
France (22 provinces or quasiregions),
Germany (16 la¨nders)
Italy (19 regions)
Spain (eight nationalities)
Sweden (8 health counties)
UK (17 regional health authorities).

Health System in Transition

Albania (1999)
Albania (2002)
Andorra (2004)
Armenia (1996)
Armenia (2001)
Armenia (2006)
Australia (2001)
Australia (2006)
Austria (2001)
Austria (2006)
Azerbaijan (1996)
Azerbaijan (2004)
Belgium (2000)
Belgium (2007)
Bosnia and Herzegovina (2002)
Bulgaria (1999)
Bulgaria (2003)
Bulgaria (2007)
Canada (2005)
Canada HiT (1996)
Croatia (1999)
Croatia (2006)
Cyprus (2004)
Czech Republic (1996)
Czech Republic (2000)
Czech Republic (2005)
Denmark (2001)
Denmark (2007)
Estonia (1996)
Estonia (2000)
Estonia (2004)
Estonia (2008)
Finland (1996)
Finland (2002)
France (2004)
Georgia (2002)
Germany (2000)
Germany (2004), an updated version (2005) in German only
Greece (1996)
Hungary (1999)
Hungary (2004)
Iceland (2003)
Israel (2003)
Italy (2001)
Kazakhstan (1999)
Kazakhstan (2007)
Kyrgyzstan (1996)
Kyrgyzstan (2000)
Kyrgyzstan (2005)
Latvia (1996)
Latvia (2001)
Latvia (2008)
Lithuania (1996)
Lithuania (2000)
Luxembourg (1999)
Malta (1999)
Mongolia (2007)
Netherlands (2004)
New Zealand (2001)
Northern Ireland (2006)
Norway (2000)
Norway (2006)
Poland (1999)
Poland (2005)
Portugal (1999)
Portugal (2004)
Portugal (2007)
Republic of Moldova (1996)
Republic of Moldova (2002)
Romania (1996)
Romania (2000)
Russian Federation (1998)
Russian Federation (2003)
Slovakia (1996)
Slovakia (2000)
Slovakia (2004)
Slovenia (1996)
Slovenia (2002)
Spain (1996)
Spain (2000)
Spain (2006)
Sweden (1996)
Sweden (2001)
Sweden (2005)
Switzerland (2000)
Tajikistan (1996)
Tajikistan (2000)
The former Yugoslav Republic of Macedonia (2000)
The former Yugoslav Republic of Macedonia (2006)
Turkey (1996)
Turkey (2002)
Turkmenistan (1996)
Turkmenistan (2000)
Ukraine (2004)
United Kingdom of Great Britain and Northern Ireland (1999)
Uzbekistan (2001)
Uzbekistan (2007)
Wales (2004)

Evolution of Health System

tempz<-ifelse(x1>cutoff,0,1)

tempz<-ifelse(x1>cut1,ifelse(x2>cutoff,z1,1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2>cutoff,0,z1),z1)

tempz<-ifelse(x1>cut1,ifelse(x2>cut21,ifelse(x3<cut31,1,z1),z1)
tempz<-ifelse(x1>cut1,ifelse(x2<=cut21,ifelse(x3>cut32,0,z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2>cut21,ifelse(x3<=cut33,1,z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2<=cut21,ifelse(x3>cut34,0,z1),z1)

tempz<-ifelse(x1>cut1,ifelse(x2>cut21,ifelse(x3>cut31,ifelse(x4<=cut41,1,z1),z1),z1)
tempz<-ifelse(x1>cut1,ifelse(x2>cut21,ifelse(x3<=cut31,ifelse(x4>cut42,0,z1),z1),z1)
tempz<-ifelse(x1>cut1,ifelse(x2<=cut21,ifelse(x3>cut32,ifelse(x4<=cut43,1,z1),z1),z1)
tempz<-ifelse(x1>cut1,ifelse(x2<=cut21,ifelse(x3<=cut32,ifelse(x4>cut44,0,z1),z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2>cut21,ifelse(x3>cut33,ifelse(x4<=cut45,1,z1),z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2>cut21,ifelse(x3<=cut33,ifelse(x4>cut46,0,z1),z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2<=cut21,ifelse(x3>cut34,ifelse(x4<=cut47,1,z1),z1),z1)
tempz<-ifelse(x1<=cut1,ifelse(x2<=cut21,ifelse(x3<=cut34,ifelse(x4>cut48,0,z1),z1),z1)

Delete every other raw


Sub DeleteEveryTwoRows()
Const OPT = 0 '1 or 0
If OPT > 1 Or OPT < 0 Then Exit Sub
Application.ScreenUpdating = False
With Range("IV1:IV4000")
  .Formula = "=IF(MOD(Row(),2)= " & OPT & ",ROW(),"""")"
  .Value = .Value
  .SpecialCells(xlCellTypeConstants, xlNumbers).Select
End With
Selection.EntireRow.Delete
Range("A1").Select
Application.ScreenUpdating = True
End Sub