Hello,
I'm a new user of SAS. I am trying to merge two files. However the identifier variable, in my case the order numbers, appear in both files in a different manner(It is market data, bid and asks appear in one file, and the actaul transactions in another, I am trying to match these two files).I was not able to merge them using MERGE function. I was told that SQL QUERY would let me merge these two files.
If anyone would kindly help me, I could send a part of the data.
Thanks in advance,
Ulaso.
I'm a new user of SAS. I am trying to merge two files. However the identifier variable, in my case the order numbers, appear in both files in a different manner(It is market data, bid and asks appear in one file, and the actaul transactions in another, I am trying to match these two files).I was not able to merge them using MERGE function. I was told that SQL QUERY would let me merge these two files.
If anyone would kindly help me, I could send a part of the data.
Thanks in advance,
Ulaso.