https://communities.sas.com/t5/SAS-Enterprise-Guide/Questions-on-SAS-Data-Quality-Solution/m-p/21023#M3448 Hi, I am currently working on a research project. What we need to do is to identify firms with different historical or recored companies and then classify them as unique companies. <BR /> For example, suppose we have some observations as follows:<BR /> obs Company_name<BR /> 1 the SAS Ltd. Co.<BR /> 2 SAS Limited Co.<BR /> 3 the SAS Limited<BR /> 4 Company of SAS<BR /> <BR /> We wish to find some tools that can be used to identify record 1, 2, 3, 4 as records for an unique company "SAS". As our dataset is very large with more than 10,000 observations which are all organization and company names, manual classification seems to be very time-consuming. <BR /> <BR /> Thus, could any of you guys know whether the Data Quality Solution in SAS can help me to resolve this problem? <BR /> <BR /> Appreciate your helps! Sun, 25 May 2008 16:45:57 GMT deleted_user 2008-05-25T16:45:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Questions-on-SAS-Data-Quality-Solution/m-p/21023#M3448 Hi, I am currently working on a research project. What we need to do is to identify firms with different historical or recored companies and then classify them as unique companies. <BR /> For example, suppose we have some observations as follows:<BR /> obs Company_name<BR /> 1 the SAS Ltd. Co.<BR /> 2 SAS Limited Co.<BR /> 3 the SAS Limited<BR /> 4 Company of SAS<BR /> <BR /> We wish to find some tools that can be used to identify record 1, 2, 3, 4 as records for an unique company "SAS". As our dataset is very large with more than 10,000 observations which are all organization and company names, manual classification seems to be very time-consuming. <BR /> <BR /> Thus, could any of you guys know whether the Data Quality Solution in SAS can help me to resolve this problem? <BR /> <BR /> Appreciate your helps! Sun, 25 May 2008 16:45:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Questions-on-SAS-Data-Quality-Solution/m-p/21023#M3448 deleted_user 2008-05-25T16:45:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Questions-on-SAS-Data-Quality-Solution/m-p/21024#M3449 I have seen a couple of presentations on DQS and its capabilities, and from what I have seen this is a good example of what it can do.<BR /> <BR /> For some more detailed examples on how it is used, and the sort of configuration required to match these records as belonging to one entity see the following presentation delivered at the SAS Aust and NZ user group (2007 Q4)<BR /> <BR /> <A href="http://sausag.sasusers.net/presentations/0711Update_on_SAS_Data_Quality.zip" target="_blank">http://sausag.sasusers.net/presentations/0711Update_on_SAS_Data_Quality.zip</A><BR /> <BR /> cheers Mon, 26 May 2008 07:04:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Questions-on-SAS-Data-Quality-Solution/m-p/21024#M3449 deleted_user 2008-05-26T07:04:27Z