Part 1 of the course will offer an introduction to SPSS and teach how to work with data saved in SPSS format. Part 2 will demonstrate how to work with SPSS syntax, how to create your own SPSS data files, and how to convert data in other formats to SPSS. Part 3 will teach how to append and merge SPSS files, demonstrate basic analytical procedures, and show how to work with SPSS graphics.

analyze the current population survey (cps) annual social and economic supplement (asec) with r the annual march cps-asec has been supplying the statistics for the census bureau's report on income, poverty, and health insurance coverage since 1948. wow. the us census bureau and the bureau of labor statistics ( bls) tag-team on this one. until the american community survey (acs) hit the scene in the early aughts (2000s), the current population survey had the largest sample size of all the annual general demographic data sets outside of the decennial census - about two hundred thousand respondents. this provides enough sample to conduct state- and a few large metro area-level analyses. your sample size will vanish if you start investigating subgroups b y state - consider pooling multiple years. county-level is a no-no. despite the american community survey's larger size, the cps-asec contains many more variables related to employment, sources of income, and insurance - and can be trended back to harry truman's presidency. aside from questions specifically asked about an annual experience (like income), many of the questions in this march data set should be t reated as point-in-time statistics. cps-asec generalizes to the united states non-institutional, non-active duty military population. the national bureau of economic research (nber) provides sas, spss, and stata importation scripts to create a rectangular file (rectangular data means only person-level records; household- and family-level information gets attached to each person). to import these files into r, the parse.SAScii function uses nber's sas code to determine how to import the fixed-width file, then RSQLite to put everything into a schnazzy database. you can try reading through the nber march 2012 sas importation code yourself, but it's a bit of a proc freak show. this new github repository contains three scripts: 2005-2012 asec - download all microdata.R down load the fixed-width file containing household, family, and person records import by separating this file into three tables, then merge 'em together at the person-level download the fixed-width file containing the person-level replicate weights merge the rectangular person-level file with the replicate weights, then store it in a sql database create a new variable - one - in the data table 2012 asec - analysis examples.R connect to the sql database created by the 'download all microdata' progr am create the complex sample survey object, using the replicate weights perform a boatload of analysis examples replicate census estimates - 2011.R connect to the sql database created by the 'download all microdata' program create the complex sample survey object, using the replicate weights match the sas output shown in the png file below 2011 asec replicate weight sas output.png statistic and standard error generated from the replicate-weighted example sas script contained in this census-provided person replicate weights usage instructions document. click here to view these three scripts for more detail about the current population survey - annual social and economic supplement (cps-asec), visit: the census bureau's current population survey page the bureau of labor statistics' current population survey page the current population survey's wikipedia article notes: interviews are conducted in march about experiences during the previous year. the file labeled 2012 includes information (income, work experience, health insurance) pertaining to 2011. when you use the current populat ion survey to talk about america, subract a year from the data file name. as of the 2010 file (the interview focusing on america during 2009), the cps-asec contains exciting new medical out-of-pocket spending variables most useful for supplemental (medical spending-adjusted) poverty research. confidential to sas, spss, stata, sudaan users: why are you still rubbing two sticks together after we've invented the butane lighter? time to transition to r. :D

The data set comprises responses to a questionnaire survey with a wide range of items concerning finances, legal and relationship issues in non-traditional, cohabiting heterosexual couples. It is in the format of an SPSS .sav file with an N of 235 (having excluded a small number of respondents who did not meet the study criteria). The bulk of the data were obtained by means of an on-line survey with the remaining few obtained from a paper version of the questionnaire. Owing to the format imposed by the software used for the on-line version (PHPSurveyor) there are some instances where the precise response format for the items differed between the two versions. In order to merge the data into SPSS, some minor adjustments had to be made to make them compatible, such as combining 2 separate items in the on-line version on cohabitation length to obtain a single measure. To clarify, in the on-line version, two separate responses asked for the number of years of cohabitation and the number of months. These were combined in the final SPSS file into a single measure of overall cohabitation length in months. Thus, a respondent who had cohabited for 2 years and 6 months would receive a value in the final data set of 30 months’ cohabitation length. To indicate in full detail how some of the items have been combined for certain measures, an Excel file has been provided. At the top of the Excel file are the actual question items from the hard copy version of the questionnaire. Underneath in the purple band are the respective variable labels as they appear in the SPSS file. Below this, in blue, can be found the labels for the composite or recorded items that combine information from more than one of the original variables (for example, ‘household income combines information from the items asking for respondent’s own and partner’s income). The labels for the variable values can be found in the SPSS file in the conventional way. Studies of the monetary practices of (mainly) married couples have revealed gender-associated asymmetries in access to household resources. However, theory development has been restricted because gender issues are easily confounded with the ideological meaning(s) of ‘marriage’. In other words, is it being a ‘wife’ or ‘husband’ that produces such asymmetries, rather than gender per se? The proposed project aims to disentangle this conflation of ‘gender’ with ‘marriage’ by focusing on money management in non-traditional (ie unmarried cohabiting or non-cohabiting) heterosexual couples, The research will be in two phases: (1) in-depth qualitative interviews with individual partners in 15 non-traditional heterosexual (NTH) couples, including some that have specifically rejected the notion of marriage on ideological grounds, and (2) a larger scale survey of 300 NTH couples. Our main aims are to: (1) Provide a detailed analysis of how NTH couples organise their finances and compare this with existing data on married couples; (2) Develop theories of household financial management that are grounded in a more inclusive definition of ‘household’ or ‘family’; (3) Explore NTH couples’ understandings of their financial rights and responsibilities and consider the implications of their financial management practices for the proposed law reform governing financial provision on cohabitation breakdown. Our main aims are to: (1) Provide a detailed analysis of how NTH couples organise their finances and compare this with existing data on married couples; (2) Develop theories of household financial management that are grounded in a more inclusive definition of ‘household’ or ‘family’; (3) Explore NTH couples’ understandings of their financial rights and responsibilities and consider the implications of their financial management practices for the proposed law reform governing financial provision on cohabitation breakdown. Data was collected mainly via on-line questionnaire with 267 individual respondents; majority (235) were cohabiting and the rest married.

Version 5 release notes:
Removes support for SPSS and Excel data.Changes the crimes that are stored in each file. There are more files now with fewer crimes per file. The files and their included crimes have been updated below.
Adds in agencies that report 0 months of the year.Adds a column that indicates the number of months reported. This is generated summing up the number of unique months an agency reports data for. Note that this indicates the number of months an agency reported arrests for ANY crime. They may not necessarily report every crime every month. Agencies that did not report a crime with have a value of NA for every arrest column for that crime.Removes data on runaways.
Version 4 release notes:
Changes column names from "poss_coke" and "sale_coke" to "poss_heroin_coke" and "sale_heroin_coke" to clearly indicate that these column includes the sale of heroin as well as similar opiates such as morphine, codeine, and opium. Also changes column names for the narcotic columns to indicate that they are only for synthetic narcotics.
Version 3 release notes:
Add data for 2016.Order rows by year (descending) and ORI.Version 2 release notes:
Fix bug where Philadelphia Police Department had incorrect FIPS county code.
The Arrests by Age, Sex, and Race data is an FBI data set that is part of the annual Uniform Crime Reporting (UCR) Program data. This data contains highly granular data on the number of people arrested for a variety of crimes (see below for a full list of included crimes). The data sets here combine data from the years 1980-2015 into a single file. These files are quite large and may take some time to load.
All the data was downloaded from NACJD as ASCII+SPSS Setup files and read into R using the package asciiSetupReader. All work to clean the data and save it in various file formats was also done in R. For the R code used to clean this data, see here. https://github.com/jacobkap/crime_data. If you have any questions, comments, or suggestions please contact me at jkkaplan6@gmail.com.

I did not make any changes to the data other than the following. When an arrest column has a value of "None/not reported", I change that value to zero. This makes the (possible incorrect) assumption that these values represent zero crimes reported. The original data does not have a value when the agency reports zero arrests other than "None/not reported." In other words, this data does not differentiate between real zeros and missing values. Some agencies also incorrectly report the following numbers of arrests which I change to NA: 10000, 20000, 30000, 40000, 50000, 60000, 70000, 80000, 90000, 100000, 99999, 99998.

To reduce file size and make the data more manageable, all of the data is aggregated yearly. All of the data is in agency-year units such that every row indicates an agency in a given year. Columns are crime-arrest category units. For example, If you choose the data set that includes murder, you would have rows for each agency-year and columns with the number of people arrests for murder. The ASR data breaks down arrests by age and gender (e.g. Male aged 15, Male aged 18). They also provide the number of adults or juveniles arrested by race. Because most agencies and years do not report the arrestee's ethnicity (Hispanic or not Hispanic) or juvenile outcomes (e.g. referred to adult court, referred to welfare agency), I do not include these columns.

To make it easier to merge with other data, I merged this data with the Law Enforcement Agency Identifiers Crosswalk (LEAIC) data. The data from the LEAIC add FIPS (state, county, and place) and agency type/subtype. Please note that some of the FIPS codes have leading zeros and if you open it in Excel it will automatically delete those leading zeros.

I created 9 arrest categories myself. The categories are:
Total Male JuvenileTotal Female JuvenileTotal Male AdultTotal Female AdultTotal MaleTotal FemaleTotal JuvenileTotal AdultTotal ArrestsAll of these categories are based on the sums of the sex-age categories (e.g. Male under 10, Female aged 22) rather than using the provided age-race categories (e.g. adult Black, juvenile Asian). As not all agencies report the race data, my method is more accurate. These categories also make up the data in the "simple" version of the data. The "simple" file only includes the above 9 columns as the arrest data (all other columns in the data are just agency identifier columns). Because this "simple" data set need fewer columns, I include all offenses.

As the arrest data is very granular, and each category of arrest is its own column, there are dozens of columns per crime. To keep the data somewhat manageable, there are nine different files, eight which contain different crimes and the "simple" file. Each file contains the data for all years. The eight categories each have crimes belonging to a major crime category and do not overlap in crimes other than with the index offenses. Please note that the crime names provided below are not the same as the column names in the data. Due to Stata limiting column names to 32 characters maximum, I have abbreviated the crime names in the data. The files and their included crimes are:

Index Crimes
MurderRapeRobberyAggravated AssaultBurglaryTheftMotor Vehicle TheftArsonAlcohol CrimesDUIDrunkenness
LiquorDrug CrimesTotal DrugTotal Drug SalesTotal Drug PossessionCannabis PossessionCannabis SalesHeroin or Cocaine PossessionHeroin or Cocaine SalesOther Drug PossessionOther Drug SalesSynthetic Narcotic PossessionSynthetic Narcotic SalesGrey Collar and Property CrimesForgeryFraudStolen PropertyFinancial CrimesEmbezzlementTotal GamblingOther GamblingBookmakingNumbers LotterySex or Family CrimesOffenses Against the Family and Children
Other Sex Offenses
ProstitutionRapeViolent CrimesAggravated AssaultMurderNegligent ManslaughterRobberyWeapon Offenses
Other CrimesCurfewDisorderly ConductOther Non-trafficSuspicion
VandalismVagrancy
Simple
This data set has every crime and only the arrest categories that I created (see above).
If you have any questions, comments, or suggestions please contact me at jkkaplan6@gmail.com.

Abstract copyright UK Data Service and data collection copyright owner.The Crime Survey for England and Wales (CSEW) asks a sole adult in a random sample of households about their, or their household's, experience of crime victimisation in the previous 12 months. These are recorded in the victim form data file (VF). A wide range of questions are then asked, covering demographics and crime-related subjects such as attitudes to the police and the criminal justice system (CJS). These variables are contained within the non-victim form (NVF) data file. In 2009, the survey was extended to children aged 10-15 years old; one resident of that age range was also selected from the household and asked about their experience of crime and other related topics. The first set of children's data covered January-December 2009 and is held separately under SN 6601. From 2009-2010, the children's data cover the same period as the adult data and are included with the main study.The Telephone-operated Crime Survey for England and Wales (TCSEW) became operational on 20 May 2020. It was a replacement for the face-to-face CSEW, which was suspended on 17 March 2020 because of the coronavirus (COVID-19) pandemic. It was set up with the intention of measuring the level of crime during the pandemic. As the pandemic continued throughout the 2020/21 survey year, questions have been raised as to whether the year ending March 2021 TCSEW is comparable with estimates produced in earlier years by the face-to-face CSEW. The ONS Comparability between the Telephone-operated Crime Survey for England and Wales and the face-to-face Crime Survey for England and Wales report explores those factors that may have a bearing on the comparability of estimates between the TCSEW and the former CSEW. These include survey design, sample design, questionnaire changes and modal changes.More general information about the CSEW may be found on the ONS Crime Survey for England and Wales web page and for the previous BCS, from the GOV.UK BCS Methodology web page.History - the British Crime SurveyThe CSEW was formerly known as the British Crime Survey (BCS), and has been in existence since 1981. The 1982 and 1988 BCS waves were also conducted in Scotland (data held separately under SNs 4368 and 4599). Since 1993, separate Scottish Crime and Justice Surveys have been conducted. Up to 2001, the BCS was conducted biennially. From April 2001, the Office for National Statistics took over the survey and it became the CSEW. Interviewing was then carried out continually and reported on in financial year cycles. The crime reference period was altered to accommodate this. Secure Access CSEW dataIn addition to the main survey, a series of questions covering drinking behaviour, drug use, self-offending, gangs and personal security, and intimate personal violence (IPV) (including stalking and sexual victimisation) are asked of adults via a laptop-based self-completion module (questions may vary over the years). Children aged 10-15 years also complete a separate self-completion questionnaire. The questionnaires are included in the main documentation, but the data are only available under Secure Access conditions (see SN 7280), not with the main study. In addition, from 2011 onwards, lower-level geographic variables are also available under Secure Access conditions (see SN 7311).New methodology for capping the number of incidents from 2017-18The CSEW datasets available from 2017-18 onwards are based on a new methodology of capping the number of incidents at the 98th percentile. Incidence variables names have remained consistent with previously supplied data but due to the fact they are based on the new 98th percentile cap, and old datasets are not, comparability has been lost with years prior to 2012-2013. More information can be found in the 2017-18 User Guide (see SN 8464) and the article ‘Improving victimisation estimates derived from the Crime Survey for England and Wales’. CSEW Historic back series – dataset update (March 2022)From January 2019, all releases of crime statistics using CSEW data adopted a new methodology for measuring repeat victimisation (moving from a cap of 5 in the number of repeat incidents to tracking the 98th percentile value for major crime types). To maintain a consistent approach across historic data, all datasets back to 2001 have been revised to the new methodology. The change affects all incident data and related fields. A “bolt-on” version of the data has been created for the 2001/02 to 2011/12 datasets. This “bolt-on” dataset contains only variables previously supplied impacted by the change in methodology. These datasets can be merged onto the existing BCS NVF and VF datasets. A template ‘merge’ SPSS syntax file is provided, which will need to be adapted for other software formats.For the seventh edition (March 2022), “bolt-on” datasets for the NVF and VF files, example merge syntax and additional documentation have been added to the study to accommodate the latest CSEW repeat victimisation measurement methodology. See the documentation for further details. Main Topics: The dataset includes information from two sections of the survey, the non-victim form questionnaire and the victim form questionnaire. The non-victim form questionnaire gathers respondent-level data: topics covered include fear of crime, perception of antisocial behaviour, victimisation screener questions, performance of the criminal justice system (CJS), experiences of the police, attitudes to the CJS, crime prevention and security, victims and the CJS, demographic information, and technology crime. The victim form contains offence-level data. Up to six different incidents are asked about for each respondent - each of these constitutes a separate victim form and can be matched back to the respondent-level data through the variable ROWLABEL. Topics covered include the nature and circumstances of the incident, details of offenders, security measures, costs, emotional reactions, contact with the CJS and outcomes where known. From October 2016, the self-completion questionnaire modules covering dcovering drug use, drinking behaviour, and domestic violence, sexual victimisation and stalking are subject to Controlled data access conditions - see SN 7280. Multi-stage stratified random sample Face-to-face interview 2004 2005 ADMINISTRATION OF J... ADOLESCENTS ADVICE AGE AGGRESSIVENESS AIRPORTS ALCOHOL USE ALCOHOLISM AMPHETAMINES ANABOLIC STEROIDS ANGER ASSAULT ATTITUDES BICYCLES BURGLARY CANNABIS CAR PARKING AREAS CHILDREN CHRONIC ILLNESS CLUBS COCAINE COMBATIVE SPORTS COMMUNITIES COMMUNITY ACTION COMMUNITY BEHAVIOUR COMMUNITY SAFETY COMMUNITY SERVICE P... COMPUTERS COSTS COUNSELLING COURT CASES CREDIT CARD USE CRIME AND SECURITY CRIME PREVENTION CRIME VICTIMS CRIMINAL COURTS CRIMINAL DAMAGE CRIMINAL INVESTIGATION CRIMINAL JUSTICE SY... CRIMINALS CULTURAL GOODS CULTURAL IDENTITY Crime and law enfor... DAMAGE DEBILITATIVE ILLNESS DISCIPLINE DOGS DOMESTIC RESPONSIBI... DOMESTIC VIOLENCE DOORS DRINKING BEHAVIOUR DRIVING DRUG ABUSE ECONOMIC ACTIVITY ECONOMIC VALUE ECSTASY DRUG ELECTRONIC MAIL EMERGENCY AND PROTE... EMOTIONAL DISTURBANCES EMOTIONAL STATES EMPLOYEES EMPLOYMENT EMPLOYMENT HISTORY ETHNIC CONFLICT ETHNIC GROUPS EVERYDAY LIFE EXPOSURE TO NOISE England and Wales FAMILIES FAMILY MEMBERS FEAR FEAR OF CRIME FINANCIAL COMPENSATION FINANCIAL RESOURCES FIRE FIRE DAMAGE FIRE SAFETY MEASURES GENDER HARASSMENT HEADS OF HOUSEHOLD HEALTH HEALTH PROFESSIONALS HEROIN HOME CONTENTS INSUR... HOME OWNERSHIP HOSPITALIZATION HOURS OF WORK HOUSEHOLD HEAD S EC... HOUSEHOLD HEAD S OC... HOUSEHOLD INCOME HOUSEHOLDS HOUSING AGE HOUSING TENURE INDUSTRIES INFORMATION MATERIALS INFORMATION SOURCES INJURIES INSURANCE CLAIMS INTERNET ACCESS INTERNET USE INTERPERSONAL COMMU... INTERPERSONAL CONFLICT INTERPERSONAL RELAT... INTRUDER ALARM SYSTEMS JUDGES JUDGMENTS LAW JURIES JUVENILE DELINQUENCY LANDLORDS LAW ENFORCEMENT LEARNING DISABILITIES LEAVE LEGAL PROCEDURE LIGHTING LOCAL GOVERNMENT SE... LOCKS LSD DRUG MAGISTRATES MARITAL STATUS MEDIATION MEDICAL CARE MOTOR VEHICLES NEIGHBOURHOODS NEIGHBOURS NEWSPAPER READERSHIP NEWSPAPERS OFFENCES OFFENSIVE TELEPHONE... ONLINE SHOPPING PAYMENTS PERSONAL CONTACT PERSONAL FASHION GOODS PERSONAL IDENTIFICA... PERSONAL SAFETY POLICE OFFICERS POLICE SERVICES POLICING POLITICAL PARTICIPA... PORNOGRAPHY PRISON SENTENCES PROBATION PROSECUTION SERVICE PUBLIC HOUSES PUBLIC OPINION PUNISHMENT QUALIFICATIONS QUALITY OF LIFE RECIDIVISM REFUSE RENTED ACCOMMODATION RESIDENTIAL MOBILITY RESPONSIBILITY RISK ROBBERY SECURITY SYSTEMS SELF EMPLOYED SEXUAL ASSAULT SEXUAL HARASSMENT SEXUAL OFFENCES SHARED HOME OWNERSHIP SICK LEAVE SLEEP DISORDERS SMALL BUSINESSES SMOKING SOCIAL ACTIVITIES L... SOCIAL HOUSING SOCIAL PARTICIPATION SOCIAL SUPPORT SOLVENT ABUSE SORROW SPOUSE S ECONOMIC A... SPOUSES STUDENTS SUBSTANCE USE SUPERVISORY STATUS Social behaviour an... THEFT TIED HOUSING TRAFFIC OFFENCES TRAINING TRAINING COURSES TRANQUILLIZERS UNEMPLOYMENT UNWAGED WORKERS VAGRANTS VISITS PERSONAL VOLUNTARY WELFARE O... WEAPONS WINDOWS WITNESS INTIMIDATION WITNESSES WORKPLACE YOUTH YOUTH COURTS

The Crime Survey for England and Wales (CSEW) asks a sole adult in a random sample of households about their, or their household's, experience of crime victimisation in the previous 12 months. These are recorded in the victim form data file (VF). A wide range of questions are then asked, covering demographics and crime-related subjects such as attitudes to the police and the criminal justice system (CJS). These variables are contained within the non-victim form (NVF) data file. In 2009, the survey was extended to children aged 10-15 years old; one resident of that age range was also selected from the household and asked about their experience of crime and other related topics. The first set of children's data covered January-December 2009 and is held separately under SN 6601. From 2009-2010, the children's data cover the same period as the adult data and are included with the main study.

The Telephone-operated Crime Survey for England and Wales (TCSEW) became operational on 20 May 2020. It was a replacement for the face-to-face CSEW, which was suspended on 17 March 2020 because of the coronavirus (COVID-19) pandemic. It was set up with the intention of measuring the level of crime during the pandemic. As the pandemic continued throughout the 2020/21 survey year, questions have been raised as to whether the year ending March 2021 TCSEW is comparable with estimates produced in earlier years by the face-to-face CSEW. The ONS Comparability between the Telephone-operated Crime Survey for England and Wales and the face-to-face Crime Survey for England and Wales report explores those factors that may have a bearing on the comparability of estimates between the TCSEW and the former CSEW. These include survey design, sample design, questionnaire changes and modal changes.

More general information about the CSEW may be found on the ONS Crime Survey for England and Wales web page and for the previous BCS, from the GOV.UK BCS Methodology web page.

History - the British Crime Survey

The CSEW was formerly known as the British Crime Survey (BCS), and has been in existence since 1981. The 1982 and 1988 BCS waves were also conducted in Scotland (data held separately under SNs 4368 and 4599). Since 1993, separate Scottish Crime and Justice Surveys have been conducted. Up to 2001, the BCS was conducted biennially. From April 2001, the Office for National Statistics took over the survey and it became the CSEW. Interviewing was then carried out continually and reported on in financial year cycles. The crime reference period was altered to accommodate this.

Secure Access CSEW data
In addition to the main survey, a series of questions covering drinking behaviour, drug use, self-offending, gangs and personal security, and intimate personal violence (IPV) (including stalking and sexual victimisation) are asked of adults via a laptop-based self-completion module (questions may vary over the years). Children aged 10-15 years also complete a separate self-completion questionnaire. The questionnaires are included in the main documentation, but the data are only available under Secure Access conditions (see SN 7280), not with the main study. In addition, from 2011 onwards, lower-level geographic variables are also available under Secure Access conditions (see SN 7311).

New methodology for capping the number of incidents from 2017-18
The CSEW datasets available from 2017-18 onwards are based on a new methodology of capping the number of incidents at the 98th percentile. Incidence variables names have remained consistent with previously supplied data but due to the fact they are based on the new 98th percentile cap, and old datasets are not, comparability has been lost with years prior to 2012-2013. More information can be found in the 2017-18 User Guide (see SN 8464) and the article ‘Improving victimisation estimates derived from the Crime Survey for England and Wales’.

Variable 'PFA' (Police Force Area):
From 2008-2009 onwards, the BCS variable 'PFA' (Police Force Area) is now only available within the associated dataset SN 6935, British Crime Survey, 2009-2010: Special Licence Access, Low-Level Geographic Data, which is subject to restrictive access conditions; see 'Access' section below.

2009-2010 self-completion modules:
From October 2016, the self-completion questionnaire modules covering drug use, drinking behaviour, and domestic violence, sexual victimisation and stalking are subject to Controlled data access conditions - see SN 7280.