How I do

[Clayton Santos Delfino]

Hi friends.

My name is Clayton, from Brazil and this is my first message.
Ohh... my english is not very good then have patience with me.

Sorry but i need you and is not because exist a problem with a program.

If you can help then thank you very much if not, thank you too. ;-)

I have a data list with 300 records, two colums locate and energy

Example

locate energy
1 900
2 203
1 300
3 12
4 232
5 304
4 400
5 677
.... ...
 
The values possibles to locate are: 1 until 5.

How i do a table like this:

Locate Sum enegy power
1 1200
2 203
3 12
4 632
5 981
               

Thank you.

Clayton





_______________________________________________
Pspp-users mailing list
Pspp-users@...
http://lists.gnu.org/mailman/listinfo/pspp-users

[John Darrington-3]

One way to do this uses the AGGREGATE command.   For example:


AGGREGATE
        OUTFILE=*
        /BREAK=locate
        /x = sum(energy).

LIST.

On Thu, Oct 29, 2009 at 04:40:11PM -0300, Clayton Santos Delfino wrote:
     
     I have a data list with 300 records, two colums locate and energy
     
     Example
     
     locate energy
     1 900
     2 203
     1 300
     3 12
     4 232
     5 304
     4 400
     5 677
     .... ...
     
     The values possibles to locate are: 1 until 5.
     
     How i do a table like this:
     
     Locate Sum enegy power
     1 1200
     2 203
     3 12
     4 632
     5 981
     

--
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://pgp.mit.edu or any PGP keyserver for public key.




_______________________________________________
Pspp-users mailing list
Pspp-users@...
http://lists.gnu.org/mailman/listinfo/pspp-users