SPSSX Discussion

Macro strings/variable names

Classic

List

Threaded

6 messages Options

Jignesh Sutar

Macro strings/variable names

Hi,

Can somebody please help me fill in the gap in the syntax where I have
placed the comment /*XXXX*/.

I am trying to achieve the following result:

AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK = sample
/ v1_m = MEAN(v1_r).

AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK = sample
/ v2_m = MEAN(v2_r).

I want to specify in the code to replace characters from the
underscore onwards to any other characters of my choice.

I've attempted the !INDEX and !SUBSTR but struggled to come to a
solution because simple arithmetic can not be performed within macros.

Many thanks in advance

Jignesh

/*//////////////////////////////*/
DEFINE AggMean (vars=!CMDEND).
!DO !i !IN (!vars)
AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK = sample
/ /*XXXX*/ = MEAN(!i).
!DOEND
!ENDDEFINE.
/*//////////////////////////////*/
SET MPRINT=ON.
AggMean vars=v1_r v2_r v3_r.
SET MPRINT=OFF.

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

Bob Walker-2

Re: Macro strings/variable names

Albert-Jan Roskam

Re: Macro strings/variable names

Hi,

Here's a dictionary-based Python method to do it. Keys/Values is input/output, respectively.

Cheers!!
Albert-Jan

* sample data.
get file='C:\Program Files\Spss\Employee data.sav'.
set mprint = on.
compute sample = 1.
exe.

* actual program.
begin program.
def AggMean (vars):
import spss
cmd = ["AGGR OUT = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK = sample "] + \
[" / " + vars.values()[i] + " = MEAN ( " + vars.keys()[i] + " ) " for i in range(len(vars))] + ["."]
spss.Submit(cmd)
AggMean ({'educ': 'm_educ', 'salary': 'm_salary', 'jobtime': 'm_jobtime'})
end program.

--- On Wed, 8/27/08, Bob Walker <[hidden email]> wrote:

> From: Bob Walker <[hidden email]>
> Subject: Re: Macro strings/variable names
> To: [hidden email]
> Date: Wednesday, August 27, 2008, 6:56 PM
> Jignesh,
>
> Try !CONCAT within your !DO command, as in...
>
> SET MEXPAND ON / MPRINT=ON / PRI=ON.
> DATASET CLOSE ALL.
> DATA LIST FREE /sample v1_r v2_r v3_r.
> BEGIN DATA
> 2,22,7125,67865
> 2,35,9981,77654
> 1,32,10211,98998
> 2,45,8988,67865
> 1,33,6711,67865
> 4,27,5674,98998
> 3,65,3126,77654
> 2,27,7801,98998
> 3,21,1211,77654
> 3,27,9099,98998
> 4,32,9000,12345
> 4,44,10000,33227
> 1,44,18763,12122
> 4,53,388,44444
> END DATA.
> DATASET NAME Jignesh.
>
> DEFINE AggMean (vars=!CMDEND).
> AGG OUT = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK=sample
> !DO !i !IN (!vars)
> / !CONCAT ("v",!i,"_m") = MEAN
> (!CONCAT("v",!i,"_r"))
> !DOEND.
> !ENDDEFINE.
>
> AggMean vars = 1 2 3.
>
>
> HTH,
>
> Bob Walker
> Surveys & Forecasts, LLC
> www.safllc.com
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]
> On Behalf Of J
> Sutar
> Sent: Wednesday, August 27, 2008 12:01 PM
> To: [hidden email]
> Subject: Macro strings/variable names
>
> Hi,
>
> Can somebody please help me fill in the gap in the syntax
> where I have
> placed the comment /*XXXX*/.
>
> I am trying to achieve the following result:
>
> AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES /
> BREAK = sample
> / v1_m = MEAN(v1_r).
>
> AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES /
> BREAK = sample
> / v2_m = MEAN(v2_r).
>
> I want to specify in the code to replace characters from
> the
> underscore onwards to any other characters of my choice.
>
> I've attempted the !INDEX and !SUBSTR but struggled to
> come to a
> solution because simple arithmetic can not be performed
> within macros.
>
> Many thanks in advance
>
> Jignesh
>
>
>
> /*//////////////////////////////*/
> DEFINE AggMean (vars=!CMDEND).
> !DO !i !IN (!vars)
> AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE = YES /
> BREAK = sample
> / /*XXXX*/ = MEAN(!i).
> !DOEND
> !ENDDEFINE.
> /*//////////////////////////////*/
> SET MPRINT=ON.
> AggMean vars=v1_r v2_r v3_r.
> SET MPRINT=OFF.
>
> =====================
> 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
>
>
>
>
> E-mail message checked by Spyware Doctor (6.0.0.362)
> Database version: 5.10570
> http://www.pctools.com/en/spyware-doctor-antivirus/
>
>
>
>
>
> E-mail message checked by Spyware Doctor (6.0.0.362)
> Database version: 5.10570
> http://www.pctools.com/en/spyware-doctor-antivirus/
>
> =====================
> 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

Jignesh Sutar-2

Re: Macro strings/variable names - Not Receiving emails??

I posted the original email from my gmail account but I didn't receive
the two replies from Bob and Albert-Jan on my gmail account, but I did
receive them on my work email account? I know they were sent to the list
only (as oppose to including me in cc), but they should have still
appeared in my gmail account like all other emails to the list?

Any idea why this is happening? I've checked my spam/bin folder and they
don't seem to have arrived?

Jignesh
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Albert-jan Roskam
Sent: 27 August 2008 20:35
To: [hidden email]
Subject: Re: Macro strings/variable names

Hi,

Here's a dictionary-based Python method to do it. Keys/Values is
input/output, respectively.

Cheers!!
Albert-Jan

* sample data.
get file='C:\Program Files\Spss\Employee data.sav'.
set mprint = on.
compute sample = 1.
exe.

* actual program.
begin program.
def AggMean (vars):
import spss
cmd = ["AGGR OUT = * MODE=ADDVARIABLE OVERWRITE = YES / BREAK =
sample "] + \
[" / " + vars.values()[i] + " = MEAN ( " + vars.keys()[i] + " )
" for i in range(len(vars))] + ["."]
spss.Submit(cmd)
AggMean ({'educ': 'm_educ', 'salary': 'm_salary', 'jobtime':
'm_jobtime'})
end program.

--- On Wed, 8/27/08, Bob Walker <[hidden email]> wrote:

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

============================
This e-mail and all attachments it may contain is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Ipsos MORI and its associated companies. If you are not the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, printing, forwarding or copying of this e-mail is strictly prohibited. Please contact the sender if you have received this e-mail in error.

Ipsos UK Ltd, Registered in England and Wales No. 1640855, Kings House, Kimberly Road, Harrow HA1 1PT, United Kingdom, 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

Albert-Jan Roskam

Re: Macro strings/variable names - Not Receiving emails??

Hi,

I'm experiencing the same thing. At my work (and online), I see more posts than I receive through my private yahoo account. No idea why. I tried updating my listserv account already, but to no avail. Maybe the list owner knows why this occurs?

Cheers!!
Albert-Jan

--- On Fri, 9/5/08, Jignesh Sutar <[hidden email]> wrote:

> From: Jignesh Sutar <[hidden email]>
> Subject: Re: Macro strings/variable names - Not Receiving emails??
> To: [hidden email]
> Date: Friday, September 5, 2008, 3:53 PM
> I posted the original email from my gmail account but I
> didn't receive
> the two replies from Bob and Albert-Jan on my gmail
> account, but I did
> receive them on my work email account? I know they were
> sent to the list
> only (as oppose to including me in cc), but they should
> have still
> appeared in my gmail account like all other emails to the
> list?
>
> Any idea why this is happening? I've checked my
> spam/bin folder and they
> don't seem to have arrived?
>
> Jignesh
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]
> On Behalf Of
> Albert-jan Roskam
> Sent: 27 August 2008 20:35
> To: [hidden email]
> Subject: Re: Macro strings/variable names
>
> Hi,
>
> Here's a dictionary-based Python method to do it.
> Keys/Values is
> input/output, respectively.
>
> Cheers!!
> Albert-Jan
>
>
> * sample data.
> get file='C:\Program Files\Spss\Employee
> data.sav'.
> set mprint = on.
> compute sample = 1.
> exe.
>
> * actual program.
> begin program.
> def AggMean (vars):
> import spss
> cmd = ["AGGR OUT = * MODE=ADDVARIABLE
> OVERWRITE = YES / BREAK =
> sample "] + \
> [" / " + vars.values()[i] + " =
> MEAN ( " + vars.keys()[i] + " )
> " for i in range(len(vars))] + ["."]
> spss.Submit(cmd)
> AggMean ({'educ': 'm_educ',
> 'salary': 'm_salary', 'jobtime':
> 'm_jobtime'})
> end program.
>
>
>
> --- On Wed, 8/27/08, Bob Walker
> <[hidden email]> wrote:
>
> > From: Bob Walker <[hidden email]>
> > Subject: Re: Macro strings/variable names
> > To: [hidden email]
> > Date: Wednesday, August 27, 2008, 6:56 PM
> > Jignesh,
> >
> > Try !CONCAT within your !DO command, as in...
> >
> > SET MEXPAND ON / MPRINT=ON / PRI=ON.
> > DATASET CLOSE ALL.
> > DATA LIST FREE /sample v1_r v2_r v3_r.
> > BEGIN DATA
> > 2,22,7125,67865
> > 2,35,9981,77654
> > 1,32,10211,98998
> > 2,45,8988,67865
> > 1,33,6711,67865
> > 4,27,5674,98998
> > 3,65,3126,77654
> > 2,27,7801,98998
> > 3,21,1211,77654
> > 3,27,9099,98998
> > 4,32,9000,12345
> > 4,44,10000,33227
> > 1,44,18763,12122
> > 4,53,388,44444
> > END DATA.
> > DATASET NAME Jignesh.
> >
> > DEFINE AggMean (vars=!CMDEND).
> > AGG OUT = * MODE=ADDVARIABLE OVERWRITE = YES /
> BREAK=sample
> > !DO !i !IN (!vars)
> > / !CONCAT ("v",!i,"_m") = MEAN
> > (!CONCAT("v",!i,"_r"))
> > !DOEND.
> > !ENDDEFINE.
> >
> > AggMean vars = 1 2 3.
> >
> >
> > HTH,
> >
> > Bob Walker
> > Surveys & Forecasts, LLC
> > www.safllc.com
> >
> >
> >
> > -----Original Message-----
> > From: SPSSX(r) Discussion
> [mailto:[hidden email]]
> > On Behalf Of J
> > Sutar
> > Sent: Wednesday, August 27, 2008 12:01 PM
> > To: [hidden email]
> > Subject: Macro strings/variable names
> >
> > Hi,
> >
> > Can somebody please help me fill in the gap in the
> syntax
> > where I have
> > placed the comment /*XXXX*/.
> >
> > I am trying to achieve the following result:
> >
> > AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE =
> YES /
> > BREAK = sample
> > / v1_m = MEAN(v1_r).
> >
> > AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE =
> YES /
> > BREAK = sample
> > / v2_m = MEAN(v2_r).
> >
> > I want to specify in the code to replace characters
> from
> > the
> > underscore onwards to any other characters of my
> choice.
> >
> > I've attempted the !INDEX and !SUBSTR but
> struggled to
> > come to a
> > solution because simple arithmetic can not be
> performed
> > within macros.
> >
> > Many thanks in advance
> >
> > Jignesh
> >
> >
> >
> > /*//////////////////////////////*/
> > DEFINE AggMean (vars=!CMDEND).
> > !DO !i !IN (!vars)
> > AGGREGATE OUTFILE = * MODE=ADDVARIABLE OVERWRITE =
> YES /
> > BREAK = sample
> > / /*XXXX*/ = MEAN(!i).
> > !DOEND
> > !ENDDEFINE.
> > /*//////////////////////////////*/
> > SET MPRINT=ON.
> > AggMean vars=v1_r v2_r v3_r.
> > SET MPRINT=OFF.
> >
> > =====================
> > 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
> >
> >
> >
> >
> > E-mail message checked by Spyware Doctor (6.0.0.362)
> > Database version: 5.10570
> > http://www.pctools.com/en/spyware-doctor-antivirus/
> >
> >
> >
> >
> >
> > E-mail message checked by Spyware Doctor (6.0.0.362)
> > Database version: 5.10570
> > http://www.pctools.com/en/spyware-doctor-antivirus/
> >
> > =====================
> > 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
>
>
>
> ============================
> This e-mail and all attachments it may contain is
> confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions
> presented are solely those of the author and do not
> necessarily represent those of Ipsos MORI and its associated
> companies. If you are not the intended recipient, be advised
> that you have received this e-mail in error and that any
> use, dissemination, printing, forwarding or copying of this
> e-mail is strictly prohibited. Please contact the sender if
> you have received this e-mail in error.
>
> Ipsos UK Ltd, Registered in England and Wales No. 1640855,
> Kings House, Kimberly Road, Harrow HA1 1PT, United Kingdom,
> 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

ViAnn Beadle

Re: Macro strings/variable names - Not Receiving emails??

Perhaps the emails are quarantined in spam folders?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Albert-jan Roskam
Sent: Friday, September 05, 2008 10:51 AM
To: [hidden email]
Subject: Re: Macro strings/variable names - Not Receiving emails??

Hi,

I'm experiencing the same thing. At my work (and online), I see more posts
than I receive through my private yahoo account. No idea why. I tried
updating my listserv account already, but to no avail. Maybe the list owner
knows why this occurs?

Cheers!!
Albert-Jan

--- On Fri, 9/5/08, Jignesh Sutar <[hidden email]> wrote: