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 |
