05-08-2013 09:13 PM
Hi I need to merge two tables (Table A , Table B ) the tables look like as illustrated below
Table A (The first column is unique ID for 400 rows, second column is YYYYMM date column goes from 200001 to 201012, third column is Value
Table B (First column has similar unique ID as table A and date in column two is YYYYMM but its random not necessarily continuous dates)
Objective : Is to merge the two sheets based on 2 variables (CodeID and Dates) . I need the output to show AUM value in Table B after matching with specific CodeID and specific date.
|10326||200001||Value for 10326 and 200001 date from Table A|
I have tried proc sql using where but didnt work for me , could someone please help me.
05-09-2013 01:31 AM
check this....if really want unique 'Codeid'
select distinct a.codeid ,a.aum, b.date from table_a a inner join table_b b
on a.codeid=b.codeid and a.date=b.date ;