{"id":1362,"date":"2020-12-10T13:10:00","date_gmt":"2020-12-10T12:10:00","guid":{"rendered":"https:\/\/microdata.spirehost.no\/?p=1362"},"modified":"2022-02-16T13:17:30","modified_gmt":"2022-02-16T12:17:30","slug":"new-variable-functionality-functions-for-variable-calculations","status":"publish","type":"post","link":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/","title":{"rendered":"New variable functionality: Functions for variable calculations"},"content":{"rendered":"\n

Microdata.no has now been expanded with a number of new functions that can be used to make various calculations of records \/ rows. This automates and makes it easier to generate variables based on different calculations:<\/p>\n\n\n\n\n\n\n\n

Row function<\/th>Calculation (arguments can be variables or numbers)<\/th><\/tr><\/thead>
rowconcat<\/td>Linking the arguments of the given unit (string \/ alphanumeric)<\/td><\/tr>
rowmax<\/td>The maximum value among the arguments for the given unit<\/td><\/tr>
rowmin<\/td>The minimum value among the arguments for the given unit<\/td><\/tr>
rowmean<\/td>The average value among the arguments for the given unit<\/td><\/tr>
rowmedian<\/td>The median value among the arguments for the given unit<\/td><\/tr>
rowmissing<\/td>Number of missing values among the arguments for the given unit<\/td><\/tr>
rowstd<\/td>The standard deviation of the arguments for the given unit<\/td><\/tr>
rowtotal<\/td>The total sum of the arguments for the given unit<\/td><\/tr>
rowvalid<\/td>Number of valid values among the arguments for the given unit<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Example of obtaining maximum salary per individual measured over a given number of years:<\/p>\n\n\n

\n
generate maxsalary = rowmax (salary16, salary17, salary18, salary19)<\/code><\/pre>\n<\/div>\n\n\n
For more details, we recommend to use the help-function command, e.g.\u00a0<\/p>\n\n\n
\n
help-function rowconcat<\/code><\/pre>\n<\/div>\n\n\n
Click here for examples on using row functions<\/a><\/p>\n\n\n\n
We work continuously to improve microdata.no so that most analysis needs can be met. Thus, more and more analysis options will be introduced. We are based on input from researchers, and have compiled a list of new tools that we work through. Do you have specific suggestions for new functionality? Feel free to contact us by email:\u00a0support@microdata.no<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Microdata.no has now been expanded with a number of new functions that can be used to make various calculations of records \/ rows. This automates and makes it easier to generate variables based on different calculations:<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","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":"","footnotes":""},"categories":[2],"tags":[],"class_list":["post-1362","post","type-post","status-publish","format-standard","hentry","category-news"],"acf":[],"yoast_head":"\nNew variable functionality: Functions for 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\/en\/new-variable-functionality-functions-for-variable-calculations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New variable functionality: Functions for variable calculations - microdata.no\" \/>\n<meta property=\"og:description\" content=\"Microdata.no has now been expanded with a number of new functions that can be used to make various calculations of records \/ rows. This automates and makes it easier to generate variables based on different calculations:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-10T12:10:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-16T12:17:30+00:00\" \/>\n<meta name=\"author\" content=\"Trond Pedersen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Trond Pedersen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/\"},\"author\":{\"name\":\"Trond Pedersen\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#\\\/schema\\\/person\\\/76761ddfe0d06e3f08f5491a9faeab92\"},\"headline\":\"New variable functionality: Functions for variable calculations\",\"datePublished\":\"2020-12-10T12:10:00+00:00\",\"dateModified\":\"2022-02-16T12:17:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/\"},\"wordCount\":247,\"articleSection\":[\"News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/\",\"name\":\"New variable functionality: Functions for variable calculations - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2020-12-10T12:10:00+00:00\",\"dateModified\":\"2022-02-16T12:17:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#\\\/schema\\\/person\\\/76761ddfe0d06e3f08f5491a9faeab92\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/new-variable-functionality-functions-for-variable-calculations\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New variable functionality: Functions for 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\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#\\\/schema\\\/person\\\/76761ddfe0d06e3f08f5491a9faeab92\",\"name\":\"Trond Pedersen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g\",\"caption\":\"Trond Pedersen\"},\"url\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/author\\\/trond\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New variable functionality: Functions for 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\/en\/new-variable-functionality-functions-for-variable-calculations\/","og_locale":"en_US","og_type":"article","og_title":"New variable functionality: Functions for variable calculations - microdata.no","og_description":"Microdata.no has now been expanded with a number of new functions that can be used to make various calculations of records \/ rows. This automates and makes it easier to generate variables based on different calculations:","og_url":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/","og_site_name":"microdata.no","article_published_time":"2020-12-10T12:10:00+00:00","article_modified_time":"2022-02-16T12:17:30+00:00","author":"Trond Pedersen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Trond Pedersen","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/#article","isPartOf":{"@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/"},"author":{"name":"Trond Pedersen","@id":"https:\/\/www.microdata.no\/#\/schema\/person\/76761ddfe0d06e3f08f5491a9faeab92"},"headline":"New variable functionality: Functions for variable calculations","datePublished":"2020-12-10T12:10:00+00:00","dateModified":"2022-02-16T12:17:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/"},"wordCount":247,"articleSection":["News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/","url":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/","name":"New variable functionality: Functions for variable calculations - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2020-12-10T12:10:00+00:00","dateModified":"2022-02-16T12:17:30+00:00","author":{"@id":"https:\/\/www.microdata.no\/#\/schema\/person\/76761ddfe0d06e3f08f5491a9faeab92"},"breadcrumb":{"@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/en\/new-variable-functionality-functions-for-variable-calculations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"New variable functionality: Functions for 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"},{"@type":"Person","@id":"https:\/\/www.microdata.no\/#\/schema\/person\/76761ddfe0d06e3f08f5491a9faeab92","name":"Trond Pedersen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b90e3f42c839e825d86949fc2f9a318f2a81da5f9e6b1431ff4d872333d4e717?s=96&d=mm&r=g","caption":"Trond Pedersen"},"url":"https:\/\/www.microdata.no\/en\/author\/trond\/"}]}},"taxonomy_info":{"category":[{"value":2,"label":"News"}]},"featured_image_src_large":false,"author_info":{"display_name":"Trond Pedersen","author_link":"https:\/\/www.microdata.no\/en\/author\/trond\/"},"comment_info":0,"category_info":[{"term_id":2,"name":"News","slug":"news","term_group":0,"term_taxonomy_id":2,"taxonomy":"category","description":"","parent":0,"count":79,"filter":"raw","cat_ID":2,"category_count":79,"category_description":"","cat_name":"News","category_nicename":"news","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/posts\/1362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/comments?post=1362"}],"version-history":[{"count":8,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/posts\/1362\/revisions"}],"predecessor-version":[{"id":1371,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/posts\/1362\/revisions\/1371"}],"wp:attachment":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/media?parent=1362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/categories?post=1362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/tags?post=1362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}