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.
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
Or simply
proc sql;
select * from table_A natural join table_B;
quit;
PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.