Back to Focus On Article

Best Value Benefits Survey 2006/07

Data Download Instructions

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

Set up Derived Variable (V1) to change the Ethnic Questions in a single question

• Click the Plus Sign Icon (first left)
• Click type and select Derived
• Click Response and select Single
• Click in Label, removed contents via delete, type in "V1"
• Click in the Label Column of Row 1
• Type "British", tab across, type "Q21a=1", tab again
• Type "Irish", tab across, type "Q21a=2", tab again
• Type "Other White", tab across, type "Q21a=3", tab again
• Type "Caribbean", tab across, type "Q21b=1", tab again
• Type "African", tab across, type "Q21b=2", tab again
• Type "Other Black", tab across, type "Q21b=3", tab again
• Type "White & Black Caribbean", tab across, type "Q21c=1", tab again
• Type "White & Black African", tab across, type "Q21c=2", tab again
• Type "White & Asian", tab across, type "Q21c=3", tab again
• Type "Other Mixed", tab across, type "Q21c=4", tab again
• Type "Indian", tab across, type "Q21d=1", tab again
• Type "Pakistani", tab across, type "Q21d=2", tab again
• Type "Bangladeshi", tab across, type "Q21d=3", tab again
• Type "Other Asian", tab across, type "Q21d=4", tab again
• Type "Chinese", tab across, type "Q21e=1", tab again
• Type "Other", tab across, type "Q21e=2", enter
• 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, q1a~q20,v1,q22
• 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): Q21a1,Q21b1,Q21c1,Q21d1,Q21e1
• 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 in column F where complete, Click Edit then Copy
• Insert additional column into original Excel file before column AV (new column AV)
• 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
• 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