Hell everyone! I have a dataset on SAS with about a million option prices arranged with the following fields/columns: DATE, COMPANY, PUT/CALL, PRICE The PUT/CALL variable is an indicator variable that comes out as either PUT or CALL for each unique DATE-COMPANY combination. Example with numbers: DATE COMPANY PUT/CALL PRICE 2001/01/01 XOM PUT 10 2001/01/01 XOM CALL 12 2001/01/01 ABB PUT 11 2001/01/01 ABB CALL 13 What I need is for my table to be arranged with: DATE, COMPANY, PUT PRICE, CALL PRICE The above example with numbers, the output should be: Example with numbers: DATE COMPANY PUT PRICE CALL PRICE 2001/01/01 XOM 10 12 2001/01/01 ABB 11 13 Would someone know how I could use SAS or any other software to complete this? Any help would definitely be appreciated!
... View more