{"id":19886,"date":"2015-08-20T13:41:24","date_gmt":"2015-08-20T13:41:24","guid":{"rendered":"https:\/\/www.snapsurveys.com\/support-snap11\/?page_id=19886"},"modified":"2023-04-05T12:39:42","modified_gmt":"2023-04-05T11:39:42","slug":"transforming-and-recategorising-data","status":"publish","type":"page","link":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/","title":{"rendered":"Transforming and recategorising data"},"content":{"rendered":"<p>This section describes how to&nbsp;use derived variables to recategorise and transform survey data into new variable types, for example: combine categories within a Multi Choice variable, and convert numeric, date and time and literal data into categories.<\/p>\n<h2><\/h2>\n<h2><i class=\"fa fa-youtube-play\"><\/i>Interactive tutorials<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/interactive-tutorials\/logical-expressions\/\">Logical expressions for question routing and analysis<\/a>&nbsp;[25m]<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/interactive-tutorials\/\">Browse all interactive tutorials&nbsp;\u2192<\/a><\/p>\n<h2><i class=\"fa fa-list\"><\/i>Worksheets<\/h2>\n<ul>\n<li class=\"page-title uk-title uk-only\"><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\">Calculating the difference between times on different dates<\/a><\/li>\n<li class=\"page-title uk-title uk-only\"><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analyzing-dates\/\">Analysing dates<\/a><\/li>\n<li class=\"page-title uk-title uk-only\"><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/analysing-post-codes-zip-codes\/\">Analysing post codes and zip codes<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/patterns-categorise-postcodes-postal-area\/\">Using patterns to categorise postcodes in to postal area<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/\">Browse all worksheets&nbsp;\u2192<\/a><\/p>\n<h2><i class=\"fa fa-book\"><\/i>Online user guide and documentation<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#29495\">Using derived variables<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22404\">Derived single variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22405\">Derived multiple variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22406\">Derived quantity variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22407\">Derived date variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22409\">Derived time variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22370\">Derived literal variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22579\">Categorising respondents by age and gender<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#18943\">Categorising respondents by age and gender for a quota<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22688\">Categorising respondents by case number<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22886\">Categorising literals<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22887\">Categorising literals in Other field to add to multichoice list<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22669\">Adding text to a derived literal to create a readable list<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22421\">Using a derived variable with a pattern to categorise postcodes<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22894\">Categorising quantity responses with a derived variable<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#25087\">Using derived variables to perform calculations<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22902\">Calculating age from a date of birth<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#15037\">Calculate the interval between two times<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22904\">Categorising time responses into hourly periods<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22899\">Categorising date responses into six monthly periods<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22901\">Categorising date responses into days of the week<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#22978\">Using a derived variable to weight the responses to a survey<\/a><\/li>\n<li><a href=\"https:\/\/www.snapsurveys.com\/help\/index.htm#23003\">Using a derived variable to calculate mean scores<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.snapsurveys.com\/help\/\">Go to Snap help&nbsp;\u2192<\/a><\/p>\n<h2><i class=\"fa fa-graduation-cap\"><\/i>Training and consultancy<\/h2>\n<p class=\"uk-only\">Our <a href=\"https:\/\/www.snapsurveys.com\/training\/course-outline-analysing-survey-results\/\">Analysing Results<\/a> course will give you an introduction to using derived variables for analysis.<\/p>\n<p>If you would like one-to-one training, we<span class=\"uk- only\"> also<\/span> offer online or face-to-face consultancies. Call us now on <span class=\"phone uk-only\">01454 280820<\/span><span class=\"phone us-only\">603-610-<\/span>8700 or <a class=\"email uk-only\" title=\"Request a Call Back\" href=\"mailto:training@snapsurveys.com?Subject=Training%20enquiry\">email us your training requirements<\/a><a class=\"email us-only\" title=\"Request a Call Back\" href=\"mailto:ustraining@snapsurveys.com?Subject=Training%20enquiry\">email us your training requirements<\/a> and we&#8217;ll call you back.<\/p>\n<p><a class=\"uk-only\" href=\"https:\/\/www.snapsurveys.com\/training\/\">Go to Snap training&nbsp;\u2192<\/a><a class=\"us-only\" href=\"https:\/\/www.snapsurveys.com\/us-training\/\">Go to Snap training&nbsp;\u2192 <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><a class=\"ninja_pages_read_more\"  href=\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/\"><\/a><\/p>\n","protected":false},"author":33,"featured_media":0,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":{"0":"post-19886","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>Transforming and recategorising data - 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=\"Transforming and recategorising data - Snap Surveys\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/\" \/>\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=\"2023-04-05T11:39:42+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=\"2 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\/transforming-and-recategorising-data\/\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/\",\"name\":\"Transforming and recategorising data - Snap Surveys\",\"isPartOf\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\"},\"datePublished\":\"2015-08-20T13:41:24+00:00\",\"dateModified\":\"2023-04-05T11:39:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transforming and recategorising data\"}]},{\"@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":"Transforming and recategorising data - 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":"Transforming and recategorising data - Snap Surveys","og_url":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/","og_site_name":"Snap Surveys","article_publisher":"https:\/\/www.facebook.com\/SnapSurveys","article_modified_time":"2023-04-05T11:39:42+00:00","twitter_card":"summary_large_image","twitter_site":"@snapsurveys","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/","url":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/","name":"Transforming and recategorising data - Snap Surveys","isPartOf":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website"},"datePublished":"2015-08-20T13:41:24+00:00","dateModified":"2023-04-05T11:39:42+00:00","breadcrumb":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/transforming-and-recategorising-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.snapsurveys.com\/support-snap11\/"},{"@type":"ListItem","position":2,"name":"Transforming and recategorising data"}]},{"@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\/19886","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\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/comments?post=19886"}],"version-history":[{"count":10,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/19886\/revisions"}],"predecessor-version":[{"id":31726,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/19886\/revisions\/31726"}],"wp:attachment":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/media?parent=19886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}