FIFO Accounting in SAS

[deronwilliams]

Hello:

I would like to do FIFO (first-in-first-out) accounting in SAS. Since I have at most 4 sells and 4 buys, I can go through a decision tree for each transaction, but does anyone have any idea how to code a generic version?

FIFO Example:

http://www.bellaonline.com/articles/art51668.asp

 

[klaz2002]

why not use the datetime stamp and then use the PROC sort with either ascending or descending options. So in order to get a complete set of 'BUY' orders in FIFO order. You would sort by stock (equity) name and descending date. I would then assign a sequence number to the record for later use.

Of course you would have to work out the specifics like you only need the transactions that occured today. Or, you only want trans that are still not settled etc..

Does this help you?
Klaz