G'day: Appreciate any  help you can give.  How do you merge the two fields and retain both IDs. Then, match based on a chosen ID between two files. This question is Not Answered. jcis7 Aug 2, 2013 7:09 PM                                Currently Being Moderated                    Hello!  Any help you can give is appreciated! I've DataFile1: ID                  Type       Address             (other fields, etc...) 12345678      B             1 Aurora Ln                             12345676      A             1 Aurora Ln                               12345677      A             30 Chester Way                  12345667      B             30 Chester Way                   12345654      A             45 Picadilly Ln 12345432      B             45 Picadilly Ln            How do you merge with the following RESULT 1 IDA                    IDB                      Address                  (other fields, etc) 12345676         12345678             1 Aurora Lane 12345677         12345667             30 Chester Way 12345654         12345432             45 Picadilly Ln I've another data file, Data File 2,  that has the ID listed for the Type B's from DataFile1 but for which I need to replace the ID listed from DataFile1 with the Type A ID.  The address for DataFile 2 may not be the same as the address for data file 1. Data File 2 also has other IDs that are correct and therefore don't need updating. Data File 2 ID                  Type       Address             (other fields, etc...) ---observations with the same ID listed in DataFile1 but may have updated information 12345678      B             1 Aurora Ln  #B                                                                      12345667      B             305 Chester Wy                   12345432      B             45 Picadilly Ln  .....more observations that don't need the ID number changed 13456787      A             300 Westinghouse 14556764      B             134 Hemingway How do you match RESULT 1 with Datafile 2 (i.e., match IDB from RESULT 1 to ID in DataFile 2) but then keep only IDA and he Updated Address from DataFile 2 to get the Final Table below Need:  Final Table ID                  Type       Address             (other fields, etc...)                        12345676      A             1 Aurora Ln #B                                12345677      A             305 Chester Way                                12345654      A             45 Picadilly Ln 13456787      A             300 Westinghouse 14556764      B             134 Hemingway Thank you! ... View more

Hello!  Any help you can give is appreciated! I've DataFile1: ID                  Type       Address             (other fields, etc...) 12345678      B             1 Aurora Ln                             12345676      A             1 Aurora Ln                               12345677      A             30 Chester Way                  12345667      B             30 Chester Wy                   12345654      A             45 Picadilly Ln 12345432      B             45 Picadilly Ln            I've another data file, Data File 2,  that has the ID listed for the Type B's from DataFile1 but for which I need to replace the ID listed from DataFile1 with the Type A ID.  The address for DataFile 2 may not be the same as the address for data file 1. Data File 2 also has other IDs that are correct and therefore don't need updating. Data File 2 ID                  Type       Address             (other fields, etc...) ---observations with the same ID listed in DataFile1 but may have updated information 12345678      B             1 Aurora Ln  #B                                                                      12345667      B             305 Chester Wy                   12345432      B             45 Picadilly Ln  .....more observations that don't need the ID number changed 13456787      A             300 Westinghouse 14556764      B             134 Hemingway Need:  Final Table ID                  Type       Address             (other fields, etc...)                        12345676      A             1 Aurora Ln #B                                12345677      A             305 Chester Way                                12345654      A             45 Picadilly Ln 13456787      A             300 Westinghouse 14556764      B             134 Hemingway Thank you! ... View more

Hello!  Any help you can give is appreciated! I've a document with: ID                  Type       Duplicate             (other fields, etc...) 12345678      B             1                               12345676      A             1                                12345677      A             3                    12345667      B             3                     12345654      A             4 12345432      B             4             How do you select for Type A of each duplicate and include all fields Final Table ID                  Type       Duplicate             (other fields, etc...)                         12345676      A             1                                 12345677      A             3                                     12345654      A             4 Thanks very much! ... View more

I'm trying to fill fields per row as missing (currently some fields have zeros) for certain rows, where rep='N'. All variables I'm replacing as missing either have a numerical value of zero or are missing. But I'm getting an error:  Array subscript out of range at line 409 column 28. data new; set old; if tot ge 10; array vars var1 var2 var3 var4 var5 var6 var7; if rep = 'N' then vars=.; run; ... View more

Hello, I want to perform the same calcluation on 10+ variable (ie., need percentage). How do I create a macro to do this?  I copied and modified code from another program so my macro knowledge is minimal as you can tell. Here's what I have: %macro table (vars=);      %local (vars);      data new;      set old;      array vars {*} &vars;      do i=dim (vars);           ??= (vars/total)*100;      *want final variable for each to be:  pct_follow, pct_nofollow, pct_med, etc); end; %mend; %table (vars=follow nofollow med vac1 vac2 vac3); Thank you!   ... View more

Hello!  The following code has an error. Can you help troubleshoot? PROC SQL; CREATE table Results AS SELECT * FROM ccall WHERE (status='Reported'  AND  enrollment NE 0) AND status='Not Reported' (WHERE code IN (SELECT number FROM DS)); QUIT; I want to retain all that've reported with nonzero enrollment and all that've not reported that have codes located in a separate table named DS.... But I'm getting an error message below. Any help you can give is much appreciated!  Thanks! __________________ LOG:  73   PROC SQL; 74 75        CREATE table Results AS 76 77        SELECT * 78 79        FROM ccall 80 81        WHERE (status='Reported'  AND  enrollment NE 0) 82 83             AND status='Not Reported' (WHERE code IN (SELECT                                                   -                                                   22                                                   76 83 ! number FROM dss)); ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <,               <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING,               INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, ORDER, OUTER, UNION, ^, ^=, |,               ||, ~, ~=. ... View more

I used the following code to rename a variable.  Why original name come up under 'Label' when using Proc Contents (i.e., variable name becomes uncon and Label is allreq. What is a label used for? data rename;      set orig;       rename  allreq=uncon; run; Thanks! ... View more

Hello, I've a two tables. I need email addresses for the IDs in table B that match table A.. However, the IDs in table B may be listed more than once because of different email addresses.  The IDs in Table A are listed only once.  And there're IDs in table B that I don't need as they've not listed in table A. Table A ID BAC IDG IWL Table B ID           email BAC       bacet@email.net BAC       bacra@email.net IDG        edna@gmail.com IWL       larry@email.net IWL       edgar@email.net EEK       lyons@eml.com EEK       reb@email.com Final Table ID           email BAC       bacet@email.net BAC       bacra@email.net IDG        edna@gmail.com IWL       larry@email.net IWL       edgar@email.net I only know how to do this if the IDs are listed once in Table B not more than once. Thanks! ... View more