Download Illustrating the process using CS-Pro

Transcript
assigned then you should change your data item to be of length 2 so that you can
assign 99 as the missing value code. The missing value code can be any non-valid
value but it is best to be consistent and use the same digit in all items. For example
use 9 for one digit numeric codes, 99 for two digit numeric codes, etc.
For items that are not coded but take real values – e.g. age, weight, area, etc. – we
suggested in Part I to use a negative value as the missing value code. As an example
the value -999.9 can be used for the item Area of Waterbody. Note this item is of
length 6 and the missing value code has used all 6 spaces but it could be less. Further
information on missing values can be found in the CS-Pro User Guide.
In CS-Pro you can additionally define a code for not applicable in the same way that
you can for missing – i.e. by using value sets. In our example questionnaire, question
3 asks:
3. Is this a PAPD site? Y/N
3.1 If yes, please state date PAPD started
Clearly the date is not applicable if the site is not a PAPD site. We can set a Not
applicable code for the sub-items of the date – day, month and year. Figure 16 shows
the value set for PAPD_DAY.
Figure 16 – Setting a code for Not Applicable
5.
Automatic Skips in Data Entry
Most data entry systems have facilities for programming automatic skips. In CS-Pro
this is done using logic code. In our example dataset, question 3.1 is only relevant if
this is a PAPD site (i.e. the answer to question 3 is Yes). Figure 17 shows the code
associated with question 3.
Figure 17 – Logic Code for an Automatic Skip
This code is executed as soon as data is entered into question 3 (PAPD). If the value
entered is 0 (a no response) then we skip to question 4 (NGO). If not applicable codes
©SSC 2009 – Illustrating the Process using CS-Pro
17