[an error occurred while processing this directive]
[an error occurred while processing this directive] [an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]

Back to Focus On Article

Best Value Tenants Survey 2006/07

Data Download Instructions

  • Open Snap Survey Software
  • Open the relevant survey (e.g. snBVPI Tenants 2006)
  • Click View then Variables

NB there are two different Tenants surveys available, one for Local Authorities (3NB), the other for Registered Social Landlords (3NA). We have used the numbering of the Local Authority version but check the numbering of the variables in Snap – it will differ if you are using the Social Landlords survey OR have added or deleted questions.

Set up Derived Variable to change the Ethnic Questions in a single question.

  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V1”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V1"
  • Click in the Label Column of Row 1
  • 1 Type "British", tab across, type "Q7a=1", tab again
  • 2 Type "Irish", tab across, type "Q7a =2", tab again
  • 3 Type "Other White", tab across, type "Q7a =3", tab again
  • 4 Type "White & Black Caribbean", tab across, type "Q7c=1", tab again
  • 5 Type "White & Black African", tab across, type "Q7c=2", tab again
  • 6 Type "White & Asian", tab across, type "Q7c=3", tab again
  • 7 Type "Other Mixed", tab across, type "Q7c=4", tab again
  • 8 Type "Indian", tab across, type "Q7e=1", tab again
  • 9 Type "Pakistani", tab across, type "Q7e=2", tab again
  • 10 Type "Bangladeshi", tab across, type "Q7e=3", tab again
  • 11 Type "Other Asian", tab across, type "Q7e=4", tab again
  • 12 Type “Caribbean", tab across, type "Q7g=1", tab again
  • 13 Type "African", tab across, type "Q7g=2", tab again
  • 14 Type "Other", tab across, type "Q7g=3", tab again
  • 15 Type "Chinese", tab across, type "Q7i=1", tab again,
  • 16 Type “Other”, tab across, type “Q7i=2“, enter
  • Click on the “tick” button to save changes.

Set up Derived Variables for Q38 Age (Tenant and Partner/Spouse)

  • TENANT
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V2”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V2"
  • Click in the Label Column of Row 1
  • 1 Type "16-24", tab across, type "Q38a=1", tab again
  • 2 Type "25-34", tab across, type "Q38b=1", tab again
  • 3 Type "35-44", tab across, type "Q38c=1", tab again
  • 4 Type "45-54", tab across, type "Q38d=1", tab again
  • 5 Type "55-59", tab across, type "Q38e=1f, tab again
  • 6 Type "60-64", tab across, type "Q38f=1", tab again
  • 7 Type "65-74", tab across, type "Q38g=1", tab again
  • 8 Type "75+", tab across, type "Q38h=1", enter
  • Click on the “tick” button to save changes
  • PARTNER/SPOUSE
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V3”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V3"
  • Click in the Label Column of Row 1
  • 1 Type "16-24", tab across, type "Q38a=2", tab again
  • 2 Type "25-34", tab across, type "Q38b=2", tab again
  • 3 Type "35-44", tab across, type "Q38c=2", tab again
  • 4 Type "45-54", tab across, type "Q38d=2", tab again
  • 5 Type "55-59", tab across, type "Q38e=2", tab again
  • 6 Type "60-64", tab across, type "Q38f=2", tab again
  • 7 Type "65-74", tab across, type "Q38g=2", tab again
  • 8 Type "75+", tab across, type "Q38h=2", tab again
  • 9 Type "Not applicable", tab across, type "Q38i=1", enter
  • Click on the “tick” button to save changes

Set up Derived Variables for Q39 Gender (Tenant and Partner/Spouse)

  • TENANT
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V4”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V4"
  • Click in the Label Column of Row 1
  • 1 Type "Male", tab across, type "Q39a=1", tab again
  • 2 Type "Female", tab across, type "Q39b=1", enter
  • Click on the “tick” button to save changes
  • PARTNER/SPOUSE
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V5”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V5"
  • Click in the Label Column of Row 1
  • 1 Type "Male", tab across, type "Q39a=2", tab again
  • 2 Type "Female", tab across, type "Q39b=2", tab again
  • 3 Type "Not applicable", tab across, type "Q39c=1”, enter
  • Click on the “tick” button to save changes

Set up Derived Variables for Q40 Work (Tenant and Partner/Spouse)

  • TENANT
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V6”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V6"
  • Click in the Label Column of Row 1
  • 1 Type "Employee in full time job", tab across, type "Q40a=1", tab again
  • 2 Type "Employee in part time job", tab across, type "Q40b=1", tab again
  • 3 Type "Self-employed – full or part time", tab across, type "Q40c=1", tab again
  • 4 Type "Government supported training", tab across, type "Q40d=1", tab again
  • 5 Type "Unemployed", tab across, type "Q40e=1", tab again
  • 6 Type "Wholly retired from work", tab across, type "Q40f=1", tab again
  • 7 Type "Full-time education at school, college or university", tab across, type "Q40g=1", tab again
  • 8 Type "Looking after the family/home", tab across, type "Q40h=1", tab again
  • 9 Type "Permanently sick/disabled", tab across, type "Q40i=1", tab again
  • 10 Type "Doing something else", tab across, type "Q40j=1", enter
  • Click on the “tick” button to save changes
  • PARTNER/SPOUSE
  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V7”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V7"
  • Click in the Label Column of Row 1
  • 1 Type "Employee in full time job", tab across, type "Q40a=2", tab again
  • 2 Type "Employee in part time job", tab across, type "Q40b=2", tab again
  • 3 Type "Self-employed – full or part time", tab across, type "Q40c=2", tab again
  • 4 Type "Government supported training", tab across, type "Q40d=2", tab again
  • 5 Type "Unemployed and available for work", tab across, type "Q40e=2", tab again
  • 6 Type "Wholly retired from work", tab across, type "Q40f=2", tab again
  • 7 Type "Full-time education at school, college or university", tab across, type "Q40g=2", tab again
  • 8 Type "Looking after the family/home", tab across, type "Q40h=2", tab again
  • 9 Type "Permanently sick/disabled", tab across, type "Q40i=2", tab again
  • 10 Type "Doing something else", tab across, type "Q40j=2", tab again
  • 11 Type “Not applicable”, tab across, type, “Q40k=1”, enter
  • Click on the “tick” button to save changes

Set up Derived Variable for “not answered” to Q34 Improving Services

  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V8”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V8"
  • Click in the Label Column of Row 1
  • 1 Type "Not answered", tab across, type "Q34 nr", enter
  • Click on the “tick” button to save changes

Set up Derived Variable for “not answered” to Q42 Background Information

  • Click the Plus Sign Icon (first left)
  • Click in Name, remove contents and type “V9”
  • Click type and select Derived
  • Click Response and select Single
  • Click in Label, remove contents via delete, type in "V9"
  • Click in the Label Column of Row 1
  • 1 Type "Not answered", tab across, type "Q42 nr", enter
  • Click on the “tick” button to save changes
  • Click View then Data
  • Click File then Export
  • Ensure Format type reads Comma Separated (CSV)
  • Click on File
  • Browse for desired location and give it a filename
  • Click Save
  • In Content box type (or copy/paste)*: Case,Q1~Q6,V1,Q8~Q34,V8,Q35a~Q37, V2,V3,V4,V5,V6,V7,Q41,Q42,V9,Q43~Q46
  • Highlight the following: Expand multiples, Header row, Label row (not Code labels).
  • Click OK
  • Wait for it to run
  • Locate the file in the specified directory
  • Open the file (Excel)

Export open-ended responses to Ethnic Questions for inclusion in the spreadsheet.

  • Click View then Data
  • Click File then Export
  • Ensure Format type reads Comma Separated (CSV)
  • Click on File
  • Browse for desired location and give it a filename
  • Click Save
  • In Content box type (or copy/paste): Q7b,Q7d,Q7f,Q7h,Q7j
  • Click OK
  • Wait for it to run
  • Locate the file in the specified directory
  • Open the file (Excel)
  • In column type the formula =A1&B1&C1&D1&E1 Drag outside selection to extend this formula downwards to each row of data
  • Select data rows from column F where complete, Click Edit then Copy
  • Insert additional column into original Excel file before column I (new column I)
  • Paste special as values into column I of original Excel file
  • Select data rows where complete, Click Edit then Copy
  • Go to template
  • Select first empty row in first column
  • Click Edit then paste
  • Click File then Save
  • Q3, Q4, Q5 Information about your household specifies that that no reply should be left as blank. Highlight those cells in the spreadsheet and use find and replace to change the “0” to a blank.
  • Process template as required

*If you have assigned a unique serial number for each respondent in your Snap file type this variable name into the Content box instead of “Case”.

Back to Focus On Article

Home Page | Survey Software | Research Services | Site Map | About Us
Copyright © 2007 Snap Surveys Ltd. All rights reserved worldwide. Privacy Policy | Legal Statement