Hello,   I have dataset A(around 180 variables) with a list of variables that needs to be flagged in another data set B(a huge dataset with millions of records). Dataset A       data set B A                                A                 B                      C                                 D C                               10                20                   30                                40 D I needed something like : dataset needed: dataset c A            C          D 10          30          40   Thank you for all your help and guidance!       ... View more

Hello,   I am trying to extract multiple substrings from a string. For example, I have a variable called Itinerary =  Orlando, United States (North America) Start Date: 03/30/2020 - End Date: 04/01/2020|Fort Pierce, United States (North America) Start Date: 04/01/2020 - End Date: 04/07/2020|Fort Lauderdale, United States (North America) Start Date: 04/07/2020 - End Date: 04/07/2020  I would like to pull the substrings which are before and after the special character comma (,) So I would like to have a variable " location" which has Orlando, Unitedstates Fort Pierce, United States Fort Lauderdale, United States. I have tried using Scan function but am able to pull just Orlando, United states but no the rest of the locations.   Any help would be highly appreciated.   Thanks.   ... View more

Hello,   I have two variables BEGIN and END in a dataset A, and Dataset B has a variable called DIAGNOSIS CODE. I would like to see if any value in the diagnosis code variable falls in the range between Begin and End variable.   Example:    Dataset A(Have)                                                           Dataset B(Have)                                              Dataset C(want)   Begin                  End                                                 Diagnosis code                                                       Flag 1                            3                                                          5                                                                        2                    7                           10                                                        2                                                                        17 16                          24                                                        11                                                                                           17 Thanks for all your help! ... View more

Hi,   I am struggling to combine datasets with unequal observations in SAS and no common variables between them. Example: I have a dataset A  and Dataset B and will be needing data set c which should look something like follows. Is there any  I could do this? When there are no common variables in dataset A and B and not having equal observations in those datasets.    Data set A:                                             Dataset  B                                    Dataset C ID NAME CODE                           begin            end                           ID             Name            Code           begin          end 1    X          123                               120               130                           1                x                   123              120           30 2    Y           125                               500               600                          2                y                   125              500           600 3    Z           567                                                                                    3                z                    567             120            30 4    A           783                                                                                    4               A                    783             500            600   Thanks very much! ... View more