Keywords with texts (256 or longer) - PC-Axis

På scb.se använder vi kakor (cookies) för att webbplatsen ska fungera på ett bra sätt för dig. Genom att surfa vidare godkänner du att vi använder kakor. Vad är kakor?

Keywords with texts (256 or longer)

The following texts can be maximum 256 characters.

CODES

The key word CODES is used if a variable exists both in code and plain text. The codes are written in the same way as VALUES. CODES("variable")="code1","code2",..... ; It can be devided into several lines after a comma.

CONTENTS

Information about the contents, which makes up the first part of a table heading created when retrieving tables from PC-AXIS.

CONTVARIABLE

This is used to indicate that the table has two or more different contents. For instance the contents Import and the contents Export. The variable name must also be found either as STUB or HEADING. When a contvariable exists a number of keywords will be indexed: DAYADJ, SEASADJ, STOCKFA, UNITS, CONTACT, LASTUPDATED, REFPERIOD, BASEPERIOD, CFPRICES. The keyword CONTVARIABLE must preceed the first keyword that will be indexed.

CREATION-DATE

Date when file was created. Written in format CCYYMMDD hh:mm, e.g. "19960612 14:20". Is shown together with footnotes.

DIRECTORY-PATH

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in other interfaces.

DOMAIN

Can occur once for each variable. Is used to determine which value sets are of interest, and thus which aggregation lists can be used.
Written as DOMAIN("variable")="domainname";

ELIMINATION

States if and how a variable may be eliminated in a table. If the key word is written as ELIMINATION("variable name")="value name" this value will be used as an elimination value if the user does not select the variable to the table. If the key word is written ELIMINATION("variable name")=YES this means that the variable will be eliminated by the summing up of all the values for that variable in the file.

HEADING

At least one of the keywords STUB or HEADING must be included. Usually both are included, as you choose one or several variables for the stub and the heading, respectively. The keywords are followed by a list with the chosen variables. The variables are within quotation marks and separated by commas. Each variable name can be up to 256 characters. If the list with the variables has to be divided up into several lines, this should be done after a comma and not within the variable name.

HIERARCHIES

Written as: HIERARCHIES("Country")="parent","parent":"child",...
Example: HIERARCHIES("Country")="E25","E25":"E15", "E15":"E12", "E12":"AT","E12":"BE","E12":"FI", "E12":"FR","E122:"DE", "E12":"GR","E12":"IR","E12":"IT", "E12":"LU","E12":"NL", "E12":"PT","“E12":"ES"”,"E15":"DK", "E15":"SW","E15":"UK", "E25":"E10","E10":"CY", "E10":"CZ","E10":"EE","E10":"HU", "E10":"LV","E10":"LT", "E10":"MT","E10":"PL","E10":"SK", "E10":"SI";

HIERARCHYNAMES

To give names to the levels in a symmetrical tree.
Written as: HIERARCHYNAMES("Country")="NameOfLevel1","NameOfLevel2",..

LAST-UPDATED

Date and time for latest update format CCYYMMDD hh:mm. Example "19960528 11:35". Is also used in Aremos file format. The date is not updated in PC-AXIS when changes are made to the table.
If there is a contents variable it is written as LAST-UPDATED("value")="19990318 18:12";

LINK

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in other interfaces.

MAP

Used for a geographic variable for which maps can be made.
Example: MAP("region")="Sweden_municipality";

NEXT-UPDATE

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in other interfaces.

PARTITIONED

This is used to partition a variable into levels, for instance
PARTITIONED("region")="municipality",1,4;
PARTITIONED("region")="subarea",5;
states that the first four positions for the regional values contain the municipality code, and that the subarea code starts in position 5. Thus the values for the variable region after the key word VALUES must be written in code, not plain text. Max 3 levels can be used, each gives start position and length except for the last level where length is implied as rest of the code.

PX-SERVER

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in other interfaces.

STUB

At least one of the keywords STUB or HEADING must be included. Usually both are included, as you choose one or several variables for the stub and the heading, respectively. The keywords are followed by a list with the chosen variables. The variables are within quotation marks and separated by commas. Each variable name can be up to 256 characters. If the list with the variables has to be divided up into several lines, this should be done after a comma and not within the variable name.

SUBJECT-AREA

The name of the subject area in plain text, as shown in the menu "Select subject area".

SURVEY

This keyword is read and saved in the PX-file but not shown in PC-axis. It is shown in PX-Web on the information page if the installation uses that parameter option.

SYNONYMS

This is used for search in PX-Web. If the table concerns CPI the synonym can be "Inflation". Several words can be included within " " and the total line can be max 256 chars.

TABLEID

A text that is the identity of the table.

TIMEVAL

New keyword in version 1.5 to enable the use of time series. After the keyword is the name of the time variable given, e.g. TIMEVAL(”time”). TLIST gives information on timescale and timeperiods. The time periods must be consecutive.
If the table contains the time periods 1994, 1995, 1996 TIMEVAL can be written in this way:
Alt 1. TIMEVAL("time")=TLIST(A1, "1994"-"1996");
Alt 2. TIMEVAL("time")=TLIST(A1), "1994", "1995","1996";
The following formats are used:

A1 for annual statistics written as CCYY (C for century, Y for year)
H1 for halfyear in format CCYYH, where H is 1 or 2
Q1 for quarterly data written CCYYQ, where Q is 1 - 4.
M1 for monthly statistics written CCYYMM
W1 for weekly data written CCYYWW
TIMEVAL is used in PC-AXIS version 1.7 when converting to Aremos and Gesmes/Ecoser format. It is also used for start and stop time in list of contents in HTML-format.
The variable time can be used both after the keyword VALUES and after TIMEVAL. If both exist TIMEVAL must be placed after VALUES. If only TIMEVAL exists VALUES for time are created as follows: Time scale time periods shown as
A1 1995, 1996, 1997
H1 1995H1, 1995H2, 1996H1
Q1 1995Q1, 1995Q2, 1995Q3
M1 1995M01, 1995M02, 1995M03
W1 1995W01, 1995W02, 1005W03

UPDATE-FREQUENCY

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in other interfaces.

UNITS

Information aboput the unit for the datacells, UNITS="kg";
When there is a CONTVARIABLE the keyword UNITS takes an index and is repeated for every value for the contents variable. UNITS("value")="tons".

VALUES

The key word VALUES occurs once for each variable in the table, and is followed by the variable name in parentheses, within quotation marks. The values will be in the same order as in the stub and heading, respectively. They are within quotation marks and separated by commas. Each value name must not exceed 256 characters (before 2002 only 100 chars). If the values has to be divided up into several lines, this should be done after a comma and not within the value name. See also the key word TIMEVAL below.

VARIABLE-TYPE

This keyword is read and saved in the PX-file but not shown in PC-Axis. Can be used in other interfaces.