Search results for query: *

Hello, I am importing a csv file to sas. I have order numbers as identifiers,they are 15-16 digits.they appear in the scientific format in the original final. The order numbers are unique for each transaction.However, after importing and formating I am not able to get unique numbers.Below small...

Hello again, I got the merged file. The problem now is there are repeating rows in the merged file; the order file has 2252 rows, and transaction file has 1011 rows, however merged file has over 1800 rows. Do you have any suggestions to fix this? Thank you,

I fixed the problem, it was because of different formats I used in order numbers. After aligning that, I have a clean 1813 row table. Thanks again for your help.

Hi, codes you submitted worked as a format.Thank you for that. However, although I have 2252 rows in order file and 1011 rows in the transaction, in the merged file I ended up with more than 33 million rows. I will try to figure out the reason.Thanks again for your help.

Hello, Thanks for the respond. I'm attaching a sample of both files. The "Order" includes all the incoming orders for the security. The "Transaction" file includes the actual transactions. The identifier in the order file is order_no (it icludes all buyers and sellers), in the transaction file...

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...