Information about ongoing education (so-called course data) is available with courses as unit level (with associated course identifier). Courses are given by the combination of person x course type, where each individual can in practice be represented by several course types at the same time.<\/p>\n\n\n\n
Since course data does not have a person as a unit, these cannot be imported into personal datasets in the usual way, but must be connected using the\u00a0 First, you have to add a link between the course ID and the person ID on the course data. You then have to aggregate up to person level using the command\u00a0 In the example, a personal dataset is first created consisting of people residing in Norway ( NB! Note that the kurstype (course type) variable after using merge<\/code>\u00a0command.<\/p>\n\n\n\ncollapse<\/code>\u00a0before finally connecting to the personal dataset.<\/p>\n\n\n\nregstatus == '1'<\/code>) as of 2021-01-01. A history of ongoing education is then retrieved for the entire year 2021, where you select for education at a higher level (master’s or higher, level 7 and 8). The command collapse(count)<\/code> is used to count the number of observations with ongoing education per individual over the year 2021, and the result is then linked to the person dataset for further analysis.<\/p>\n\n\n\ncollapse<\/code> will consist of values \u200b\u200bfor the relevant statistic being run, in this case the number of observations (count<\/code>).<\/p>\n\n\n\/\/Kobler til databank\r\nrequire no.ssb.fdb:23 as db\r\n\r\n\/\/Oppretter persondatasett for bosatte per 2020-01-01\r\ncreate-dataset bosatte\r\nimport db\/BEFOLKNING_KJOENN as kj\u00f8nn\r\nimport db\/BEFOLKNING_STATUSKODE 2020-01-01 as regstatus\r\nkeep if regstatus == '1'\r\n\r\n\/\/Henter personer som tar h\u00f8yere utdanning i l\u00f8pet av 2020\r\ncreate-dataset kursdata\r\nimport-event db\/NUDB_KURS_NUS 2020-01-01 to 2020-12-31 as kurstype\r\ndestring kurstype\r\nkeep if kurstype >= 700000 & kurstype < 900000\r\n\r\n\/\/Kobler p\u00e5 lenke mellom kurs-id og f\u00f8dselsnumre\r\ncreate-dataset lenke_kurs_person\r\nimport db\/NUDB_KURS_FNR as fnr\r\nmerge fnr into kursdata\r\n\r\n\/\/Lager statistikk (collapser) over antall hendelser med h\u00f8y utdanning per individ, og kobler dette p\u00e5 persondatasettet\r\nuse kursdata\r\ncollapse (count) kurstype, by(fnr)\r\nrename kurstype ant_kurs\r\nmerge ant_kurs into bosatte\r\n\r\n\/\/Lager tabell over antall personer som tok h\u00f8y utdanning i l\u00f8pet av 2020\r\nuse bosatte\r\ngenerate utdanning_h\u00f8y = 0\r\nreplace utdanning_h\u00f8y = 1 if ant_kurs >= 1\r\ntabulate utdanning_h\u00f8y kj\u00f8nn<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":97,"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-1279","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"\n