\n
\/\/Bygge opp et datasett\r\n\r\nrequire no.ssb.fdb:25 as ds\r\n\r\ncreate-dataset totalpop\r\n\r\nimport ds\/BEFOLKNING_FOEDSELS_AAR_MND as faarmnd\r\ngenerate alder = 2021 - int(faarmnd\/100)\r\nhistogram alder, discrete\r\n\r\nimport ds\/BEFOLKNING_STATUSKODE 2021-01-01 as regstat\r\nkeep if regstat == '1'\r\n\r\nhistogram alder, discrete\r\nsummarize alder\r\n\r\nkeep if alder > 30 & alder < 50\r\n\r\nimport ds\/BEFOLKNING_KJOENN as kj\u00f8nn\r\nimport ds\/BEFOLKNING_FODELAND as land\r\nimport ds\/NUDB_BU 2021-07-31 as utd\r\nimport ds\/BEFOLKNING_KOMMNR_FAKTISK 2021-01-01 as bosted\r\nimport ds\/INNTEKT_LONN 2017-12-31 as l\u00f8nn17\r\nimport ds\/INNTEKT_LONN 2018-12-31 as l\u00f8nn18\r\nimport ds\/INNTEKT_LONN 2019-12-31 as l\u00f8nn19\r\nimport ds\/INNTEKT_LONN 2020-12-31 as l\u00f8nn20\r\nimport ds\/INNTEKT_LONN 2021-12-31 as l\u00f8nn21\r\n\r\n\/\/Kj\u00f8re deskriptiv statistikk\r\n\r\n\/\/Endimensjonalt\r\nsummarize l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21\r\nsummarize l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21, gini\r\n\r\nbarchart (mean) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21\r\nbarchart (count) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21\r\nbarchart (median) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21\r\n\r\nhistogram l\u00f8nn21, freq\r\nhistogram l\u00f8nn21, freq normal\r\nhistogram l\u00f8nn21, bin(10)\r\nhistogram l\u00f8nn21, bin(4)\r\n\r\n\/\/Todimensjonalt\r\n\r\ngenerate norsk = 0\r\nreplace norsk = 1 if land == '000'\r\ntabulate norsk\r\ntabulate norsk, cellpct\r\npiechart norsk\r\n\r\ngenerate utdniv\u00e5 = substr(utd,1,1)\r\ntabulate utdniv\u00e5, cellpct\r\ndestring utdniv\u00e5\r\n\r\nsummarize l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21 if utdniv\u00e5 < 2\r\nsummarize l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21 if utdniv\u00e5 > 6\r\n\r\ntabulate kj\u00f8nn, summarize(l\u00f8nn21)\r\ntabulate norsk, summarize(l\u00f8nn21)\r\ntabulate utdniv\u00e5, summarize(l\u00f8nn21)\r\ntabulate utdniv\u00e5 kj\u00f8nn, summarize(l\u00f8nn21)\r\n\r\nbarchart (mean) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21, over(kj\u00f8nn)\r\nbarchart (mean) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21, over(norsk)\r\nbarchart (mean) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21, over(utdniv\u00e5)\r\n\r\n\r\n\/\/Demonstrere kategorisering av yrker og labels\r\n\r\nimport ds\/REGSYS_ARB_YRKE_STYRK08 2021-11-16 as yrke\r\n\r\ngenerate yrkesgr = 9\r\nreplace yrkesgr = 1 if substr(yrke,1,1) == '1'\r\nreplace yrkesgr = 2 if yrke == '2211'\r\nreplace yrkesgr = 3 if yrke == '2212'\r\nreplace yrkesgr = 4 if yrke == '2223'\r\nreplace yrkesgr = 5 if substr(yrke,1,2) == '23'\r\nreplace yrkesgr = 6 if substr(yrke,1,2) == '25'\r\nreplace yrkesgr = 7 if substr(yrke,1,2) == '61'\r\nreplace yrkesgr = 999 if sysmiss(yrke)\r\n\r\ndefine-labels yrkelabel 1 Ledere 2 Allmennleger 3 Legespesialister 4 Sykepleiere 5 L\u00e6rere 6 'IT-utviklere' 7 Landbruk 9 Annet 999 'Uten jobb'\r\nassign-labels yrkesgr yrkelabel \r\n\r\ntabulate yrkesgr\r\ntabulate yrkesgr, cellpct\r\ntabulate yrkesgr, summarize(l\u00f8nn21)\r\nbarchart (mean) l\u00f8nn21, over(yrkesgr)\r\nbarchart (mean) l\u00f8nn17 l\u00f8nn18 l\u00f8nn19 l\u00f8nn20 l\u00f8nn21, over(yrkesgr)\r\n\r\n\r\n\/\/Kj\u00f8r familiekoblinger inkl. familie\r\n\r\nimport ds\/BEFOLKNING_FAR_FNR as far_fnr\r\nimport ds\/BEFOLKNING_MOR_FNR as mor_fnr\r\n\r\ncreate-dataset foreldre\r\nimport ds\/INNTEKT_LONN 2021-12-31 as l\u00f8nn21_far\r\nimport ds\/REGSYS_ARB_YRKE_STYRK08 2021-11-16 as yrke_far\r\nimport ds\/NUDB_BU 2021-07-31 as utd_far\r\ngenerate utdniv\u00e5_far = substr(utd_far,1,1)\r\ndestring utdniv\u00e5_far, force\r\n\r\nclone-variables l\u00f8nn21_far -> l\u00f8nn21_mor\r\nclone-variables yrke_far -> yrke_mor\r\nclone-variables utdniv\u00e5_far -> utdniv\u00e5_mor\r\n\r\nmerge l\u00f8nn21_far yrke_far utdniv\u00e5_far into totalpop on far_fnr\r\nmerge l\u00f8nn21_mor yrke_mor utdniv\u00e5_mor into totalpop on mor_fnr\r\n\r\nuse totalpop\r\nsummarize l\u00f8nn21 l\u00f8nn21_far l\u00f8nn21_mor\r\ncorrelate l\u00f8nn21 l\u00f8nn21_far\r\ncorrelate l\u00f8nn21 l\u00f8nn21_mor\r\ncorrelate l\u00f8nn21_far l\u00f8nn21_mor\r\ncorrelate utdniv\u00e5 utdniv\u00e5_far\r\ncorrelate utdniv\u00e5 utdniv\u00e5_mor\r\ncorrelate utdniv\u00e5_far utdniv\u00e5_mor\r\n\r\ncorrelate l\u00f8nn21 l\u00f8nn21_far if kj\u00f8nn == '1'\r\ncorrelate l\u00f8nn21 l\u00f8nn21_mor if kj\u00f8nn == '2'\r\ncorrelate utdniv\u00e5 utdniv\u00e5_far if kj\u00f8nn == '1'\r\ncorrelate utdniv\u00e5 utdniv\u00e5_mor if kj\u00f8nn == '2'\r\n\r\ngenerate yrkesgr_far = 9\r\nreplace yrkesgr_far = 1 if substr(yrke_far,1,1) == '1'\r\nreplace yrkesgr_far = 2 if yrke_far == '2211'\r\nreplace yrkesgr_far = 3 if yrke_far == '2212'\r\nreplace yrkesgr_far = 4 if yrke_far == '2223'\r\nreplace yrkesgr_far = 5 if substr(yrke_far,1,2) == '23'\r\nreplace yrkesgr_far = 6 if substr(yrke_far,1,2) == '25'\r\nreplace yrkesgr_far = 7 if substr(yrke_far,1,2) == '61'\r\nreplace yrkesgr_far = 999 if sysmiss(yrke_far)\r\n\r\nassign-labels yrkesgr_far yrkelabel\r\ntabulate yrkesgr_far yrkesgr if yrkesgr_far < 9, rowpct\r\ntabulate yrkesgr_far yrkesgr if yrkesgr_far < 9 & kj\u00f8nn == '1', rowpct\r\n\r\n\r\n\/\/Til slutt kj\u00f8res noen enkle regresjoner: regress og logit\r\n\r\ngenerate oslo = 1 if bosted == '0301'\r\nreplace oslo = 0 if bosted != '0301'\r\ntabulate oslo, cellpct\r\n\r\ngenerate h\u00f8y_utd = 1 if utdniv\u00e5 >= 7\r\nreplace h\u00f8y_utd = 0 if utdniv\u00e5 >= 0 & utdniv\u00e5 < 7\r\n\r\nregress l\u00f8nn21 alder norsk oslo i.kj\u00f8nn h\u00f8y_utd l\u00f8nn21_far\r\ncoefplot regress l\u00f8nn21 alder norsk oslo i.kj\u00f8nn h\u00f8y_utd l\u00f8nn21_far\r\nregress-predict l\u00f8nn21 alder norsk oslo i.kj\u00f8nn h\u00f8y_utd l\u00f8nn21_far, residuals(res)\r\nhistogram res\r\nhistogram res, normal\r\n\r\ngenerate h\u00f8y_l\u00f8nn = 0\r\nreplace h\u00f8y_l\u00f8nn = 1 if l\u00f8nn21 > 800000\r\n\r\ngenerate h\u00f8y_l\u00f8nn_far = 0\r\nreplace h\u00f8y_l\u00f8nn_far = 1 if l\u00f8nn21_far > 800000\r\n\r\nlogit h\u00f8y_l\u00f8nn alder norsk oslo i.kj\u00f8nn h\u00f8y_utd h\u00f8y_l\u00f8nn_far\r\ncoefplot logit h\u00f8y_l\u00f8nn alder norsk oslo i.kj\u00f8nn h\u00f8y_utd h\u00f8y_l\u00f8nn_far\r\n\r\n\r\n\/\/Forl\u00f8psuttrekk: Identifisere personer med status som skilt i l\u00f8pet av 2021\r\ncreate-dataset forl\u00f8p\r\nimport-event ds\/SIVSTANDFDT_SIVSTAND 2021-01-01 to 2021-12-31 as sivforl\u00f8p\r\nkeep if sivforl\u00f8p == '4'\r\ncollapse (count) sivforl\u00f8p , by(PERSONID_1 )\r\nrename sivforl\u00f8p ant_ganger_skilt\r\ntabulate ant_ganger_skilt\r\nmerge ant_ganger_skilt into totalpop\r\n\r\nuse totalpop\r\ngenerate skilt2021 = 0\r\nreplace skilt2021 = 1 if ant_ganger_skilt >= 1\r\ntabulate skilt2021, cellpct freq<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":133,"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-2136","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"\nCourse set solutions - beginners course - 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\/course-set-solutions-beginners-course\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Course set solutions - beginners course - microdata.no\" \/>\n<meta property=\"og:description\" content=\"Skriptet nedenfor viser hvordan man l\u00f8ser oppgavene i oppgavesettet som benyttes for det ordin\u00e6re innf\u00f8ringskurset som Sikt og SSB kj\u00f8rer med jevne mellomrom. Klikk her for mer info om v\u00e5re kurs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T14:32:27+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\\\/course-set-solutions-beginners-course\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/course-set-solutions-beginners-course\\\/\",\"name\":\"Course set solutions - beginners course - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-04-04T10:17:54+00:00\",\"dateModified\":\"2023-10-30T14:32:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/course-set-solutions-beginners-course\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/course-set-solutions-beginners-course\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/eksempel\\\/course-set-solutions-beginners-course\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Course set solutions – beginners course\"}]},{\"@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":"Course set solutions - beginners course - 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\/course-set-solutions-beginners-course\/","og_locale":"en_US","og_type":"article","og_title":"Course set solutions - beginners course - microdata.no","og_description":"Skriptet nedenfor viser hvordan man l\u00f8ser oppgavene i oppgavesettet som benyttes for det ordin\u00e6re innf\u00f8ringskurset som Sikt og SSB kj\u00f8rer med jevne mellomrom. Klikk her for mer info om v\u00e5re kurs.","og_url":"https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/","og_site_name":"microdata.no","article_modified_time":"2023-10-30T14:32:27+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\/course-set-solutions-beginners-course\/","url":"https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/","name":"Course set solutions - beginners course - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-04-04T10:17:54+00:00","dateModified":"2023-10-30T14:32:27+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/en\/eksempel\/course-set-solutions-beginners-course\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"Course set solutions – beginners course"}]},{"@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\/2136","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=2136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}