Hi all,   I have been receiving this error message during the concatenation of two files which have a variable with  different data types: "Variable Level already exists on file WORK.ALL_PAYS". The outcome of the concatenation is partially OK, since there are some observations (the two ones from the file Pay 1996, variable 'Level') that should have data, but they are actually with missing values.   Below is my code:   Data Pay1995; Input ID $ 1-3 Level $ 5-7 Salary 9-14 Gender $ 16-17; Datalines; A23  32  68000  M A24  35   7500  F A30  44  97000  M A13  28  27000  F ; run; Data Pay1996; Input ID $ 1-3 Level $ 5-7 Salary 9-14 Gender $ 16-17; Datalines; A25  29  35000  F A26  36  88000  F ; run; *To concatenate the two datasets successfully, you need to change the Level variable in one of the data sets so the types match. Use either the PUT or INPUT function to modify your variable type.; Data work.pay1995;      set work.pay1995;      Level2=input(Level,4.); run; *Use appropriate DROP and RENAME statements or options to achieve this in ONE DATA step.; Data work.All_Pays  (RENAME=(LEVEL2=Level));          set   work.Pay1995 (drop =Level) work.Pay1996; run;   Please let me know how can I improve my code and fix the error(s).   Regards ... View more

Hi all,   I am new using SAS, so probably this is a simple question, but I am stuck. I need to create a subset of a file by selecting observations for a specific name that contains a specific character string, let's say 'Smith'. for example, the data is like this: data test;    input name $;    datalines; Will, Smith Diana, Ross Diane, Keaton Sally, Field Willy, Thomas David, Platt Ana, Smith ; run;   My code is like this: data test; set test;       where name contains 'Smith'; run; proc print; run;   The code works properly for names, like 'David', but I am interested in  last names, like Smith. Unfortunately it is not working for last names. Any advice is welcome.   Regards ... View more