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 for each variable

There is always at leas one variable in a PC-Axis file. Variables can be either in STUB or HEADING. For each variable the following information can be available:
VALUES
Mandatory for each variable. Which values exists for the variable.
VALUES("region")="Stockholm", "Vallentuna";

CODES

Which codes the existing values have.
VALUES("region")="0180", "0114";

DOMAIN

Which domain the variable belongs too. Needed only if aggregations files are used.
DOMAIN("region")="region2000";

ELIMINATION

If a variable can be eliminated.
ELIMINATION("age")="total";
ELIMINATION("sex")=YES;

DOUBLECOLUMN

If values and codes should be shown in different columns.
DOUBLECOLUMN("region")=YES;

MAP

If the table can be shown on a map.
MAP("region")="Sweden";

NOTE and NOTEX

If there are footnotes for a variable.
NOTE("region")="Text for footnote for the variable region";
NOTEX("age")="Text for mandatory footnote for the variable age";

PRESTEXT

If values or codes should be shown for a variable.
PRESTEXT("region")=1;
PRESTEXT("time")=0;

VARIABLE-TYPE

A type of variable. Options for new applications. Not used in PC-Axis or PX-Web.
VARIABLETYPE("time")=T;

HIERARCHIES

One variable in a table can be hierarchical.
HIERARCHIES("region")="SE","SE":"0180",...

HIERARCHYLEVELS

A hierarchical variable can have a number of levels.
HIERARCHYLEVELS("region")=2;

HIERARCHYLEVELSOPEN

A hierarchical variable can have a number of levels open when first shown.
HIERARCHYLEVELSOPEN("region")=0;

HIERARCHYNAMES

A hierarchical variable can have a names for the levels.
HIERARCHYNAMES("region")="The whole country","Municipalities";

KEYS. For STUB variables

If sparse data, KEYS for each variable in stub.
KEYS("region")=CODES;

PARTITIONED. For one variable

Only one PARTITIONED variable for a table.
PARTITIONED("region")="Municipality",1,4;
PARTITIONED("region")="Subarea",5;

TIMEVAL. Special for time variable.

If the table has a regular time scale information can be given in time. This makes it possible to do some extra editing and converting.
TIMEVAL("time")=TLIST(A1),"2008";
TIMEVAL("time")=TLIST(Q1),"20012","20013","20014";

PRECISION. For specific values

If there are different numbers of decimals.
PRECISION("$$SORT","Per cent")=2;

VALUENOTE and VALUENOTEX. For specific values

There can be a footnote for a specific value for a variable.
VALUENOTE("region","Stockholm")="Text for footnote regarding Stockholm";
VALUENOTEX("region","Stockholm")="Text for mandatory footnote regarding Stockholm";

CELLNOTE and CELLNOTEX. For combinations of values

There can be a footnote for a data cell or a number of datacells.
CELLNOTE("Stockholm","*","2008")="Text for cell note regarding Stockholm, all ages, 2008";
CELLNOTE("Stockholm","20","2008")="Text for mandatory cell note regarding Stockholm, 20 year old, 2008";

DATA

NOTECELL. For combinations of values

There can be a note to show together with a figure in a data cell.
DATANOTECELL("0180", "*", "2008")="Ae";
DATANOTECELL("0180", "20", "2008")="Ae";