Thank you Jim for your prompt support and guidance. ... View more

Hey Jim, thank you for being so supportive. I have splitted the datasets into chunks of maximum 2-5k observations each, still SAS takes minimum 15 mins to process these observations. I have tried this code on three different datasets but unfortunately the required results are not generated. For example, I get two columns from the biography dataset (city code & biography) and the third matching column (employement status) which is found empty, as there is no match. If you can try to look the issues, should I share my data?  ... View more

Thank you for your support. I run the code and it did not show any error in the log nor it generated any result. It would be two hours that it is still processing it. I have two datasets with 1.6 million and 100k observations each. Is not any optimize solution? ... View more

    Thank you again for your prompt support. I am using SAS 9.4 but unfortunately, the code is still not working on it. It looks like I am commmitting any mistake  but whta is that I dont know. Please see the following log as reference. 1 DATA Matched_Employment_Status; 2 DROP _:; 3 DROP City_Cd; 4 DROP Name; 5 DROP Status; 6 DROP Name_Cnt; WARNING: Apparent symbolic reference REC_CNT not resolved. WARNING: Apparent symbolic reference MAX_NAMES not resolved. 7 %PUT NOTE: &=Rec_Cnt &=Max_Names; NOTE: Rec_Cnt Max_Names WARNING: Apparent symbolic reference REC_CNT not resolved. WARNING: Apparent symbolic reference MAX_NAMES not resolved. 8 ARRAY Names [&Rec_Cnt, &Max_Names] $32 _TEMPORARY_; - 22 76 ERROR 22-322: Syntax error, expecting one of the following: an integer constant, *. ERROR 76-322: Syntax error, statement will be ignored.     ... View more

Thank you for guiding. The code works for the variables you have created but unfortunately I am stuck in creation of temporary arrays for the solution of my dataset. I find the following message in the log. ARRAY Names [&Rec_Cnt, &Max_Names] $32 _TEMPORARY_;                            -                                  22                                  76 ERROR 22-322: Syntax error, expecting one of the following: an integer constant, *. ERROR 76-322: Syntax error, statement will be ignored. ... View more

Hello Experts, I would be grateful if anyone can help me solving this issue. I have the following two datasets. In DATASET-I, I have two variables, one is City Codes (ED=Edmonton, TO= Toronto and CA= Calgary) and the second is Biography of different persons. In DATASET-II, I have three variables, one is City Code (same as dataset-I), second is the Names and third is their respective Status.                             DATASET-I                                                                          DATASET-II Code              Biography                                                 Code           Names                      Status ED       Mr. Joseph Andrew is hardworking person.        ED          Blanc Angela                Teacher ED       Ms. Angela Blanc is genius.                                ED          Albert Crew                  Doctor ED       Mrs. Sarah Greene was absent.                         ED          Joseph T. Andrew         Lawyer ED       Mr. Rubin D. Elvin cleans the room.                    TO          Luis V. Bob                   Doctor TO       Ms. Luis Fernandez is a teacher.                        TO          J. Antonio                     Teacher TO       Mr. Jose Antonio works from home.                    CA          Accent Andiron             Worker TO       Mr. Luis Van Bob comes late.                              CA         Maria Jose Antonio       Student CA       Ms. Maria Jose travelled last week.                                       CA       Mr. Philip Bursa will help you.                                                  What I want? First. I want to compare the names available inDATASET-II with the names available in Biography of DATASET-I and identify the city-wise names those sound similar or common in both Datasets. The unmatched names will be skipped. Second, I want to extract those city wise common names and assign their respective status, e.g., the output can be as:                                                 DATAOUTPUT                Code                     Common Names                              Status                 ED                        Joseph T. Andrew                            Lawyer                 ED                        Angela Blank                                   Teacher                 TO                        Luis Van Bob                                   Doctor                 TO                        Jose Antonio                                   Teacher                 CA                        Maria Jose Antonio                         Studnet   Can anyone guide me how to code it in SAS please?   ... View more

I want to code the employment status variable. For this, I have details of several persons having unknown employment status and names of some individual with their known employment status. I want to identify the common names and assign their respective employment status. It is like I have details of a person in Bio column, that name can or cannot be found in Names column. However, if it is found then I can say for country AB, the Joseph T. Andrew would be working as Lawyer. ... View more