{"id":1271,"date":"2022-02-11T16:04:51","date_gmt":"2022-02-11T15:04:51","guid":{"rendered":"https:\/\/microdata.spirehost.no\/?post_type=eksempel&#038;p=1271"},"modified":"2023-10-27T16:39:20","modified_gmt":"2023-10-27T15:39:20","slug":"using-functions-for-row-variable-calculations","status":"publish","type":"eksempel","link":"https:\/\/www.microdata.no\/en\/eksempel\/using-functions-for-row-variable-calculations\/","title":{"rendered":"Using functions for row\/variable calculations"},"content":{"rendered":"\n<p>Below we demonstrate how to create variables that contain the result of various calculations on row level. Row functions perform calculations at the individual level, across selected variables.<\/p>\n\n\n\n<p>This is just a small bunch of all available row functions. Use the <code>help-function<\/code> command to get an overview of other functions.<\/p>\n\n\n<div id=\"rose-block_9082a8214444e8e7217aaca627b73b44\" class=\"rose-code codeblock-wrapper\">\n<pre tabindex=\"0\" class=\"codeblock\"><code>require no.ssb.fdb:23 as db\r\n\r\ncreate-dataset rowtest\r\nimport db\/BEFOLKNING_KOMMNR_FAKTISK 2019-01-01 as municipality\r\nsample 10000 1234\r\nimport db\/BEFOLKNING_KJOENN as gender\r\nimport db\/INNTEKT_WLONN 2019-01-01 as wage19\r\nimport db\/INNTEKT_WLONN 2020-01-01 as wage20\r\nimport db\/INNTEKT_WLONN 2021-01-01 as wage21\r\n\r\n\/\/Merge string values\r\ngenerate firstname = 'Ole' if gender == '1'\r\nreplace firstname = 'Kari' if gender == '2'\r\ngenerate lastname = 'Hansen'\r\ngenerate name = rowconcat(firstname, ' ', lastname)\r\ntabulate name\r\n\r\n\/\/Find the highest annual salary for each individual over the years 2019-2021\r\ngenerate maxwage19_21 = rowmax(wage19, wage20, wage21)\r\nsummarize maxwage19_21<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":36,"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-1271","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>Using functions for row\/variable calculations - 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\/bruke-funksjoner-for-rekke-variabelberegninger\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using functions for row\/variable calculations - microdata.no\" \/>\n<meta property=\"og:description\" content=\"Below we demonstrate how to create variables that contain the result of various calculations on row level. Row functions perform calculations at the individual level, across selected variables. This is just a small bunch of all available row functions. Use the help-function command to get an overview of other functions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T15:39:20+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\\\/bruke-funksjoner-for-rekke-variabelberegninger\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/bruke-funksjoner-for-rekke-variabelberegninger\\\/\",\"name\":\"Using functions for row\\\/variable calculations - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-02-11T15:04:51+00:00\",\"dateModified\":\"2023-10-27T15:39:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/bruke-funksjoner-for-rekke-variabelberegninger\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/bruke-funksjoner-for-rekke-variabelberegninger\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/bruke-funksjoner-for-rekke-variabelberegninger\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using functions for row\\\/variable calculations\"}]},{\"@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":"Using functions for row\/variable calculations - 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\/bruke-funksjoner-for-rekke-variabelberegninger\/","og_locale":"en_US","og_type":"article","og_title":"Using functions for row\/variable calculations - microdata.no","og_description":"Below we demonstrate how to create variables that contain the result of various calculations on row level. Row functions perform calculations at the individual level, across selected variables. This is just a small bunch of all available row functions. Use the help-function command to get an overview of other functions.","og_url":"https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/","og_site_name":"microdata.no","article_modified_time":"2023-10-27T15:39:20+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\/bruke-funksjoner-for-rekke-variabelberegninger\/","url":"https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/","name":"Using functions for row\/variable calculations - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-02-11T15:04:51+00:00","dateModified":"2023-10-27T15:39:20+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/eksempel\/bruke-funksjoner-for-rekke-variabelberegninger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"Using functions for row\/variable calculations"}]},{"@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\/1271","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=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}