SPSSX Discussion

Multiple people, one record

Classic

List

Threaded

5 messages Options

Graeme Fairnie

Multiple people, one record

I'm working with quite a large dataset thaat holds about 1.7m records most
of these correspond to individuals but some, using a variable labelled
multpers, refer to multiple individuals with all other variables the same,
and i was wanting to know is there any way of getting SPSS to output how
many people rather than how many records fit my specified criteria? At the
moment i'm having to output the number of records then multiply each
multpers record by its frequency which is fairly time consuming.

Many thanks

Graeme Fairnie

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Marks, Jim

Re: Multiple people, one record

If multpers contains numeric values for each case, you can weight the
file on this variable.

*** example to illustrate WEIGHT BY.

DATA LIST FREE /id multpers var1 (3F8.0).
BEGIN DATA
1 1 3
2 1 5
3 3 3
4 2 5
END DATA.

FREQ var1.
WEIGHT BY multpers.
FREQ var1.

Var1 has the following frequency:

VALUE CASES
3 2
5 2

With WEIGHT BY multpers var1 has the following:

VALUE CASES
3 4
5 3

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Graeme Fairnie
Sent: Friday, July 25, 2008 8:31 AM
To: [hidden email]
Subject: Multiple people, one record

I'm working with quite a large dataset thaat holds about 1.7m records
most
of these correspond to individuals but some, using a variable labelled
multpers, refer to multiple individuals with all other variables the
same,
and i was wanting to know is there any way of getting SPSS to output how
many people rather than how many records fit my specified criteria? At
the
moment i'm having to output the number of records then multiply each
multpers record by its frequency which is fairly time consuming.

Many thanks

Graeme Fairnie

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Albert-Jan Roskam

Re: Multiple people, one record

In reply to this post by Graeme Fairnie

Hi,

This might work:

sort cases by id multpers.
compute unique = (lag(id) ne id or $casenum = 1).
filter by unique.

Cheers!!
Albert-Jan

--- On Fri, 7/25/08, Graeme Fairnie <[hidden email]> wrote:

> From: Graeme Fairnie <[hidden email]>
> Subject: Multiple people, one record
> To: [hidden email]
> Date: Friday, July 25, 2008, 3:31 PM
> I'm working with quite a large dataset thaat holds about
> 1.7m records most
> of these correspond to individuals but some, using a
> variable labelled
> multpers, refer to multiple individuals with all other
> variables the same,
> and i was wanting to know is there any way of getting SPSS
> to output how
> many people rather than how many records fit my specified
> criteria? At the
> moment i'm having to output the number of records then
> multiply each
> multpers record by its frequency which is fairly time
> consuming.
>
>
> Many thanks
>
> Graeme Fairnie
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body
> text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the
> command
> INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Guerrero, Rodrigo

CTABLES Command

Hello everyone,

I am running tables and want to know if there is a way to set the width
of the table in the CTABLES command rather than clicking the output
table and formatting the printing option to fit the page width.

Any help is great!

Thanks.

RG

Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The
Scooter Store | 830.627.4317

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

vlad simion

Re: CTABLES Command

Hi Rodrigo,
here is the example from the help file:

CTABLES
/FORMAT MINCOLWIDTH={DEFAULT} MAXCOLWIDTH={DEFAULT}
{value
} {value }
UNITS={POINTS} EMPTY= {ZERO } MISSING= {'.' }
{INCHES} {BLANK }
{'chars'}
{CM } {'chars'}
so you can set the min and max of the column width.
hth,
Vlad

On Mon, Jul 28, 2008 at 9:56 PM, Guerrero, Rodrigo <
[hidden email]> wrote:

> Hello everyone,
>
> I am running tables and want to know if there is a way to set the width
> of the table in the CTABLES command rather than clicking the output
> table and formatting the printing option to fit the page width.
>
> Any help is great!
>
> Thanks.
>
> RG
>
> Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The
> Scooter Store | 830.627.4317
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>