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