Hi there, I tried to match 2 file to generate a new file.   see below example: File 1: ID code1 code2 code3 code4 11 A_B C_D A_C B_D 12 A_A D_D A_A B_B 14 B_B C_C C_C D_D   File 2: Code Match1 Match2 code1 A B code2 D C code3 C A code4 D B   look into code1 in file1: A_B, A_A_, B_B. I want to see if it matches with Code1 in File2 variable Match2, in this case Match2 =B if code1 in file1 only match 1 letter then the result will be 1, if match 2 letter then the result will be 2, if No match then the result will be 0.   this is what I want. ID code1 Result1 code2 Result2 code3 Result3 code4 Result4 11 A_B 1 C_D 1 A_C 1 B_D 1 12 A_A 0 D_D 0 A_A 2 B_B 2 14 B_B 2 C_C 2 C_C 0 D_D 0   is there a SAS code that can run for generating the results for all variables ?   I hope it's not confusing you.  Please let me know if you need more information.   Thanks in advance!!   ... View more

Hi there,   I tried to transpose a table, see below example:   ID Age1 Age1 A 10 20 C 30 40 D 50 60 E 70 80   I want: AGE A C D E Age1 10 30 50 70 Ag2 20 40 60 80             Any help will be very appreciated.   Thanks, ... View more

Hi there,   This dataset I named it as "Matching file" ID  Age  A     B     C M1  20  10   Yes   No M2  25  12   No   Yes M3  30   5    Yes  Yes M4  40   50  Yes  Yes M5  50   25   No   No   This dataset I named it as "Searching file" ID          Age    A      B      C A100      25     10    Yes   No   -------------------matching M1 A200       25      5    Yes   Yes --------------------matching M3 A300       30     12    No   Yes ---------------------matching M2 A400       35      12   No   Yes ---------------------No matching A500       40      30   Yes  Yes ---------------------No matching A600       40      50   Yes  Yes ---------------------matching M4 A700       35      50   Yes  Yes ----------------------matching M4 A800       50      25   Yes   No ----------------------No matching   I want to search for which IDs in "Searching file" are matching with the IDs in "Matching file", the Age can be +/- 5 from the "matching file", but the variables A,B and C have to exactly the same value.   My question is: how do I code it in SAS so I can output the Matching data, as follow:   This is what I want: ID       Age   A      B      C A100   25    10    Yes   No A200   25     5     Yes   Yes A300   30     12    No   Yes A600   40     50    Yes  Yes A700   35     50    Yes  Yes   Thank you so much in advance. ... View more

Hi there,   Please see below is what I try to get: ID visit  want   01 30 0   01 34 4  = 34-30 01 39 5 = 39-34 01 45 6 =  45-39 02 35 0 = 35-35 02 40 5 = 40-35 02 42 2 = 42-40           How to code in SAS to get the value in "want"? any help will be very appriciate.   Thanks in advance! ... View more

HI there; I would like to calculate the interval between values by ID,  as following:   ID value wants   A  39 39   A  45 6  = 45-39 B 38 38   B 40 2  = 40-38 B 45 5   = 45-40 C 37 37   C 40 3  = 40-37 C 42 2  = 42-40  D 40 40     the column 'wants' is what I want to get. Hope it's not confused you.   Thanks in advace. ... View more

Hi there, I wonder if some one can help me.   see below original chart: ID A B C D E 001 1 2 1 3 2 002 2 1 2 1 1 003 1 2 1 2 1 004 1 2 0 1 1 005 1 1 2 1 2 006 2 1 1 1 2   I want to replace all the (=2) values to the variables name. see what I want: ID A B C D E 001 1 B 1 3 E 002 A 1 C 1 1 003 1 B 1 D 1 004 1 B 0 1 1 005 1 1 C 1 E 006 A 1 1 1 E   and then the final result will be: ID COMBINE 001 B,E 002 A,C 003 B,D 004 B 005 C,E 006 A,E   Thank you in advance. ... View more