importing problem

[ssas]

Hi
I have an csv file with the following format:

Full Name Phone Event Event Date Hall Area Row Seats Price Price Level Price Types

Transaction No. Transaction Date Transaction Type User Name: Status: Number of Tickets: Total Amount

361640 12/04/2008 14:24 Phone Holland, P Sales 6 $95.00

Smith S 235977 Cinderella 2008 21/12/2008 14:00 The Central Theatre Balcony A 32-33 18.5 Band A Standard Clearing
Smith S 235977 Cinderella 2008 21/12/2008 14:00 The Central Theatre Balcony A 34-35 15.5 Band A Senior Citizen Clearing
Smith S 235977 Cinderella 2008 21/12/2008 14:00 The Central Theatre Balcony A 36-37 13.5 Band A Under 16 Clearing
Transaction No. Transaction Date Transaction Type User Name: Status: Number of Tickets: Total Amount

361678 12/04/2008 17:50 Phone Lycett, S Sales 14 $220.00


HOW can i import into sas with the following output

Full Name Phone Event Event Date Hall Area Row Seats Price Price Level Price Types Transaction No. Transaction Date Transaction Type User Name: Status: Number of Tickets: Total Amount


smith alison 23533 cinderella 12/12/2009 10.30 central theatre balcony A 13-14 10.00 bandA clearing 12132 15/05/2008 card scott paid 2 20.00

john martin 23253 cinderella 12/12/2009 13.30 central theatre balcony A 44-52 12.00 bandA clearing 12132 15/05/2008 card scott paid 8 96.00

[Doc_Duke]

sams1,

Please post your problems to just one forum. It's a problem for other users to spend time helping you and then find that someone else already did it.

Others: results are in
http://support.sas.com/forums/thread.jspa?threadID=4656&tstart=0

Doc Muhlbaier
Duke