Linking of external data
Statistics Denmark’s register data can be linked with other data materials, here called external data. This can be, for example, extractions from registers outside Statistics Denmark, your own data – for example survey data – or data from other data providers., External data must be documented and comply with the same requirements to data minimisation and statistical disclosure control that Statistics Denmark applies in general., These requirements must ensure that only external data needed in the project is provided and that Denmark’s Data Portal get the information necessary to be able to handle the additional microdata and make it available in the specific project., Use of external data must comply with the same rules regarding confidentiality and transfer as those that apply to Statistics Denmark’s microdata. , Read more about the rules on transfer and sanctioning, Any other data must be provided safely to Statistics Denmark. , You will find the guide for uploading external data sets under ‘Use of DDV upload’, Requirements for external data, Only approved and documented data:, External data must be covered by an approved project proposal. Documentation of the external data content must be uploaded as an appendix in the DDP App. See below under ‘Documentation of external data’., No information identifying individuals or businesses:, Personal names, company names, responses with free text in surveys and other information roughly identifying individuals or businesses is not allowed to be included in external data. Such variables must be removed or categorised before external data is provided to Denmark’s Data Portal., Only the required key variables:, You may include only the key variables, e.g. civil registration number, required to link the external data with the other data on the project. Key variables that are not needed must be removed before data is provided to Denmark’s Data Portal., Only numeric variables and categorised text variables:, External data may not include non-categorised text variables, such as free text., Only information required for the specific project:, Key variables for which there is no need, must be removed before data is provided to Denmark’s Data Portal., File formats,
External data may be provided in the following formats:, .ASC, .CSV, .DTA, .ODS, .PDF, .SAS7BCAT, .SAS7BDAT, .SAV, .XLS, .XLSX, Documentation of external data, External data must be documented, so that Denmark’s Data Portal gets the information that is necessary to be able to handle the external data and provide it for the specific project. For that reason, the institution is responsible for uploading an overview with the below content as an appendix in the DDP App., A short description of data (for example origin and content), Name of the data set, names of variables and a description of the variable content., The key variables that must be de-identified. This means the variables required to link the external data with the other data in the project (e.g. civil registration number)., Which additional variables must be de-identified? This means variables that can be attributed directly to individuals or businesses (e.g. CVR number, grant number for health practitioner, serial number, or other ID numbers)., Does the external data include key variables that must be linked with key variables in previously provided data sets?, If data is provided directly to Denmark’s Data Portal from another data provider, further documentation may be necessary, e.g. variables that must be deleted (see ‘Requirements for external data’ above)., The overview must be uploaded as an appendix in the DDP App under ’External data sources’ in a generally available format (Excel, Word or similar)., If data is to be linked with more populations, the documentation must be attached as an appendix under ‘External data sources’ for minimum one of these populations. The external data must appear under ‘External data sources’ for each population., When the external data has been provided to Statistics Denmark and the documentation has been uploaded in the DDP App, it is recommended that you notify the project owner in Denmark’s Data Portal via email., Prices for delivery of submitted data, The price for the delivery of submitted data is variable. Once we have received the data, we prepare a framework agreement with a maximum expected time consumption. After delivery of the data, we settle based on the actual time consumption. , See more about framework agreements under Prices and price agreements, ., The expected time consumption depends on many factors, including the number, size, complexity and format of the files. Therefore, we always prepare framework agreements for submitted data on a case-by-case basis, and only when we have received the specific data sets., The table below provides a guide to the typical relationship between the number of data sets and the maximum expected time consumption. Please note, however, that the number of data sets is only one of many factors, and the table is therefore only a guide. Other factors, such as size, number of variables, or special treatment, may increase or decrease the number of hours in the specific framework agreement. Contact the project manager in Denmark’s Data Portal if you need a more precise estimate., See the current hourly rates under Prices and price agreements, Number of datasets, Typical number of hours in framework agreement (indicative), 1-2, 2-4, 3-10, 4-8, 11-20, 8-14, 21-50, 14-20, NOTE: The number of hours in the framework agreement is typically set to accommodate unforeseen circumstances. Since the settlement is based on the actual time spent, the final price will in many cases be lower., Submitting files that do not include microdata, Files that you need in your project and that do not include microdata (e.g. programme files), must not be uploaded via DDV Upload., The files can be sent directly to the project owner in Denmark’s Data Portal, if you are working on a subproject for a project database. If you are working under the researcher scheme, you can send an email to , danmarksdatavindue@dst.dk, . In both instances, you must attach the files to the email. Further, you must:, Confirm that you have checked the files to ensure that they do not include microdata., Confirm that the files do not include microdata., Provide a short description of the content of the files and its relevance in terms of the purpose of the project., Indicate the specific path to where the files must be located., Ensure that the files are submitted in a generally available format that can be opened and checked by Denmark’s Data Portal without use of specialised software., , De-identification, When the external data has been received in Denmark’s Data Portal it will be de-identified in the same way as any other data that belongs to the project. This happens by de-identifying key variables. Subsequently, the external data is made available together with any other data in the project., Providing external data to Denmark’s Data Portal, External data must be provided safely to Statistics Denmark, External data can be provided safely to Statistics Denmark in the ways stated below:, Use of DDV Upload, Under Statistics Denmark’s microdata schemes, it is possible to upload additional files with data to be used in an existing project. Only data and documentation can be uploaded. Programmes etc. can be sent to the Denmark’s Data Portal employee who is responsible for the project (project owner)., The documentation must either be sent to the project owner from Statistics Denmark or be uploaded in one of the allowed file formats., Before you upload, Before you upload data to be used in a project, you must ensure that the criteria for use of your data in the project have been met. The requirements are described at the top of the page under ‘Requirements for external data’., The handling of external data is invoiced according to the actual time used, unless otherwise agreed., Contact the project owner in Statistics Denmark in advance., How to upload the files, You log in via remote.dst.dk in the same way as when you are going to work on a project., Under 'Applications and Links' select 'DDV Upload'., Write the project number of the project where your data is to be used., When the project title is shown next to the project number, you must check that you have selected the right project for uploading of data., If relevant, add a comment concerning your data in the comments field for the project owner at Statistics Denmark. Actual correspondence should take place via email. , Add files to be uploaded by clicking `Add file'. You can add one or more files. Each file may run up to 2 GB., Note that not all types of files can be uploaded. You can see the list of allowed types under `File formats' further up on the page., When all files have been selected, you must click `Upload'., When all the files have been uploaded, you can log out in the bottom right-hand corner., If relevant, see , this guide for DDV upload (pdf, in Danish), , which includes screenshots of the upload process., Use of secure email, Data with a max. file size of 100 MB can be sent via secure email to , forskerpost@dst.dk, in one of two ways: , The institution retrieves Statistics Denmark's certificate at the website for download of security certificates (in Danish): Select , forskerpost@dst.dk, . For Outlook, we recommend the Vcf format. ,
After this, external data must be sent to , forskerpost@dst.dk, . Always indicate project number and project owner in Denmark’s Data Portal in the subject field of the email and notify the project owner in Denmark’s Data Portal directly, once the external data has been sent. Statistics Denmark does not offer any support for encryption or digital signature. Refer to your own IT department for guidance using mitID and secure email., The institution can use a secure, encrypted tunnel (SEPO). The set-up is individual for different institutions and must be handled by the institution's IT department, which should be involved before the external data is sent.,
You must always indicate the project number and notify the project owner in Denmark’s Data Portal that the email has been sent using an encrypted tunnel (SEPO). If using an encrypted tunnel, external data must also be sent to , forskerpost@dst.dk, ., Registered letter or personal delivery, For data security reasons, we recommend that you use one of the above options., If this is not possible (e.g. if the files are very big), it is possible to provide password-protected external data on physical media directly to Statistics Denmark at the below address. The contact person for the project in Denmark’s Data Portal and the project number must always appear from the material handed in:, Statistics Denmark, Service Desk,
Sankt Kjelds Plads 11,
2100 Copenhagen Ø, Att. Contact person for the project in Denmark’s Data Portal,
Re. project number: 7XXXXX, External data can either be delivered personally at Statistics Denmark's reception or be sent by registered mail to Statistics Denmark on a physical medium (DVD, CD-ROM or USB, which will not be returned). When provided on a physical medium, the external data must be password-protected. Password must not be provided together with the physical medium., When the external data has been received, you must send the password via email to the contact person for the project in Denmark’s Data Portal., , Other data providers, Other data providers can provide external data directly to Statistics Denmark at the request of the institution and by agreement between Denmark’s Data Portal and the data provider. Delivery of external data must take place in one of the above ways, but you must make sure that the external data complies with the requirements above before it are delivered to RDenmark’s Data Portal., Do , not , send data via standard email, External data must not be sent via standard email, since this is not a secure delivery mode.
https://www.dst.dk/en/TilSalg/data-til-forskning/anmodning-om-data/tilknytning-af-eksterne-data
