Question regarding data formating

Posted by stace swayne on
URL: http://spssx-discussion.165.s1.nabble.com/SPSS-Syntax-MIXED-Model-tp5713934p5714094.html

Dear list,

I have data in a DAT file that looks like this

CSC 100 $10.00 $30.00 $25.00 $10.00 $600.00 $1960.00
USS 165 $9.00 $8.00 $25.00 $16.50 $0.00 $-198.50
ITT 89 $6.00 $18.00 $40.00 $24.92 $512.64 $1012.92
MEL 165 $2.00 $39.00 $42.00 $19.80 $1923.07 $6040.80
WES 59 $4.00 $20.00 $10.00 $7.08 $217.12 $931.08

I would like line the columns of data up, but I'm not sure of an easy way to do this, I have 25,000 cases so I would prefer not to do this manually.

Thanks,

Stace