SPSSX Discussion

Syntax assistance for long file appeal

Classic

List

Threaded

4 messages Options

Mark Webb-5

Syntax assistance for long file appeal

Hi all
Could someone please point me in the right direction with this problem.
As an example -

Question - Mention up to 3 beers you are aware of.

The flat file - 3 respondents.

record beer1 beer2 beer3
    1          A        B        C
    2          C
    3          B       C

The long file -
I have a long file [result of varstocases] with market research multi-mention data.

I want to count the number of responses within respondent [via syntax] as shown below.

record question response Desired Count of Responses per record
    1          beer1         A           3
    1           beer2         B             3
    1           beer3         C             3
    2           beer1 C             1
    2           beer2                        1
    2           beer3                        1
    3           beer1    B       2
    3           beer2      C          2
    3           beer3 2

Thanking you in advance
Regards

-- 
Mark Webb

Line +27 (21) 786 1124
Cell +27 (72) 199 1000 [Poor reception]
Fax  +27 (86) 260 1946 

Skype       tomarkwebb 
Email       [hidden email]

===================== 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

David Marso

Re: Syntax assistance for long file appeal

Administrator

AGGREGATE OUTFILE <shift eight> MODE=ADDVARIABLES /BREAK=record / N=N.
My number bar is FUBAR so can't type asterisk.

Mark Webb-5 wrote

> Hi all
> Could someone please point me in the right direction with this problem.
> As an example -
>
> Question - Mention up to 3 beers you are aware of.
>
> The flat file - 3 respondents.
>
> record beer1 beer2 beer3
>      1          A        B        C
>      2          C
>      3          B       C
>
> The long file -
> I have a long file [result of varstocases] with market research
> multi-mention data.
>
> I want to count the number of responseswithin respondent [via syntax] as
> shown below.
>
> record question response Desired Count of Responses per record
>      1          beer1 A 3
>      1           beer2         B 3
>      1           beer3         C 3
>      2           beer1 C 1
>      2           beer2 1
>      2           beer3 1
>      3           beer1    B 2
>      3           beer2      C 2
>      3           beer3 2
>
> Thanking you in advance
> Regards
>
> --
> Mark Webb
>
> Line +27 (21) 786 1124
> Cell +27 (72) 199 1000 [Poor reception]
> Fax +27 (86) 260 1946
>
> Skype tomarkwebb
> Email

> targetlinkmark@

>
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

> (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

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"

Bruce Weaver

Re: Syntax assistance for long file appeal

Administrator

ALT-42 (using numeric key pad) should give you the same thing as Shift-8.

Shift-8: *
ALT-42: *

David Marso wrote

> AGGREGATE OUTFILE
> <shift eight>
> MODE=ADDVARIABLES /BREAK=record / N=N.
> My number bar is FUBAR so can't type asterisk.
>
>
> Mark Webb-5 wrote
>> Hi all
>> Could someone please point me in the right direction with this problem.
>> As an example -
>>
>> Question - Mention up to 3 beers you are aware of.
>>
>> The flat file - 3 respondents.
>>
>> record beer1 beer2 beer3
>>      1          A        B        C
>>      2          C
>>      3          B       C
>>
>> The long file -
>> I have a long file [result of varstocases] with market research
>> multi-mention data.
>>
>> I want to count the number of responseswithin respondent [via syntax] as
>> shown below.
>>
>> record question response Desired Count of Responses per record
>>      1          beer1 A 3
>>      1           beer2         B 3
>>      1           beer3         C 3
>>      2           beer1 C 1
>>      2           beer2 1
>>      2           beer3 1
>>      3           beer1    B 2
>>      3           beer2      C 2
>>      3           beer3 2
>>
>> Thanking you in advance
>> Regards
>>
>> --
>> Mark Webb
>>
>> Line +27 (21) 786 1124
>> Cell +27 (72) 199 1000 [Poor reception]
>> Fax +27 (86) 260 1946
>>
>> Skype tomarkwebb
>> Email
>
>> targetlinkmark@
>
>>
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>
>> LISTSERV@.UGA
>
>> (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
>
>
>
>
>
> -----
> Please reply to the list and not to my personal email.
> Those desiring my consulting or training services please feel free to
> email me.
> ---
> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos
> ne forte conculcent eas pedibus suis."
> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in
> abyssum?"
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

> (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

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).

David Marso

Re: Syntax assistance for long file appeal

Administrator

Unfortunately my numeric key pad is also out to lunch.
the 5 key works fine but the others are hit and miss.
Sometimes they work fine. Others no go.

--

Bruce Weaver wrote

> ALT-42 (using numeric key pad) should give you the same thing as Shift-8.
>
> Shift-8: *
> ALT-42: *
>
>
>
> David Marso wrote
>> AGGREGATE OUTFILE
>>
> <shift eight>
>> MODE=ADDVARIABLES /BREAK=record / N=N.
>> My number bar is FUBAR so can't type asterisk.
>>
>>
>> Mark Webb-5 wrote
>>> Hi all
>>> Could someone please point me in the right direction with this problem.
>>> As an example -
>>>
>>> Question - Mention up to 3 beers you are aware of.
>>>
>>> The flat file - 3 respondents.
>>>
>>> record beer1 beer2 beer3
>>>      1          A        B        C
>>>      2          C
>>>      3          B       C
>>>
>>> The long file -
>>> I have a long file [result of varstocases] with market research
>>> multi-mention data.
>>>
>>> I want to count the number of responseswithin respondent [via syntax] as
>>> shown below.
>>>
>>> record question response Desired Count of Responses per record
>>>      1          beer1 A 3
>>>      1           beer2         B 3
>>>      1           beer3         C 3
>>>      2           beer1 C 1
>>>      2           beer2 1
>>>      2           beer3 1
>>>      3           beer1    B 2
>>>      3           beer2      C 2
>>>      3           beer3 2
>>>
>>> Thanking you in advance
>>> Regards
>>>
>>> --
>>> Mark Webb
>>>
>>> Line +27 (21) 786 1124
>>> Cell +27 (72) 199 1000 [Poor reception]
>>> Fax +27 (86) 260 1946
>>>
>>> Skype tomarkwebb
>>> Email
>>
>>> targetlinkmark@
>>
>>>
>>>
>>> =====================
>>> To manage your subscription to SPSSX-L, send a message to
>>
>>> LISTSERV@.UGA
>>
>>> (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
>>
>>
>>
>>
>>
>> -----
>> Please reply to the list and not to my personal email.
>> Those desiring my consulting or training services please feel free to
>> email me.
>> ---
>> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante
>> porcos
>> ne forte conculcent eas pedibus suis."
>> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff
>> in
>> abyssum?"
>> --
>> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>
>> LISTSERV@.UGA
>
>> (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
>
>
>
>
>
> -----
> --
> Bruce Weaver

> bweaver@

> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

> (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

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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