{"id":1248,"date":"2022-02-11T15:38:29","date_gmt":"2022-02-11T14:38:29","guid":{"rendered":"https:\/\/microdata.spirehost.no\/?post_type=eksempel&#038;p=1248"},"modified":"2023-10-27T16:39:11","modified_gmt":"2023-10-27T15:39:11","slug":"make-variable-with-several-categories","status":"publish","type":"eksempel","link":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/","title":{"rendered":"Make variable with several categories"},"content":{"rendered":"\n<p>Numerical variables measuring amounts, percentages, years of age and other types of continuously values may be categorised through the <code>generate<\/code> and <code>replace<\/code> commands.<\/p>\n\n\n\n<p>Example of categorization of the variable <code>wealth<\/code> where the new variable <code>wealth_int<\/code> places the values among 4 mutually exclusive categories:<\/p>\n\n\n\n<p>1: 0 &#8211; 500000<\/p>\n\n\n\n<p>2: 500001 &#8211; 1000000<\/p>\n\n\n\n<p>3: 1000001 &#8211; 1500000<\/p>\n\n\n\n<p>4: 1500001 and over<\/p>\n\n\n<div id=\"rose-block_620674ac49653\" class=\"rose-code codeblock-wrapper\">\n<pre tabindex=\"0\" class=\"codeblock\"><code>\/\/Connect to datastore\r\nrequire no.ssb.fdb:13 as db\r\n\r\ncreate-dataset demography\r\nimport db\/INNTEKT_BRUTTOFORM 2019-12-31 as wealth\r\n\r\n\/\/Group wealth into 4 intervals\r\ngenerate wealth_int = 1\r\nreplace wealth_int = 2 if wealth > 500000\r\nreplace wealth_int = 3 if wealth > 1000000\r\nreplace wealth_int = 4 if wealth > 1500000\r\n\r\ntabulate wealth_int<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":17,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":""},"class_list":["post-1248","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Make variable with several categories - microdata.no<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Make variable with several categories - microdata.no\" \/>\n<meta property=\"og:description\" content=\"Numerical variables measuring amounts, percentages, years of age and other types of continuously values may be categorised through the generate and replace commands. Example of categorization of the variable wealth where the new variable wealth_int places the values among 4 mutually exclusive categories: 1: 0 &#8211; 500000 2: 500001 &#8211; 1000000 3: 1000001 &#8211; 1500000...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T15:39:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/make-variable-with-several-categories\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/make-variable-with-several-categories\\\/\",\"name\":\"Make variable with several categories - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-02-11T14:38:29+00:00\",\"dateModified\":\"2023-10-27T15:39:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/make-variable-with-several-categories\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/make-variable-with-several-categories\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/make-variable-with-several-categories\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Make variable with several categories\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/\",\"name\":\"microdata.no\",\"description\":\"Gj\u00f8r det enklere \u00e5 analysere registerdata\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.microdata.no\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Make variable with several categories - microdata.no","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/","og_locale":"en_US","og_type":"article","og_title":"Make variable with several categories - microdata.no","og_description":"Numerical variables measuring amounts, percentages, years of age and other types of continuously values may be categorised through the generate and replace commands. Example of categorization of the variable wealth where the new variable wealth_int places the values among 4 mutually exclusive categories: 1: 0 &#8211; 500000 2: 500001 &#8211; 1000000 3: 1000001 &#8211; 1500000...","og_url":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/","og_site_name":"microdata.no","article_modified_time":"2023-10-27T15:39:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/","url":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/","name":"Make variable with several categories - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-02-11T14:38:29+00:00","dateModified":"2023-10-27T15:39:11+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/en\/eksempel\/make-variable-with-several-categories\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"Make variable with several categories"}]},{"@type":"WebSite","@id":"https:\/\/www.microdata.no\/#website","url":"https:\/\/www.microdata.no\/","name":"microdata.no","description":"Gj\u00f8r det enklere \u00e5 analysere registerdata","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microdata.no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"taxonomy_info":[],"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/eksempel\/1248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/eksempel"}],"about":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/types\/eksempel"}],"wp:attachment":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/media?parent=1248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}