Greetings all,
Have any of you had experience using SPSS in attribution modeling for your media clients or for manufacturers looking to optimize their media mix? Could you point me to some information on how SPSS is being implemented in those environments? I would find it most helpful.
Many thanks,
Bob Walker
Surveys & Forecasts, LLC
https://www.safllc.com-----Original Message-----
From: SPSSX(r) Discussion <
[hidden email]> On Behalf Of Bruce Weaver
Sent: Tuesday, September 15, 2020 6:14 PM
To:
[hidden email]
Subject: Re: Duplicates
Hi Bob. Different strokes for different folks, but for Yes/No variables, I prefer coding them such that 1=Yes and 0=No. For your example, I would do something like this.
* Create a small dataset to illustrate.
NEW FILE.
DATASET CLOSE ALL.
DATA LIST LIST / BusinessEmail (A25).
BEGIN DATA
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
[hidden email]
END DATA.
SORT CASES BY BusinessEmail.
* Code Duplicate such that 1=Yes, 0=No.
COMPUTE Duplicate = BusinessEmail EQ LAG(BusinessEmail).
FORMATS Duplicate(F1).
LIST.
SELECT IF NOT Duplicate.
LIST.
With 1/0 coding, that SELECT IF line works the same as this would:
SELECT IF Duplicate EQ 0.
I just think it reads better as NOT Duplicate.
HTH.
Robert Walker wrote
> Hi all,
>
> What is the disadvantage of this code vs. "Identify Duplicate Cases"
> in the GUI?
>
> * De-dupe.
> SORT CASES BY BusinessEmail.
> COMPUTE DupeFlag=1.
> IF BusinessEmail=LAG(BusinessEmail) DupeFlag=2.
> SELECT IF DupeFlag=1.
> EXECUTE.
>
> Cheers,
>
> Bob Walker
> Surveys & Forecasts, LLC
>
https://www.safllc.com-----
--
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
=====================
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
Locked
