Browsing Portuguese translation

22.

(don't quote strings e.g. John not "John". Null for missing)

23.

(enter a filter e.g. agegp > 5)

24.

(filtered)

25.

(scroll down for details of all your database engines)

26.

* add, delete or rename fields,

27.

* change the data type of fields,

28.

* recode values from one field into another

29.

* rename data tables,

30.

... or add a new data table to the default SOFA database

31.

1. If you are trying to recode a range e.g. ages 1-19 into a single age group,
put 1 TO 19 in the FROM original value(s) column, not 1 in the first column and 19 in the second.

2. Ranges use the keyword TO e.g. "150 TO 250". All keywords must be upper case, so "TO" will work but "to" will not.

3. "MIN" and "MAX" can be used in ranges e.g. "MIN TO 100", or "100 TO MAX". You can even use "MIN TO MAX" if you
want to leave out missing values.

4. "REMAINING" and "MISSING" are the two remaining keywords you can use
e.g. if you want all missing values to become 99 you would have a line with From as "MISSING", and To as 99

5. Only one condition is allowed per line. So if you want to recode <=5 and 10+ to 99 you would have one line with

"MIN TO 5" as From and 99 as To

and another line with

"10 TO MAX" as From and 99 as To.