Hi Folks, I'm new to SAS programming. I'm trying to merge two files and i'm not able to apply if the condition is Many to one. merge inputfile_1 (in=a) inputfile_2 ; by ID; if a ; --> When i use this statement, I get output like below: This just matched the first ID and not rest of the ID's present in the file1. Please help me what I'm missing. Here is my below example. inputfile_1 ID Amount Description 12345 500,000 Test 1 12345 600,000 Test 2 12345 700,000 Test 3 23456 500,000 Test 1 23456 600,000 Test 2 23456 700,000 Test 3 34567 500,000 Test 1 34567 600,000 Test 2 34567 700,000 Test 3 45678 800,000 Test 33 inputfile_2 ID Amount_new Description_new 12345 450,000 Test 4 23456 350,000 Test 5 34567 250,000 Test 6 Desired Output : ID Amount Description Amount_new Description_new 12345 500,000 Test 1 450,000 Test 4 12345 600,000 Test 2 450,000 Test 4 12345 700,000 Test 3 450,000 Test 4 23456 500,000 Test 1 350,000 Test 5 23456 600,000 Test 2 350,000 Test 5 23456 700,000 Test 3 350,000 Test 5 34567 500,000 Test 1 250,000 Test 6 34567 600,000 Test 2 250,000 Test 6 34567 700,000 Test 3 250,000 Test 6 45678 800,000 Test 33 Output I get : ID Amount Description Amount_new Description_new 12345 500,000 Test 1 450,000 Test 4 12345 600,000 Test 2 12345 700,000 Test 3 23456 500,000 Test 1 350,000 Test 5 23456 600,000 Test 2 23456 700,000 Test 3 34567 500,000 Test 1 250,000 Test 6 34567 600,000 Test 2 34567 700,000 Test 3 45678 800,000 Test 33
... View more