Blog Archives

analyze health professional shortage areas (hpsa) with r

February 11, 2013
By

a health professional shortage area (hpsa) is a geographic area, population group, or health care facility that has been designated by the united states government as having an insufficient supply of medical providers, based on certain provider-to-popu...

Read more »

analyze the survey of income and program participation (sipp) with r

February 4, 2013
By

if the census bureau's budget was gutted and only one complex sample survey survived, pray it's the survey of income and program participation (sipp).  it's giant.  it's rich with variables.  it's monthly.  it follows households over three, four, now five year panels.  the congressional budget office uses it for their health insurance simulation.  analysts read that sipp has...

Read more »

analyze the survey of consumer finances (scf) with r

January 28, 2013
By

the survey of consumer finances (scf) tracks the wealth of american families.  every three years, more than five thousand households answer a battery of questions about income, net worth, credit card debt, pensions, mortgages, even the lease on th...

Read more »

analyze the health and retirement study (hrs) with r

January 14, 2013
By

the hrs is the one and only longitudinal survey of american seniors.  with a panel starting its third decade, the current pool of respondents includes older folks who have been interviewed every two years as far back as 1992.  unlike cross-se...

Read more »

analyze the medical expenditure panel survey (meps) with r

January 7, 2013
By

the meps household component leads the pack for examining individual-level medical expenditures by payor and type of service.  total expenditures captured by the survey tend to be low, but unbiased across the board and can be adjusted to match the...

Read more »

analyze the behavioral risk factor surveillance system (brfss) with r and monetdb

December 17, 2012
By

experimental.  the behavioral risk factor surveillance system (brfss) aggregates behavioral health data from 400,000 adults via telephone every year.  it's um *clears throat* the largest telephone survey in the world and it's gotta lotta uses...

Read more »

analyze the american community survey (acs) with r and monetdb

December 10, 2012
By

experimental.  think of the american community survey (acs) as the united states' census for off-years - the ones that don't end in zero.  every year, one percent of all americans respond, making it the largest complex sample administered by ...

Read more »

analyze the basic stand alone medicare claims public use files (bsapufs) with r and monetdb

December 3, 2012
By

the centers for medicare and medicaid services (cms) took the plunge.  the famous medicare 5% sample has been released to the public, free of charge.  jfyi - medicare is the u.s. government program that provides health insurance to 50 million...

Read more »

why and how to install monetdb with r on windows

November 26, 2012
By

warning: the instructions below are obsolete.  please check this page for the latest version.  <3 anthony whya speed test of three sql queries on sixty-seven million records using my personal computer --# calculate the sum, mean, median, a...

Read more »

analyze the consumer expenditure survey (ce) with r

November 13, 2012
By

the consumer expenditure survey (ce) is the primo data source to understand how americans spend money.  participating households keep a running diary about every little purchase over the year.  those diaries are then summed up into precise expenditure categories.  how else are you gonna know that the average american household spent $34 (±2) on bacon, $826 (±17) on cellular...

Read more »