{"id":1267,"date":"2022-02-11T16:00:41","date_gmt":"2022-02-11T15:00:41","guid":{"rendered":"https:\/\/microdata.spirehost.no\/?post_type=eksempel&#038;p=1267"},"modified":"2023-10-27T16:39:19","modified_gmt":"2023-10-27T15:39:19","slug":"converting-from-alfanumerical-text-format-to-numerical-value-format","status":"publish","type":"eksempel","link":"https:\/\/www.microdata.no\/en\/eksempel\/converting-from-alfanumerical-text-format-to-numerical-value-format\/","title":{"rendered":"Converting from alfanumerical (text format) to numerical value format"},"content":{"rendered":"\n<p>A number of variables use alfanumerical value format (text format). In these cases the values need to be designated with single quotation marks, f.x. &#8216;1&#8217;, &#8216;2&#8217;. The <code>destring<\/code> command can be used to convert the alfanumerical values into numerical values.<\/p>\n\n\n\n<p>The example below demonstrates how to convert the values of the variable <code>gender<\/code> from alfanumerical to numerical. Note: The variable keeps the original name as it is only the value format that is changed.<\/p>\n\n\n<div id=\"rose-block_0ccec8ac7d601075d646f30f11397f4b\" 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\ntabulate gender\r\ndestring gender\r\n\r\n\/\/Generate descriptive statistics for the numerical gender variable\r\nsummarize gender<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":23,"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-1267","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Converting from alfanumerical (text format) to numerical value format - 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\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Converting from alfanumerical (text format) to numerical value format - microdata.no\" \/>\n<meta property=\"og:description\" content=\"A number of variables use alfanumerical value format (text format). In these cases the values need to be designated with single quotation marks, f.x. &#8216;1&#8217;, &#8216;2&#8217;. The destring command can be used to convert the alfanumerical values into numerical values. The example below demonstrates how to convert the values of the variable gender from alfanumerical...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/\" \/>\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\\\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\\\/\",\"name\":\"Converting from alfanumerical (text format) to numerical value format - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-02-11T15:00:41+00:00\",\"dateModified\":\"2023-10-27T15:39:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Converting from alfanumerical (text format) to numerical value format\"}]},{\"@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":"Converting from alfanumerical (text format) to numerical value format - 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\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/","og_locale":"en_US","og_type":"article","og_title":"Converting from alfanumerical (text format) to numerical value format - microdata.no","og_description":"A number of variables use alfanumerical value format (text format). In these cases the values need to be designated with single quotation marks, f.x. &#8216;1&#8217;, &#8216;2&#8217;. The destring command can be used to convert the alfanumerical values into numerical values. The example below demonstrates how to convert the values of the variable gender from alfanumerical...","og_url":"https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/","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\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/","url":"https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/","name":"Converting from alfanumerical (text format) to numerical value format - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-02-11T15:00:41+00:00","dateModified":"2023-10-27T15:39:19+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/eksempel\/konvertere-fra-alfanumerisk-tekst-til-numerisk-verdiformat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"Converting from alfanumerical (text format) to numerical value format"}]},{"@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\/1267","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=1267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}