{"id":5148,"date":"2012-10-23T15:24:56","date_gmt":"2012-10-23T15:24:56","guid":{"rendered":"https:\/\/www.snapsurveys.com\/support-snap11\/?page_id=5148"},"modified":"2018-10-04T14:04:03","modified_gmt":"2018-10-04T13:04:03","slug":"analysing-surveys","status":"publish","type":"page","link":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/","title":{"rendered":"Analysing two surveys together"},"content":{"rendered":"<p>This worksheet covers merging the data for two surveys which are slightly different. One survey has more questions than the other. It assumes that both surveys contain data to be merged into one survey for analysis.<\/p>\n<p>You may need to merge surveys in these situations:<\/p>\n<ul>\n<li>Surveys run on an annual basis, to analyse trends through two or more years. (The questionnaire might change slightly from year to year).<\/li>\n<li>Surveys on one subject but with different focal points (e.g. surveys of users and non-users of a service).<\/li>\n<li>Surveys conducted for different locations (e.g. a survey of similar tourist attractions which varies between sites).<\/li>\n<li>Surveys conducted using two different interviewing methods (e.g. kiosk and web).<\/li>\n<\/ul>\n<p><a id=\"o19092\" name=\"o19092\"><\/a><\/p>\n<h3>Summary of steps<\/h3>\n<ul>\n<li><a href=\"#o19093\" target=\"_self\">Step 1: Creating a master survey to contain the data for both surveys<\/a>.<\/li>\n<li><a href=\"#o19227\" target=\"_self\">Step 2: Set up a database link to import the data<\/a>.<\/li>\n<li><a href=\"#o19228\" target=\"_self\">Step 3: Mapping the variables<\/a>.<\/li>\n<li><a href=\"#o19229\" target=\"_self\">Step 4: Running the database link<\/a>.<\/li>\n<\/ul>\n<div>\n<h3><a id=\"o19093\" name=\"o19093\"><\/a>Step 1: Creating a master survey to contain the data for both surveys<\/h3>\n<p>It is preferable to make a separate master survey to combine your surveys so that both the original surveys remain intact. The master survey will need to contain all the variables and codes in both surveys so that the analysis can be performed correctly.<\/p>\n<ol>\n<li>Clone the survey with the highest number of variables and name it something that indicates it is the combined survey. Also clone the raw data. This will give you a new copy of your survey including the existing data.<\/li>\n<li>Open the survey and add in any variables or additional codes that are in the other survey but are not in this survey.<\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a id=\"o19227\" name=\"o19227\"><\/a>Step 2: <strong>Setup a database link to import the data<\/strong><\/h3>\n<ol>\n<li>From the main menu bar click File then <strong>Database links<\/strong>. You will see an empty database link window. Click <strong>[New\u2026]<\/strong> to create a new database link.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22360\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/the-database-linkage-wizard.gif\" alt=\"the-database-linkage-wizard\" width=\"439\" height=\"209\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/the-database-linkage-wizard.gif 439w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/the-database-linkage-wizard-150x71.gif 150w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/div>\n<\/li>\n<li>In the Database Linkage Wizard, select <strong>Import From Snap Survey<\/strong> as the Linkage Type.<\/li>\n<li>Click <strong>[Next&gt;]<\/strong>. The list of surveys in the current directory appears.<\/li>\n<li>Select the survey that you wish to merge. You can browse to a different directory if you need to. Click <strong>[Next&gt;]<\/strong> once you have selected a survey.<\/li>\n<li>You will be asked how you wish to merge the survey. Select <strong>Append all cases<\/strong>. This adds all the imported cases as new cases at the end of the survey. Click <strong>[Next&gt;]<\/strong>.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22354\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/append-all-cases.gif\" alt=\"append-all-cases\" width=\"337\" height=\"147\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/append-all-cases.gif 337w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/append-all-cases-150x65.gif 150w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/div>\n<\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a id=\"o19228\" name=\"o19228\"><\/a>Step 3: Mapping the variables<\/h3>\n<p>The next window is where you will match the variables from the survey you are importing the data from to the survey you cloned as the master.<\/p>\n<p>The variables in the survey you are importing from are displayed in the left column and the current survey variables are displayed in the right column.<\/p>\n<ol>\n<li>Snap will attempt to map any variables from both surveys if the variables are identically named.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22353\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/variables-identica-.gif\" alt=\"variables-identica-\" width=\"521\" height=\"211\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/variables-identica-.gif 521w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/variables-identica--150x61.gif 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/variables-identica--500x202.gif 500w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/div>\n<\/li>\n<li>Click each of the variables in the right-hand column. If the variable is a coded question the codes will be displayed in a section below the mapped variables. Check that the codes on the left match the codes on the right.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22356\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/code-match-left-right.gif\" alt=\"code-match-left-right\" width=\"557\" height=\"534\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/code-match-left-right.gif 557w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/code-match-left-right-150x144.gif 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/code-match-left-right-500x479.gif 500w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/div>\n<p>If there are any blank codes in the right hand column, see the code label where <i>Ice cream<\/i> should be in the image above, click into the blank area and select the correct code label.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22359\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/set-the-mapping-code.gif\" alt=\"set-the-mapping-code\" width=\"441\" height=\"236\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/set-the-mapping-code.gif 441w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/set-the-mapping-code-150x80.gif 150w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/div>\n<\/li>\n<li>Click <strong>[Next&gt;]<\/strong> to see a summary of the mapped variables. You can also give the Database Linkage an appropriate name in this window.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22355\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/appropriate-name.gif\" alt=\"appropriate-name\" width=\"356\" height=\"338\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/appropriate-name.gif 356w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/appropriate-name-150x142.gif 150w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/div>\n<\/li>\n<li>Click <strong>[Finish]<\/strong> to go back to the Database Links dialog window where you will see the link you have just created.<\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a id=\"o19229\" name=\"o19229\"><\/a>Step 4: Running the database link<\/h3>\n<p>When a Database link has been set up in the Database Linkage dialog box, it can be run at any time you require.<\/p>\n<ol>\n<li>If the Database Linkage dialog is not already open, open it by selecting <strong>File | Database Links<\/strong>.\n<div><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22357\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/database-links.gif\" alt=\"database-links\" width=\"425\" height=\"200\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/database-links.gif 425w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/database-links-150x71.gif 150w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22358\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/report.gif\" alt=\"report\" width=\"403\" height=\"244\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/report.gif 403w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/05\/report-150x91.gif 150w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/div>\n<\/li>\n<li>Select your new Survey Import link and click <strong>[Run]<\/strong>. A dialog appears showing details of the import.\n<div><\/div>\n<\/li>\n<li>You can see the number of cases imported in the Processed Cases section of the Report dialog. Click <strong>[OK]<\/strong> to close the Database linkage dialog window.<\/li>\n<\/ol>\n<\/div>\n<p>If there is a topic you would like a worksheet on, email to <a title=\"\" href=\"mailto:snapideas@snapsurveys.com\" target=\"_self\">snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><a class=\"ninja_pages_read_more\"  href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"parent":43,"menu_order":57,"comment_status":"open","ping_status":"closed","template":"page-templates\/child-page.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":{"0":"post-5148","1":"page","2":"type-page","3":"status-publish","5":"search_category-support-hub"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analysing two surveys together - Snap Surveys<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Analysing two surveys together - Snap Surveys\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/\" \/>\n<meta property=\"og:site_name\" content=\"Snap Surveys\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SnapSurveys\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-04T13:04:03+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@snapsurveys\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/\",\"name\":\"Analysing two surveys together - Snap Surveys\",\"isPartOf\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\"},\"datePublished\":\"2012-10-23T15:24:56+00:00\",\"dateModified\":\"2018-10-04T13:04:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Worksheets\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Analysing two surveys together\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\",\"name\":\"Snap Surveys\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Analysing two surveys together - Snap Surveys","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Analysing two surveys together - Snap Surveys","og_url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/","og_site_name":"Snap Surveys","article_publisher":"https:\/\/www.facebook.com\/SnapSurveys","article_modified_time":"2018-10-04T13:04:03+00:00","twitter_card":"summary_large_image","twitter_site":"@snapsurveys","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/","url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/","name":"Analysing two surveys together - Snap Surveys","isPartOf":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website"},"datePublished":"2012-10-23T15:24:56+00:00","dateModified":"2018-10-04T13:04:03+00:00","breadcrumb":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-surveys\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.snapsurveys.com\/support-snap11\/"},{"@type":"ListItem","position":2,"name":"Worksheets","item":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/"},{"@type":"ListItem","position":3,"name":"Analysing two surveys together"}]},{"@type":"WebSite","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website","url":"https:\/\/www.snapsurveys.com\/support-snap11\/","name":"Snap Surveys","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/comments?post=5148"}],"version-history":[{"count":10,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5148\/revisions"}],"predecessor-version":[{"id":26397,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5148\/revisions\/26397"}],"up":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/media?parent=5148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}