I have two datasets.I have to create an output dataset from these two with the condition that var2 of dataset1 should match the var2 of dataset2. Only concern is Var2 is $9 here and $32 in the second dataset.
Example:
var1 var2($9)
-----------------------
1 0000283
2 731823
3 1073388
4 12
varX var2($32)
-----------------------
1 000002837
2 000731828
3 001073388
4 000161499
How to get the result as :
var1 varx
==========
3 3
I tried left, trim, input and put fuctions but i am getting absurd results. Thats becaue when I convert the character to numeric for comparasion purpose, the values wiht more than 8 characters are trimmed and so wrong matching ouptut is generate. Is there any way I can compare this two variable.
Note : Size of both vairbles are $9 and $32 and the values in this are starting from 1 character to any.
Thanks for your help...
... View more