PROC DATASOURCE: OECD Data Files :: SAS/ETS(R) 9.22 User's Guide

The DATASOURCE Procedure

OECD Data Files

The Organization for Economic Cooperation and Development compiles and distributes statistical data, including National Accounts and Main Economic Indicators.

FILETYPE=OECDANA–Annual National Accounts

The ANA data files contain both main national aggregates accounts (Volume I) and detailed tables for each OECD Member country (Volume II).

Table 11.31 FILETYPE=OECDANA–Annual National Accounts Format
Metadata Field Types	Metadata Fields	Metadata Labels
Data Files	Database is stored on a single file.
INTERVAL=	YEAR (default), SEMIYR1.6, QUARTER, MONTH, WEEK, WEEKDAY
BY Variables	PREFIX	Table number prefix (character)
	CNTRYZ	Country Code (character)
Series Variables	Series variable names are the same as the mnemonic name of the element given on the element ’E’ record. They are taken from the 12 byte time series ’T’ record time series indicative.
Series Renamed	OLDNAME	NEWNAME
	p0discgdpe	p0digdpe
	doll2gdpe	dol2gdpe
	doll3gdpe	dol3gdpe
	doll1gdpe	dol1gdpe
	ppp1gdpd	pp1gdpd
	ppp1gdpd1	pp1gdpd1
	p0itxgdpc	p0itgdpc
	p0itxgdps	p0itgdps
	p0subgdpc	p0sugdpc
	p0subgdps	p0sugdps
	p0cfcgdpc	p0cfgdpc
	p0cfgddps	p0cfgdps
	p0discgdpc	p0dicgdc
	p0discgdps	p0dicgds
Missing Codes	A data value of * is interpreted as MISSING.

FILETYPE=OECDQNA–Quarterly National Accounts

The QNA file contains the main aggregates of quarterly national accounts for 16 OECD Member Countries and on a selected number of aggregates for 4 groups of member countries: OECD-Total, OECD-Europe, EEC, and the 7 major countries.

Table 11.32 FILETYPE=OECDQNA–Quarterly National Accounts Format
Metadata Field Types	Metadata Fields	Metadata Labels
Data Files	Database is stored on a single file.
INTERVAL=	QUARTER(default),YEAR
BY Variables	COUNTRY	Country Code (character)
	SEASON	Seasonality
		S=seasonally adjusted
		0=raw data, not seasonally adjusted
	PRICETAG	Prices
		C=data at current prices
		R,L,M=data at constant prices
		P,K,J,V=implicit price index or volume index
Series Variables	Subject code used to distinguish series within countries. Series variables are prefixed by _ for data, C for control codes, and D for relative date.
Default DROP List	By default all the control codes and relative dates will be dropped.
Missing Codes	A data value of + or - is interpreted as MISSING.

FILETYPE=OECDMEI–Main Economic Indicators

The MEI file contains all series found in Parts 1 and 2 of the publication Main Economic Indicators.

Table 11.33 FILETYPE=OECDMEI–Main Economic Indicators Format
Metadata Field Types	Metadata Fields	Metadata Labels
Data Files	Database is stored on a single file.
INTERVAL=	YEAR(default),QUARTER,MONTH
BY Variables	COUNTRY	Country Code (character)
	CURRENCY	Unit of expression of the series.
	ADJUST	Adjustment
		0,H,S,A,L=no adjustment
		1,I=calendar or working day adjusted
		2,B,J,M=seasonally adjusted by National Authorities
		3,K,D=seasonally adjusted by OECD
Series Variables	Series variables are prefixed by _ for data, C for control codes, and D for relative date in weeks since last updated.
Default DROP List	By default, all the control codes and relative dates will be dropped.
Missing Codes	A data value of + or - is interpreted as MISSING.

Top of Page