Error_Checking_Imported_Data

The SAS command file checks EPG data for errors. It will always run. However, you will only get the correct output if there are no errors. The data sets "simple psyllid" and "simple aphid" have no errors. Errorchecker will return two tables. The first is a record of the waveforms. Check to make sure that all waveforms are correct. A number of common errors will show here. PLEASE note that Np is a different waveform from NP or nP or np. Also, "NP" is different from " NP" and "NP " or " NP ". I wrote the code to be insensitive to these conditions using the condense() function to eliminate spaces and the upcase() function to make all letters capitals. However, it is safer to correct the problem rather than relying on the program. The second table is a frequency table showing all the transitions and transitional probabilities. Check to make sure that all transitions are possible. Your data is clean if you get these two tables and there are no problems evident in the tables.

SAS命令文件用于对EPG（Electrical Penetration Graph，刺吸电位图谱）数据执行错误校验操作。该程序将始终运行，但仅当输入数据无任何错误时，方可生成正确的输出结果。数据集“simple psyllid”与“simple aphid”不存在任何错误。Errorchecker将返回两张数据表：第一张为波形记录表格，请核查所有波形是否正确，此处将展示多种常见错误类型。请注意，Np、NP、nP及np属于不同的波形类型；此外，“NP”与“ NP”“NP ”“ NP ”亦存在差异。我在代码中通过condense()函数去除多余空格、upcase()函数将所有字母转换为大写，以实现对大小写及空格的不敏感处理，但相较于依赖程序自动修正，手动修正问题会更为稳妥。第二张数据表为频率统计表，用于展示所有状态转移及其转移概率，请核查所有转移是否均符合逻辑。若成功获取这两张数据表且表格内无异常，则表明你的数据已完成清洗。