1
1.
Name of database
Danish Input-Output Data
2.
Owner of data in database
Statistics Denmark
3.
DRUID contact
Ina Drejer
Department of Business Studies
Aalborg University
Fibigerstraede 4
DK-9220 Aalborg O
Phone: +45 96 35 82 52
Fax: + 45 98 15 60 13
e-mail: id@business.auc.dk
4.
Brief verbal description of database
The database consists of input-output matrices and capital matrices for Denmark for the
period 1966-1992 at a 117 sector aggregation, and input-output matrices for the period
1988-1992 at a 130 sector aggregation. The 130 sector aggregation follows SNA93, and
this is the level of aggregation that will be used for publishing all new input-output
matrices.
The database consists of input-output matrices for domestic intermediate flows,
intermediate import flows, final consumption, consumer goods, primary inputs, and import
taxes. Matrices of employment are also included in the database.
5.
Population
Industries as specified in national accounts
6.
Number of cases in database per time unit
117 industries for the period 1966-1992 and 130 industries for the period starting 1988
7.
Total number of cases in database
2
N.A.
8.
Number of variables in database
See attached lists of matrices.
9.
Spatial coverage
Denmark
10.
Temporal coverage
Annual data 1966-1992.
11.
Sectoral coverage
All economic activities
12.
Size coverage
N.A.
13.
Accessible on the Internet?
No
14.
Update planned?
The database will be updated as soon as new tables are published from Statistics Denmark.
Data for 1993 and 1994 are expected in the fall of 1998. Data for 1995 and 1996 will not
be ready until 1999. Normally data will be available 2-3 years after the end of the calendar
year.
15.
References to publications where the database has been used
Drejer, I. (1998),
Technological Interdependence in the Danish Economy - A Comparison
of Methods for Identifying Knowledge Flows
, paper presented at the Twelfth International
Conference on Input-Output Techniques, New York, 18-22 May 1998.
Møller, F. & M. Wier (1998),
Indirect and Avoided Environmental Consequences in
Analysis, Denmark. Paper presented at the Twelfth International Conference on
Input-Output Techniques, New York, 18-22 May 1998. The paper can be downloaded from
http://inforumWeb.umd.edu/WorkPaper/IOPAP/flemio.pdf
16.
Source of further information
Statistics Denmark (1993),
Input-output tabeller og analyser 1993
.
Statistics Denmark (1997),
Nyt nationalregnskab 1988-1996
.
Jensen, E. (1996)
Brug af Input-Output tabeller på busi2 i Fib. 4, AUC nye brugere kan
starte her
, a short user guide (in Danish) to be downloaded from
http://www.business.auc.dk/ike/ike-attach/io-doku.pdf.
Thage, B. (1986),
Commodity flow system and construction of input-output tables in
Denmark
, Statistics Denmark, Working paper no. 15.
17.
List of attachments
Documentation Input-output tables 1988-1992, SNA93
Documentation Input-output tables 1988-1992, ISIC1968
Documentation
Input-output tables 1988-1992
SNA93
July 1998
5
After the United Nations in 1993 agreed upon SNA93 (System of National Accounts 1993) a
major revision of the Danish system of classification was initiated. The SNA93 is based on
NACE Rev. 1.
From 1993 an onwards the Danish system of national accounts applies the new
classifications, but also the national accounts for the years 1988 to 1992 are reclassified
according to the SNA93.
1The tables described in the present paper are the result of the
reclassification of the Danish input-output tables covering this period.
All matrices are available in both current and fixed prices. The labels of matrices in fixed
prices all start with an “f”, i.e. the matrix for final demand has the label “e” in current prices
and “fe” in fixed prices. 1990 is the base year.
At Department of Business Studies, Aalborg University, the matrices are placed at
\\busi1\database\dkio_newag
in SAS-IML format. The data set contains of one file for each
matrix-type, and each file contains 5 (current prices) or 4 (fixed prices) matrices.
In the following pages an overview of the new matrices is given, including references to the
“old” matrices (ISIC 1968-matrices), as well as a list of the new classification categories. A
programme for reading the data from SAS-IML is also included.
1 The matrices for the years 1966-1992 classified according to ISIC 1968 are documented in a separate paper. It should be noted that these matrices are organised and named in a significantly different way than the new SNA93 matrices.
6
Overview of mat
rices (
new aggregat
ion,
as from 1988)
E
m
p
loym
en
t m
a
tri
ces:
File nam e Matrix nam e Co ntent D im ensio n BES K Bes k 88-bes k 92 Em pl oy m en t m at ri ces , S el f-em p lo y ed, w ag e earn ers di st ri bu te d t o 130 i n du st ri es 2x 130Input
-o
ut
put
t
a
ble
s
Cu
rren
t p
ri
ces:
File nam e Matrix nam e Co ntent D im ensio n Ref erence to “ o ld ” tab les DZ B D zb88-dzb92 In du st ry x i n du st ry , DK cu rren t pri ces 130x 130 ~IO1 DZ C d zc88-dzc92 in d u st ry x con su m er produ ct s (C P) cu rren t pri ces 130x 73 ~IO2 DZ E d ze88-dze92 in d u st ry x f in al dem an d cu rren t pri ces 130x 25 ~IO3 DMB D m b88-dm b92 im port di st ri bu te d by i n du st ri es cu rren t pri ces 130x 130 ~IO4 DMC D m c88-dm c92 im port di st ri bu te d by con su m er produ ct s cu rren t pri ces 130x 73 ~IO5 DME D m e88-dm e92 im port di st ri bu te d by f in al dem an d cu rren t pri ces 130x 25 ~IO6 IVI iv i88-iv i9 2 In p u t of i m port s n o t di st ri bu te d by i n du st ry cu rren t pri ces 5x 130 ~IO7 IVC iv c88-iv c92 P ri v at e con su m pt io n of i m port s n o t di st ri bu te d by i n du st ry cu rren t pri ces 5x 73 ~IO8 IVE Iv e88-iv e92 M ai n cat eg ori es of f in al dem an d of i m port s n o t di st ri bu te d by ind u stry cu rren t pri ces 5x 25 ~IO9 YI y i88-y i92 In pu t of pri m ary f act ors cu rren t pri ces 5x 130 ~IO10 YC y c88-y c92 Pri v at e con su m pt io n of pri m ary f act ors cu rren t pri ces 5x 73 ~IO11 YE y e88-y e92 Mai n cat eg ori es of f in al dem an d of pri m ary f act ors cu rren t pri ces 5x 25 ~IO12 G g 88-g 9 2 P rodu ct io n , t o ta l (1000 Kr.) cu rren t pri ces 1x 130 ~IO13 C c88-c92 C on su m er produ ct s, t o ta l cu rren t pri ces 1x 73 ~IO14 E e88-e92 F in al dem an d , t o ta l cu rren t pri ces 1x 25 ~IO15 DC B D cb88-dcb92 Im port t ax , i n du st ry cu rren t pri ces 130x 130 DC C D cc88-dcc92 Im port t ax , con su m er produ ct s cu rren t pri ces 130x 73 DC E D ce88-dce92 Im port t ax , f in al dem an d cu rren t pri ces 130x 257
Fixed prices:
File name Matrix name Content Dimension Reference to “old” tables
FDZB Fdzb88, fdzb89, fdzb91, fdzb92 Industry x industry, DK 1990-prices 130x130 ~IO1 FDZC Fdzc88, fdzc89, fdzc91, fdzc92 Industry x consumer products (CP) 1990-prices 130x73 ~IO2 FDZE Fdze88, fdze89, fdze91, fdze92 Industry x final demand 1990-prices 130x25 ~IO3 FDMB Fdmb88, fdmb89, fdmb91, fdmb92 import distributed by industries 1990-prices 130x130 ~IO4 FDMC Fdmc88, fdmc89, fdmc91, fdmc92 import distributed by consumer products 1990-prices 130x73 ~IO5 FDME Fdme88, fdme89, fdme91, fdme92 import distributed by final demand 1990-prices 130x25 ~IO6 FIVI fivi88, fivi89, fivi91, fivi92 Input of imports not distributed by industry 1990-prices 5x130 ~IO7 FIVC fivc88, fivc89, fivc91, fivc92 Private consumption of imports not distributed by
industry
1990-prices 5x73 ~IO8
FIVE five88, five89, five 91, five92 Main categories of final demand of imports not distributed by industry
1990-prices 5x25 ~IO9
FYI fyi88, fyi89, fyi91, fyi92 Input of primary factors 1990-prices 5x130 ~IO10 FYC fyc88, fyc89, fyc91, fyc92 Private consumption of primary factors 1990-prices 5x73 ~IO11 FYE fye88, fye89, fye91, fye92 Main categories of final demand of primary factors 1990-prices 5x25 ~IO12
FG fg88, fg89, fg91, fg92 Production, total (1000 Kr.) 1990-prices 1x130 ~IO13
FC Fc88,fc89,fc91,fc92 Consumer products, total 1990-prices 1x73 ~IO14
FE fe88, fe89, fe91, fe92 Final demand, total 1990-prices 1x25 ~IO15
FDCB fdcb88, fdcb89, fbcb91, fdcb92 Import tax, industry 1990-prices 130x130 FDCC fdcc88, fdcc89, fdcc91, fdcc92 Import tax, consumer products 1990-prices 130x73 FDCE fdce88, fdce89, fdce91, fdce92 Import tax, final demand 1990-prices 130x25
9
130 industr
ie
s:
(f or an ov erv iew of i n du st ry codes s ee St at is tic s Denmar k, Dans k Br ancekode 1993, 2 nd edi tion 1996 ) 1 011009 A g ri cu ltu re 2 011209 Hort ic u ltu re, orch ards et c. 3 014000 A g ri cu ltu ral s erv ices , l an d scape g arden ers et c. 4 020000 F o res try 5 050000 F is h in g 6 110000 Ex tr act io n of cru d e pet rol eu m , n at u ral g as et c. 7 140009 Ex tr . of g rav el , cl ay , s ton e an d s al t et c. 8 151000 Produ ct io n et c. of m eat an d m eat produ ct s 9 152000 Produ ct io n et c. of f is h an d f is h produ ct s 10 153000 Produ ct io n et c. of f ru it an d v eg et abl es 11 154000 Man u fact u re of v eg et abl e an d an im al oi ls an d f at s 12 155000 Man u fact u re of dai ry produ ct s 13 156009 Man u fact u re of s tarch , ch ocol at e an d s u g ar produ ct s 14 158109 Man u fact u re of bread, cak es an d bi sc u its 15 158120 Bak ers ’ s h ops 16 158300 Man u fact u re of s u g ar 17 159000 Man u fact u re of bev erag es 18 160000 Man u factu re of tobacco produ cts 19 170000 Man u factu re of tex tiles an d tex tile produ cts 20 180000 Mf r. of w eari n g apparel ; dres si n g et c. of f u r 21 190000 Mf r. of l eat h er an d l eat h er produ ct s 22 200000 Mf r. of w ood an d w ood produ ct s 23 210000 Mf r. of pu lp , paper an d paper produ ct s 24 221200 Pu bl is h in g of n ew spapers 25 221309 P u blis h in g activ ities , ex cl. n ew spapers 26 222009 P rin tin g activ ities etc. 27 230000 Mf r. of ref in ed pet rol eu m produ ct s et c. 28 241109 Man u fact u re of i n du st ri al g as se s an d i n org an ic bas ic ch em ical s 29 241209 Man u fact u re of dy es , pi g m en ts an d org an ic bas ic ch em ical s 30 241500 Man u factu re of f ertilis ers etc. 31 241617 Mf r. of pl as tic s an d s y n th et ic ru bber 32 242000 Mf r. of pes tic id es an d ot h er ag ro-ch em ical produ ct s 33 243000 Mf r. of pai n ts , pri n tin g i n k an d m as tic s 34 244000 Mf r. of ph arm aceu ticals etc. 35 245070 Mf r. of det erg en ts an d ot h er ch em ical produ ct s 36 251122 Mf r. of ru bber produ ct s, pl as tic pack in g g oods et c. 37 252300 Mf r. of bu ild ers ’ w are of pl as tic 38 252400 Mf r. of ot h er pl as tic produ ct s 39 261126 Mf r. of g las s an d ceram ic g oods et c. 40 263053 Mf r. of cem en t, brick s, tiles , f lag s etc. 41 266080 Mf r. of con cret e, cem en t, as ph al t an d rock w ool produ ct s 42 271000 Mf r. of bas ic f errou s m et al s 43 272030 F irs t proces sin g of i ron an d s teel 44 274000 Mf r. of bas ic n o n -f errou s m et al s 45 275000 C as tin g of m et al produ ct s 46 281009 Mf r. con st ru ct io n m at eri al s of m et al et c. 47 286009 Mf r. of h an d t ool s, m et al pack ag in g et c. 48 291000 Mf r. of m ari n e en g in es , com p res so rs et c. 49 292000 Mf r. of ot h er g en eral pu rpos e m ach in ery 50 293000 Mf r. of ag ri cu ltu ral an d f o res try m ach in ery 51 294009 Mf r. of m ach in ery f o r i n du st ri es et c. 52 297000 Mf r. of dom es tic appl ia n ces n .e.c. 53 300000 Mf r. of of fice m ach in ery an d com p u ters10 54 310000 Mfr. of other electrical machinery and apparatus 55 320000 Mfr. of radio and communication equipment etc. 56 330000 Mfr. of medical and optical instruments etc. 57 340000 Mfr. of motor vehicles etc.
58 351000 Building and repairing of ships and boats
59 352050 Mfr. of transport equipment excl. ships, motor vehicles etc. 60 361000 Mfr. of furniture
61 362060 Mfr. of toys, gold and silver articles etc. 62 370000 Recycling of waste and scrap 63 401000 Production and distribution of electricity 64 402000 Production and distribution of gas 65 403000 Steam and hot water supply 66 410000 Collection and distribution of water 67 450001 Construction of new buildings 68 450002 Repair and maintenance of buildings 69 450003 Civil engineering
70 450004 Construction
71 501009 Sale of motor vehicles, motorcycles etc. 72 502000 Maintenance and repair of motor vehicles 73 505000 Service stations
74 510000 Wholesale and commissioned trade exclusive of motor vehicles 75 521090 Retail trade of food etc.
76 522990 Department stores
77 523000 Retail sale of pharmaceutical goods, cosmetic articles etc. 78 524190 Retail sale of clothing, footwear etc.
79 524490 Other retail sale, repair work 80 551009 Hotels etc.
81 553009 Restaurants etc. 82 601000 Transport via railways
83 602100 Other scheduled passenger land transport 84 602223 Taxi operation and coach services 85 602409 Freight transport by road and via pipelines 86 610000 Water transport
87 620000 Air transport
88 631130 Cargo handling, harbours etc.; travel agencies 89 634000 Activities of other transport agencies 90 640000 Post and telecommunications 91 651000 Monetary intermeidation 92 652000 Other financial intermediation 93 660102 Life insurance and pension funding 94 660300 Non-life insurance
95 670000 Activities auxiliary to financial intermediates 96 701109 Real estate agents etc.
97 702009 Dwellings
98 702040 Letting of non-residential buildings 99 710000 Renting of machinery and equipment etc.
100 721009 Computer activities exc. software consultancy and supply 101 722000 Software consultancy and supply
102 730001 Research and development (market) 103 730002 Research and development (other non-market) 104 741100 Legal activities
105 741200 Accounting, book-keeping and auditing activities 106 742009 Consulting engineers, architects etc.
107 744000 Advertising 108 747000 Industrial cleaning 109 748009 Other business activities
110 751100 General (overall) public service activities
11 111 751209 Regulation of public service activities exc. for business
112 751300 Regulation of and contribution to more efficient operation of business 113 752000 Provision of services to the community
114 801000 Primary education 115 802000 Secondary education 116 803000 Higher education
117 804001 Adult and other education (market) 118 804002 Adult and other education (other non-market) 119 851100 Hospital activities
120 851209 Medical, dental, veterinary activities etc. 121 853109 Social institutions etc. for children 122 853209 Social institutions etc. for adults 123 900010 Sewage removal and disposal 124 900020 Refuse collection and sanitation 125 900030 Refuse dumps and refuse disposal plants 126 910000 Activities of membership organisations n.e.c. 127 920001 Recreational, cultural, sporting activities (market) 128 920002 Recreational, cultural, sporting activities (other non-market) 129 930009 Other service activities n.e.c.
130 950000 Private households with employed persons
73 consumer products:
1 1110 Bread and cereals 2 1120 Meat
3 1130 Fish 4 1141 Eggs
5 1142 Milk, cream, yoghurt etc. 6 1143 Cheese
7 1150 Butter, oils and fats
8 1160 Fruit and vegetables except potatoes 9 1171 Potatoes etc.
10 1181 Sugar
11 1182 Ice cream, chocolate and confectionery 12 1190 Food products n.e.c.
13 1210 Coffee, tea and cocoa
14 1220 Mineral waters, soft drinks and juices 15 2110 Wine and spirits
16 2130 Beer 17 2210 Tobacco
18 3110 Garments and clothing materials etc. 19 3140 Laundering, dry cleaning etc.
20 3200 Footwear
21 4100 Actual rentals for housing 22 4200 Imputed rentals for housing
23 4300 Regular maintenance and repair of the dwelling 24 4410 Refuse collection, other services n.e.c. 25 4430 Water supply and sewerage services 26 4510 Electricity
27 4520 Gas 28 4530 Liquid fuels 29 4540 Hot water, steam etc.
30 5100 Furniture, furnishings and carpets etc. 31 5200 Household textiles
32 5310 Major household appliances 33 5330 Repair of major household appliances
34 5400 Glass, tableware and household utensils 35 5500 Tools and equipment for house and garden 36 5610 Non-durable household goods
37 5620 Domestic services and home care services 38 6111 Medicine and pharmaceutical products 39 6112 Therapeutic appliances and equipment 40 6200 Out-patient services
41 6300 Hospital services 42 7100 Purchase of vehicles
43 7210 Maintenance and repair of vehicles 44 7220 Fuels and lubricants
45 7240 Other services in respect of personal transport equipment 46 7300 Transport services
47 8100 Communications
48 9110 Radio and television sets etc. 49 9120 Photographic equipment etc. 50 9130 Data processing equipment
51 9140 Recording media for pictures and sound 52 9150 Repair of a/v and data processing equipment 53 9200 Other major durables for recreation and culture 54 9300 Other recreational items and equipment 55 9400 Recreational and cultural services 56 9510 Books, newspapers and periodicals 57 9530 Stationary and drawing materials etc. 58 9600 Package holidays
59 9700 Education 60 9810 Catering
61 9820 Accomodation services 62 9911 Hairdressing salons etc.
63 9912 Appliances, articles and products for personal care 64 9921 Jewellery, clocks and watches
65 9922 Other personal effects
66 9931 Retirement homes, day care centres etc. 67 9932 Kindergartens, creches etc.
68 9940 Insurance
69 9950 Financial services n.e.c. 70 9960 Other services n.e.c.
71 9980 Consumption of non-residents on the economic territory 72 9990 Consumption of residents in the rest of the world 73 2031 Membership organisations etc.
5 categories of final demand:
1 Private consumption, total 2 Public consumption, 981 General 3 Public consumption, 982 Defence 4 Public consumption, 983 Education, research 5 Public consumption, 984 Health6 Public consumption, 985 Social 7 Public consumption, 986 Housing 8 Public consumption, 987 Recreation, culture 9 Public consumption, 988 Business
10 Public consumption, 2041 1 2041 6111 Medicine and pharmaceutical products 11 Public consumption, 2041 2 2041 6112 Therapeutic appliances and equipment 12 Public consumption, 2041 3 2041 6200 Out-patient services
13 2050+2051 Investment, machines and inventory
14 2052, Transport 15 2053, Building: Housing 16 2053, Other building 17 2053, Civil engineering works 18 2054, Livestock
19 2055, Valuables net
20 2056, Purchase and own-account software 21 2057, Entertainment, literary or artistic originals 22 2058, Mineral exploration
23 Inventories 24 Export 25 FISIM
5 categories of non-distributed foreign transactions:
1 Transactions related to oil activity in the North Sea2 Tourist revenues and -expenses, provisioning by foreign ships 3 Expenses of Danish ships in foreign ports
4 General/special trade 5 Unspecified public imports
5 categories of primary inputs (Y):
1 Commodity taxes net (excl. of VAT) 2 VAT on uses (net system) 3 Other indirect taxes net 4 Compensation of employees 5 Gross operating surplusHow to read the data:
As mentioned in the introduction, the matrices can be found on busi1 (\\busi1\database\dkio_newag)
in SAS-IML format. The following SAS-IML programme illustrates how data can be extracted from
the database.
%macro get(year);
/* creates a macro labelled "get" for the variable "year" */ libname io '\\busi1\database\dkio_newag';
/* creates a reference (a libname) to the physical library where the data are stored */ proc iml;
/* starts the SAS-IML module */ reset storage=io.dzb;
14
/* opens the storage dzb.sc2 (the file with the matrices of intermediate flows in current prices) */ load dzb&year;
/* reads the matrices for the years indicated in the macro - see below */ show storage;
/* shows the content of the storage io.dzb */ quit;
/* terminates the IML procedure */ %mend get;
/* terminates the macro "get" */ %get(88);
%get(92);
/* indicates which years the macro includes */
15
The diagram below illustrates how the input-output matrices for a single year are organised in the
data bank. For each year matrices are available in both current and fixed prices (1980 is base year).
The data are placed at
\\busi1\database\dkio
in SAS-IML format. The matrices in current prices are
located in the folder “iol”, while the matrices in fixed prices are located in the folder “iof” (one file
for each year). The letters “l” and “f” are also included in the names of the matrices, i.e. matrix
number 1 is labelled “io1l“ in current prices and “io1f” in fixed prices. A SAS-IML programme
illustrating how to read the data is included in the end of this document.
Organisation of the input-output matrices in the data bank
Intermediate
Consumption
Private
consump.
(subgroups)
Final
Demands
(main groups)
Dim.: 117 66 9Uses of domestic output Classified by producing Industry
117 1 2 3
Users of imports classified In groups corresponding to The output structure of Domestic
117 4 5 6
Users of imports of special
Services etc. 3 7 8 9
Primary inputs 5 10 11 12