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: 
anureddy10
‎12-16-2015
  • 5 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Cleaning data using SAS

by Fluorite | Level 6 in SAS Programming
‎12-07-2015 11:12 PM
‎12-07-2015 11:12 PM
No for this data I dont have any unique ID for the companies . It is just the company Name like apple, best buy . Whatever name the Google gives or I give the company ... View more

Re: Cleaning data using SAS

by Fluorite | Level 6 in SAS Programming
‎12-07-2015 11:09 PM
‎12-07-2015 11:09 PM
Thanks for the Suggestion. The thing is I dont have a list if data is like ( Apple, apple inc, apple company, apple store) I have to take a unique Name ie "Apple" for all this kind of Data and same goes with all the other employers which has spellings spelt wrong or company has diff or new names. So even I thought to create a Look up table . But I am kinda struck with records having two or three employers like "Apple/Best Buy/HSBC". In this case I am not sure what code I have to write to take either the first company or might be the last company .   Like in this situations if it has to consider lets suppose only first company then I am not sure how to make SAS understand that logic ? ... View more

Re: Cleaning data using SAS

by Fluorite | Level 6 in SAS Programming
‎12-07-2015 11:03 PM
‎12-07-2015 11:03 PM
Thanks for the suggestion.    I did try the same code but using Proc SQL and wrote compress(upcase(Column)).But My data is really very messy. Have all three/two employers in a single record. Not exactly sure which Employer I have to consider. It has something like   Example Apple/Best Buy HSBC/Best Buy    In this situation it is tough to analyze the data. So,I thought it might take more of excel work than SAS.  Can yu suggest me anything for this kind of messy data?? ... View more

Re: Cleaning data using SAS

by Fluorite | Level 6 in SAS Programming
‎12-07-2015 10:59 PM
‎12-07-2015 10:59 PM
Thanks for the help.  My data is really very messy. Have all three/two employers in a single record. Not exactly sure which Employer I have to consider. I tried using distinct to sort out the unique employers but that gave  half of the total rows (almost 35000 rows). I thought it might take more of excel work than SAS.  ... View more

Cleaning data using SAS

by Fluorite | Level 6 in SAS Programming
‎12-06-2015 07:35 PM
‎12-06-2015 07:35 PM
Hello Guys,  I need your help. I am new to SAS and I got a project regarding Data cleaning . My project is to check the spellings and update the unique name of all the employers of almost 75000 new hires and enter the new unique new employer data into new column(Variable in SAS) , I am right now using If else , but I need to write almost 100 If then statements.    Example - If Employer = 'Apple' OR Employer = 'Apple Inc' --- then 'Apple'  else Employer as New Employer   For this the employer distinct names are almost 25000 rows . So have no idea how many days this project might take to complete . Any ideas what will be the estimated timeline to inform to my Manager?Is there a easy method to clean the data in SAS?  SAS Pro's please help me  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-16-2015 10:43 PM
Likes given to
View All
Quick links