Re: Question regarding data formating

Posted by David Marso on
URL: http://spssx-discussion.165.s1.nabble.com/SPSS-Syntax-MIXED-Model-tp5713934p5714098.html

Stace,
  You *should* begin a NEW topic rather than changing the subject of an existing thread.  Things in Nabble get threaded funny and many people who might answer your question won't see it because it is lost beneath a different topic.  Meanwhile, DATA LIST LIST will work (see DOLLAR format).
Regards

stace swayne wrote

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