The analysis system microdata.no is based on the left-join principle. This means that the first variable that is created determines the size of the population. If this is a universal variable such as gender, your dataset will consist of as many individuals as possible from the total database, including people who have died, emigrated or were not born at the time you want to analyse.<\/p>\n\n\n\n
Do you start by importing a variable that only applies to a limited number of individuals, e.g. disability benefits, your dataset will only consist of people in Norway who received disability benefits at the relevant time you are measuring.<\/p>\n\n\n\n
You cannot make the population larger than variable no. 1 allows for (unless you use the option outer_join<\/code>). So you have to think about which variable you start importing, so that you get all the people you want to analyse with you. However, you can make populations smaller if you wish. This is done using the\u00a0drop if<\/code>\u00a0or\u00a0keep if<\/code> command.<\/p>\n\n\n\/\/Connect to datastore\r\nrequire no.ssb.fdb:23 as db\r\n\r\n\/\/Example 1: Population = all residents of Bergen as of 1\/1 2021\r\ncreate-dataset eks1\r\nimport db\/BEFOLKNING_KOMMNR_FAKTISK 2021-01-01 as residence\r\nkeep if residence == '4601'\r\n\r\n\/\/Example 2: Population = all residents of Vestland as of 1\/1 2021\r\ncreate-dataset eks2\r\nimport db\/BEFOLKNING_KOMMNR_FAKTISK 2021-01-01 as residence\r\nkeep if substr(residence, 1, 2) == '46'\r\n\r\n\/\/Example 3: Population = everyone with an occupational income in the year 2021 (= everyone with an annual occupational income > 0 in 2021)\r\ncreate-dataset eks3\r\nimport db\/INNTEKT_WYRKINNT 2021-12-31 as work_income\r\n\r\n\/\/Example 4: When you start with a universal variable but actually want to analyse individuals with given characteristics at a given time\r\ncreate-dataset eks4\r\nimport db\/BEFOLKNING_KJOENN as gender\r\nimport db\/INNTEKT_WYRKINNT 2021-12-31 as work_income\r\ndrop if sysmiss(work_income)\r\n\r\n\/\/Example 5: When you start with a universal variable but actually want to analyse individuals who were actually resident in Norway at a given time. The variable BEFOLKNING_STATUSKODE is suitable for this purpose as it contains codes for respectively \"resident\", \"dead\" and \"emigrated\". \"Resident\" has the code '1'.\r\ncreate-dataset eks5\r\nimport db\/BEFOLKNING_KJOENN as gender\r\nimport db\/BEFOLKNING_STATUSKODE 2021-01-01 as regstatus\r\nkeep if regstatus == '1'<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":6,"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-61","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"\n