Hello.   I have two data files. File A contains some company names and File B is the full list of company names. The variables are following below.   File A: ID, Name File B: Name1, Name2, Name3 (3 names are for the same company but different expression. For example, Name1 = IBM and Name 2 = International Business Machines)   What I want is to search names from File A in File B. If names in File A can match one of the names in File B, then a new variable called NewName is created in File A and NewNames equals to Name1 from File B.      Can anyone tell me what code I need to use? Thanks.   For example   File A   ID        Name 01        IBM 02        Apple   File B               Name1                                                    Name 2                                       Name 3 International Business Machines                            IBM                                          IBM Corp.               Apple                                                       Apple Inc.                                     AAPL             Google LLC                                               GOOGL                                      Google           Expected File   ID            Name                      NewName (equal to Name1) 01             IBM                    International Business Machines 02             Apple                                     Apple ... View more

Hello. I have a data set with 2 variables (ID and Var1). There are some duplicates (red color in the following example) in this data sets. The left is what I have and the right one is what I want.   ID               Var1                              ID             Var1   101             aa                                101              aa 101             ab                                101              ab 101             ac                                101              ac 101             ad                                101              ad 102             ca                                102              ca 103             da                                103              da 101             aa 101             ab 101             ac 101             ad   The code I am using is  Proc sort data=have out=want nodupkey; by ID Var1; run; However, I found that only one duplicate observation was deleted and the reminaing duplicates are still in the data set. Did I use the wrong code? Thanks. ... View more

Hello. I have two data sets. In the Dataset A, an ID has multiple observations. Dataset B is a list of ID that I need to delete from Dataset A. The following is an example.   Dataset A                                                          Dataset B ID              Observations                                         ID aa                     a11                                                  aa aa                     a12                                                  bb aa                     a13 bb                     b12 bb                     b22 cc                     c45 cc                     c56   I want to delete the observations which have the same ID with dataset B from Dataset A. What code do I need? Thanks. ... View more

Hello. I am running SAS in Linux system. What code do I need to see the log file? Thanks. ... View more

Hello! I have a data set with more than 500k observations. I would like to assign serial numbers (1-5000) to observations and then split the file at each 5000 point so that it can be splited into 100 files. What code do I need? Thanks. ... View more

Hello. I have 100 sas data sets (they are in the same folder) and all of them have a same variable called group. Is there any efficient way to delete this variable from all these data sets rather than deleting them one file by one file? Thanks. ... View more