Keywords - AskiaAnalysis Assistant

Keywords (AskiaAnalyse and AskiaVista)

When defining your tables in AskiaVista or AskiAnalyse, you can use special keywords in your table definitions to display information that is either context-specific or is only generated at the time the table is generated. When the table is executed, each keyword is replaced with its corresponding value.

For example, to show the number of interviews in the table, the keyword for base can be added to the table caption as follows:

Table Base: ??B??

When the table is generated table, the caption would appear thus, for a dataset containing 950 interviews:

Table Base: 950.

However, if a further 12 interviews are added to the dataset and the table is re-run, the caption will be generated again showing the latest information, and would show:

Table Base: 962.

List of keywords

Popular keywords

Below are the most popular keywords available in AskiaAnalyse and AskiaVista:

??R?? Displays the title of the question found in the table's rows.

??C?? Displays the title of the question found in the table's columns.

??B?? - Display the base for the table or question.

??W?? - Display the name of the weighting scheme applied to the current table.

??U?? - Display the name of the name of the universe applied to the table.

??L?? - Displays the currently selected analysis level for the table.

??SP?? - Displays the name of the filter (knowin in askia as the sub-population).

Full list of keywords

All of the available keywords are listed below. Many of the keywords take the form of a menemonic code or abbreviation (such as "B" for Base). The column "Short for..." explains how the abbreviation has been constructed, if applicable, as an aid to remembering which keyword to apply.

KEYWORD	SHORT FOR...	DESCRIPTION
??B??	Base	The respondent base, i.e. number of interviews for the current table.
??C??	Column title	Title of the question found in the columns.
%c	Category (case sensitive)	The answer category wording.
%C	Category (in CAPS)	The answer category wording converted to upper case.
??Cont??		Displays the reference "Cont'd" (continued) when the table is split according to the page size .
??ColSig??		Returns the list of columns being compared in any significativity test being applied.
??CPN??	Column Profile Name	The name of profile found in the columns.
??CS??	Column Shortcut	The shortcut name of the question in the columns.
??D??		Returns the number of degrees of freedom (used in the khi² calculation)
??Date??		The current date, i.e. the date taken from the system date of the server used at the time the tables were executed. (See also ??Hour??)
??DateLoadSurvey??		The date of the latest survey load.
??DateLoadData??		The date of the latest data load.
DK	Don't know	The system-generated "Don't know" response for a question. DK can be used only with the following variable types: Numerical question Closed question Loops Internally it is stored as the value -999999.99. Note: DK is not generated for `open question`. However, the empty string "" provides an equivalent operator to signify no answer was given to an open (e.g. `??OpenQ1??=""`).
??ES??	Edge Shortcut	The shortcut name of the question found in the edges.
??E??	Edge	The title of the question found in the edges.
??ER??	Edge Response	The category wording of the response found in the edges.
??EPN??	Edge Profile Name	The name of the profile found in the edges.
??FilePath??		Questionnaire file access path (.qes).
??FileName??		Questionnaire name with extension "qes".
??FileTitle??		Questionnaire name without extension "qes".
??GSP??	Global Sub-Population	The name of the sub-population applied at the portfolio level.
??GSPD??	Global Sub-Population Description	The description associated with the sub-population applied at the portfolio level
??Hour??		The current time, i.e. the time taken from the system date of the server used when the tables were executed. (See also ??Date??)
??InvP??	Inverse Probability	Returns 100 probability in the displayed results of a Chi-square test.
??L??	Level	The analysis level selected for the current table.
??P??	Probability	Returns the probability of making an error from 0 to 100 in the displayed result of a Chi-square test.
??Page??		The number of the page within a section.
??Pages??		The total number of pages produced.
??R??	Row title	The title of the question found in the rows.
??RPN??	Row Profile Name	The name of profile found in the rows.
??RLC??	Row Long Caption	The long caption associated with the question found in the rows.
??RSC??	Row Short Caption	The short caption associated with the variable found in the rows variable when you are specifying general table options. It allows you to display the short caption and the long caption on the same tab. RSC can be used directly in the header/footer fields and also in the title field in the general tab of table definition.
??RS??	Row Shortcut	The shortcut name for the question found in the rows.
??RT??	Row Type	The type of the question found in the rows, which may be Numeric, Single or Multiple.
??SectionPage??		The number of pages of the table definition section.
$$Shortcut$$	Scaled value	Returns the scaled value assigned to the response item in askiadesign. It is the scaled value that is used to run numeric calculations on closed questions such as the mean, median or standard error. (See Scaled reponse items in the AskiaDesign assistant).
??SP??	Sub-Population	The name of the filter applied to the table (also referred to in askia as a sub-population).
??SPD??	Sub-Population Description	The description associated with the filter applied to the table (also referred to in askia as a sub-population).
??Table??		The number of tables (when the `break the table according to...` feature has been activated).
??U??	Universe	The name of the universe applied to the current table.
%V	Value	The value associated with the current answer category.
??Version?		The software version number of askiaanalyse currently in use. It also shows whether the 32 or 64 bit version of the application was used. E.g.: 5.4.6.0 [32 bit]
??W??	Weighting	The name of the weighting scheme applied to the current table.
??UB??	Unweighted Base	The respondent base without weighting, i.e. number of interviews for the current table without weighting
??Waves??	Waves selected	In a Surf (.qew) file, this returns the selected wave captions (comma separated) of selected waves. If all waves are selected then 'All waves' will be shown.

KEYWORD

SHORT FOR...

DESCRIPTION

??B??

Base

The respondent base, i.e. number of interviews for the current table.

??C??

Column title

Title of the question found in the columns.

Category (case sensitive)

The answer category wording.

Category (in CAPS)

The answer category wording converted to upper case.

??Cont??

Displays the reference "Cont'd" (continued) when the table is split according to the page size .

??ColSig??

Returns the list of columns being compared in any significativity test being applied.

??CPN??

Column Profile Name

The name of profile found in the columns.

??CS??

Column Shortcut

The shortcut name of the question in the columns.

??D??

Returns the number of degrees of freedom (used in the khi² calculation)

??Date??

The current date, i.e. the date taken from the system date of the server used at the time the tables were executed. (See also ??Hour??)

??DateLoadSurvey??

The date of the latest survey load.

??DateLoadData??

The date of the latest data load.

Don't know

The system-generated "Don't know" response for a question. DK can be used only with the following variable types:

Numerical question
Closed question
Loops

Internally it is stored as the value -999999.99.

Note: DK is not generated for open question. However, the empty string "" provides an equivalent operator to signify no answer was given to an open (e.g. ??OpenQ1??="").

??ES??

Edge Shortcut

The shortcut name of the question found in the edges.

??E??

Edge

The title of the question found in the edges.

??ER??

Edge Response

The category wording of the response found in the edges.

??EPN??

Edge Profile Name

The name of the profile found in the edges.

??FilePath??

Questionnaire file access path (.qes).

??FileName??

Questionnaire name with extension "qes".

??FileTitle??

Questionnaire name without extension "qes".

??GSP??

Global Sub-Population

The name of the sub-population applied at the portfolio level.

??GSPD??

Global Sub-Population Description

The description associated with the sub-population applied at the portfolio level

??Hour??

The current time, i.e. the time taken from the system date of the server used when the tables were executed. (See also ??Date??)

??InvP??

Inverse Probability

Returns 100 probability in the displayed results of a Chi-square test.

??L??

Level

The analysis level selected for the current table.

??P??

Probability

Returns the probability of making an error from 0 to 100 in the displayed result of a Chi-square test.

??Page??

The number of the page within a section.

??Pages??

The total number of pages produced.

??R??

Row title

The title of the question found in the rows.

??RPN??

Row Profile Name

The name of profile found in the rows.

??RLC??

Row Long Caption

The long caption associated with the question found in the rows.

??RSC??

Row Short Caption

The short caption associated with the variable found in the rows variable when you are specifying general table options. It allows you to display the short caption and the long caption on the same tab. RSC can be used directly in the header/footer fields and also in the title field in the general tab of table definition.

??RS??

Row Shortcut

The shortcut name for the question found in the rows.

??RT??

Row Type

The type of the question found in the rows, which may be Numeric, Single or Multiple.

??SectionPage??

The number of pages of the table definition section.

$$Shortcut$$

Scaled value

Returns the scaled value assigned to the response item in askiadesign. It is the scaled value that is used to run numeric calculations on closed questions such as the mean, median or standard error. (See Scaled reponse items in the AskiaDesign assistant).

??SP??

Sub-Population

The name of the filter applied to the table (also referred to in askia as a sub-population).

??SPD??

Sub-Population Description

The description associated with the filter applied to the table (also referred to in askia as a sub-population).

??Table??

The number of tables (when the break the table according to... feature has been activated).

??U??

Universe

The name of the universe applied to the current table.

Value

The value associated with the current answer category.

??Version?

The software version number of askiaanalyse currently in use. It also shows whether the 32 or 64 bit version of the application was used. E.g.:

5.4.6.0 [32 bit]

??W??

Weighting

The name of the weighting scheme applied to the current table.

??UB??

Unweighted Base

The respondent base without weighting, i.e. number of interviews for the current table without weighting

??Waves??

Waves selected

In a Surf (.qew) file, this returns the selected wave captions (comma separated) of selected waves. If all waves are selected then 'All waves' will be shown.