cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stevennair
‎09-01-2015
  • 4 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Combine Datasets using Inexact Character Variables in SAS

by Calcite | Level 5 in SAS Procedures
‎11-20-2013 05:40 AM
‎11-20-2013 05:40 AM
Hi Patrick, I am sorry for that since I am a newbie here. learnt something now :smileyblush: Thank you for the reply, I really appreciate it and find it VERY useful. Just to double check with you: -When you mentioned that "The Data Joining node follows the same logic than a SQL join so in order to no loose data you would need a OUTER JOIN", you are just referring that i need the data joining node to join data from 2 different files right? -If I have already standardized the company names, then I could join them even without match code OR I can join the company names by only using match code without standardization? By the way, in your opinion, do you think using SAS function (dq...) is better than Dataflux? Once again, my sincere thank you. Warm regards, Steven ... View more

Re: Combine Datasets using Inexact Character Variables in SAS

by Calcite | Level 5 in SAS Procedures
‎11-20-2013 04:12 AM
‎11-20-2013 04:12 AM
Hi Patrick, I am using SAS Dataflux. I have to agree that Dataflux is indeed a great software. However, as you mentioned, Dataflux collapses similar strings into a single matchcode which I then can use it to join my table. Not sure you are referring to Match Codes under the Entity Resolution node. If yes, then I have a question. As you will find in my attachment, the final output (All Matches and All_Non_Match) files have lesser total number of firms than my original input files (Text file input 1 and Text file input 2). In other words, if the total number of firms in original input files (Text file input 1 and Text file input 2) consist of 1000 firms, then logically, the final output (All Matches and All_Non_Match) files should also consist of 1000 right? In my case, I lost about 148 firms and upon checking manually, I realize that companies such ABC 1995, ABC 1996, ABC 1997 (which may refer to the similar or not similar companies) have been merged into one, which is ABC. Can I customize the Match Codes function so that ABC 1995, ABC 1996, ABC 1997 are considered as different companies? My sincere advance thank you. Warm regards, Steven ... View more

Re: SAS Dataflux Data Management Studio 2.4

by Calcite | Level 5 in SAS Data Management
‎11-20-2013 03:45 AM
‎11-20-2013 03:45 AM
Hi Skillman, Thanks for replying and appreciate that. Sorry for my earlier post that did not mention my intention clearly. What I really wanted was sas dataflux to do the matching in column 1 and column 2 since the company names are not standardized (for eg: ABC Ltd with ABC Limited, etc). After matching, only then copy the the matched companies to column 3. thanks. regards, steven ... View more

SAS Dataflux Data Management Studio 2.4

by Calcite | Level 5 in SAS Data Management
‎11-15-2013 08:31 AM
‎11-15-2013 08:31 AM
Dear all, I have 2 sets of data from two different sources. I would like to merge these 2 sets of data. However, the basis for merging the data is by company name. As you may know, company names are, however, not standardized (for example, ABC Ltd, ABC Limited,etc). Thus, I have used SAS Dataflux Data Management Studio 2.4 with the hope that it will assist me. Since I am new to the software, I find it hard. In fact, I have already spent few days to understand this software. Attached is a sample of my data (in excel). The first column (Comp_name) refers to company name from database 1 while the second column (Org_name) refers to company name from database 2. What I would like to have is: 1) If a company exists in both databases, then company name as per column 2 (Org_name) appears in third column. 2) If a company exists only in first database, then company name as per column 1 (Comp_name) appears in third column 3)If a company exists only in second database, then company name as per column 1 (Comp_name) appears in third column. I hope any of you with good knowledge in Dataflux could assist me. My sincerest advance thank you for your time. Regards, Steven ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links