| Index | Tutorial | Glossary |
The User Defined Variable box allows you to define your own variables that can be added to the Variables box and used along with the variables from the data set. The definition can include other variables, functions from the Function box, numeric and string values, logical and arithmetic operators, and parentheses. The result of the expression in the User Defined Variable box must be numeric. To add a label to the user-defined variable, enter a text of the label in the Label of User Defined Expression box.
NumericVariable1 [ArithmeticOperator NumericVariable2 ...]
Note: Square brackets in syntax diagrams denote optional elements.
| Expression | Explanation |
| c203a+c203b | The share (%) owned in company by private sector (domestic and foreign) |
| c242a1*c242b1/100 | Days spent in inspections, meetings with local tax authorities |
| c274a1y*(c211a2+c211a3)/100 | Total value of exports (direct and indirect) |
[NumericVariable ArithmeticOperator] [FunctionName(Expression)] [ArithmeticOperator...], where
| Expression | Explanation |
| DummyByCondition((industry=='Construction')&(size=='Small')) | Defines dummy variable equal to 1 for small construction firms and 0 otherwise |
| DummyByCondition((c203a+c203b)>50) | Defines dummy variable equal to 1 if a firm is more than 50% owned by private sector and 0 otherwise |
| DummyByValues(c244ba,3,4) | Defines dummy variable that equals to 1 if a firm had major or decisive influence on recently enacted national laws and regulations |
| Group(c201,1990,2000) | Defines categorical variable that equals to 1 if a firm began operations in the country before 1990, 2 if a firm began operations in the country from 1990 to 2000, and 3 if a firm began operations after 2000. |
| BandGroup(c247e,0,4,52) | Defines categorical variable that is approximately equal to the number of months (within one year) it typically takes to resolve an overdue payment (c247e is a number of weeks it takes to resolve an overdue payment). |
| log(c262a1y) | Logarithm of employment - 1 year ago |
| MeanByCategory( c274a1y, size) | Defines a variable with average sales by employment category. |