Hi all, Thanks for taking time to help me. I have two datasets which I want to merge on people's surname. In one dataset the field contains just the surname but in the other dataset the field contains other words (potentially before or after the surname). Is there any way to join the two datasets? E.g. Surname (table 1)        Name (table 2)           Smith                        Mr.Tom Smith      I would want to join the records for this example above. I have tried using proc sql, create table ... with a where clause with the contains function but that did not work. I have SAS 9.4. Any help will be much appreciated. ... View more

Hi all, I have setup a successful connect between SAS 9.2 client (Windows) to SAS 9.4 (Linux). I have a SAS file which is stored on the Linux server which has a macro statement written in the script. I want the marco to execute in the server session. I have tried to rsubmit something similar to the following from the Windows machine. rsubmit;      FILENAME name of file 'external-file';      %INC name of file;      %macro(parameters); endrsubmit; I have typed the parameters into the %macro line in the brackets. I can not get the macro to run to the server. Does anyone have any suggestions I can explore? Also, how I do get what is shown in the server log to show in the client session? Many thanks for your help. ... View more

Hi all, I have some SAS datasets that were created on Windows operation system (Base SAS 9.2). The files have been copied to a Base SAS 9.4 running on a UNIX environment. I am trying to convert these to SPDE data sets using PROC COPY but this does not seem to work. It seems this is becuase the datasets were created in a Windows operating system. Has anyone got any advice? Many thanks ... View more