Hi,
Can someone help me to write below excel formula in SAS.
a2 has "First Number" and some other values like First, second, third, Third Number, etc.
b2 has some values like '1234' these are char format and Names a:b has '1234' and something like '1346' chat format and 2 is Yes/No
b2 has some values like '1234' these are char format and Names a:b has '1234' and something like '1346' chat format and 2 is Yes/No
c2 is also char format and a values from matching sheet will matching with c2 values and 2 is Yes/No
=if(right(a2,6)="Number","no", if(iferror(vlookup(b2,'Names'!$a:$b,2,false),"no")="yes","no", if(iferror(vlookup(b2,'Location'!$a:$b,2,false),"no")="yes","no", vlookup(c2,'Matching'!$a:$b,2,false))))
Main data
A
B
C
First
1234
1A
First Number
1348
11A
Second Number
1236
B4
Second
1345
B7
Names data
A
B
1234
No
1348
Yes
1236
Yes
1345
No
Location data
A
B
1234
No
1348
Yes
1236
Yes
1345
No
Matching data
A
B
1A
Yes
11A
No
B4
No
B7
Yes
Thanks,
vnreddy
... View more