SAS Many to many merge match

factorhedge — Thu, 09 May 2013 01:13:52 GMT

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

CodeId	Date	AUM
10326	200001	200
10326	200001	200
10345	200003	340
....	200204	...
....	200512	...
10328	201012	...

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)

CodeId	Date
10326	200001
10348	200312
10356	200902

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.

Output table

CodeID	Date	AUM
10326	200001	Value for 10326 and 200001 date from Table A
10348	200312

I have tried proc sql using where but didnt work for me , could someone please help me.

Re: SAS Many to many merge match

allurai0412 — Thu, 09 May 2013 05:31:11 GMT

hi,

check this....if really want unique 'Codeid'

proc sql;

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 ;

run;

Regards

Allu

Re: SAS Many to many merge match

PGStats — Thu, 09 May 2013 14:16:52 GMT

Or simply

proc sql;

select * from table_A natural join table_B;

quit;

topic SAS Many to many merge match in SAS Procedures

SAS Many to many merge match

10345

Re: SAS Many to many merge match

Re: SAS Many to many merge match