我正在尝试合并2个具有公共标识符investigation_id的数据集。前两个步骤用于将数字格式应用于ID,因为它有时会导入为字符。下面是我目前使用的代码: set data1(rename=(investigation_id=new_id)); drop new_id;data data2 ;
set data2 (rename=(investigation_id=new_i
SELECTcount (*)from NamrsFrozen2017.Investigation2017 where FiscalYear = 2017 AND StateName[Investigation2017] WHERE (not ReportDate = '' ))[Report Date Records],
count (*) from NamrsFrozen2017.Investigation2017 WHERE FiscalYear = 2017 AND ReportD