{"id":63,"date":"2022-02-11T14:07:31","date_gmt":"2022-02-11T13:07:31","guid":{"rendered":"https:\/\/microdata.spirehost.no\/?post_type=eksempel&#038;p=63"},"modified":"2023-10-27T16:39:19","modified_gmt":"2023-10-27T15:39:19","slug":"removing-units-from-a-dataset","status":"publish","type":"eksempel","link":"https:\/\/www.microdata.no\/en\/eksempel\/removing-units-from-a-dataset\/","title":{"rendered":"Removing units from a dataset"},"content":{"rendered":"\n<p>Before carrying out analyses on a data set, it is usually desirable to trim it down by removing people you do not want to include. This can be done through the <code>drop<\/code> and <code>keep<\/code> commands in combination with standard IF conditions.<\/p>\n\n\n\n<p>In the example below, the sample is trimmed down to contain people between 16 and 66.<\/p>\n\n\n<div id=\"rose-block_f642884a77e3c913868f0769f3c0410c\" class=\"rose-code codeblock-wrapper\">\n<pre tabindex=\"0\" class=\"codeblock\"><code>\/\/Connect to datastore\r\nrequire no.ssb.fdb:23 as db\r\n\r\ncreate-dataset demography\r\nimport db\/BEFOLKNING_KJOENN as gender\r\nimport db\/BEFOLKNING_FOEDSELS_AAR_MND as birth_year_month\r\n\r\ngenerate age = 2021 - int(birth_year_month \/ 100)\r\n\r\nkeep if age >= 16 & age < 67<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":7,"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-63","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>Removing units from a dataset - 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\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Removing units from a dataset - microdata.no\" \/>\n<meta property=\"og:description\" content=\"Before carrying out analyses on a data set, it is usually desirable to trim it down by removing people you do not want to include. This can be done through the drop and keep commands in combination with standard IF conditions. In the example below, the sample is trimmed down to contain people between 16...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T15:39:19+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\\\/eksempel\\\/fjerning-av-individer-enheter-fra-et-datasett\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/fjerning-av-individer-enheter-fra-et-datasett\\\/\",\"name\":\"Removing units from a dataset - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-02-11T13:07:31+00:00\",\"dateModified\":\"2023-10-27T15:39:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/fjerning-av-individer-enheter-fra-et-datasett\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/fjerning-av-individer-enheter-fra-et-datasett\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/fjerning-av-individer-enheter-fra-et-datasett\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Removing units from a dataset\"}]},{\"@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":"Removing units from a dataset - 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\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/","og_locale":"en_US","og_type":"article","og_title":"Removing units from a dataset - microdata.no","og_description":"Before carrying out analyses on a data set, it is usually desirable to trim it down by removing people you do not want to include. This can be done through the drop and keep commands in combination with standard IF conditions. In the example below, the sample is trimmed down to contain people between 16...","og_url":"https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/","og_site_name":"microdata.no","article_modified_time":"2023-10-27T15:39:19+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\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/","url":"https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/","name":"Removing units from a dataset - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-02-11T13:07:31+00:00","dateModified":"2023-10-27T15:39:19+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/eksempel\/fjerning-av-individer-enheter-fra-et-datasett\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"Removing units from a dataset"}]},{"@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\/63","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=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}