Date: Thu, 12 Jul 2007 15:53:27 -0500
Reply-To: "Hashmi, Syed S" <Syed.S.Hashmi.email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Hashmi, Syed S" <Syed.S.Hashmi.firstname.lastname@example.org>
Subject: Re: Wild cards
Content-Type: text/plain; charset="iso-8859-1"
I got the following error when I tried running your syntax:
An undefined variable name, or a scratch or system variable was specified in a variable list which accepts only standard variables. Check spelling and verify the existence of this variable.¬This command not executed.¬
However, I broke it up into two separate commands and can use the final variable in the DO IF statements:
COMPUTE MODstep = MOD(code1, 1).
COMPUTE TRUNCstep = TRUNC(MODstep*10).
DO IF TRUNCstep = 1.
It works great! Thanks again.
> -----Original Message-----
> From: Melissa Ives [mailto:email@example.com]
> Sent: Thursday, July 12, 2007 3:02 PM
> To: Hashmi, Syed S; SPSSX-L@LISTSERV.UGA.EDU
> Subject: RE: [SPSSX-L] Wild cards
> Look into a calculation using a combination of MOD and TRUNC
> MOD. MOD(numexpr,modulus). Numeric. Returns the remainder when numexpr
> is divided by modulus. Both arguments must be numeric, and modulus must
> not be 0.
> TRUNC. TRUNC(numexpr). Numeric. Returns the value of numexpr truncated
> to an integer (toward 0).
> Something like this (totally untested)--where you want to divide code1
> by 1 to keep only the portion following the decimal, then multiply by 10
> and truncate the result so you get just the 1 in your 2.13/5.18 example
> Do if (trunc((mod(code1,1)/10)).
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
> Hashmi, Syed S
> Sent: Thursday, July 12, 2007 2:53 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: [SPSSX-L] Wild cards
> Hello everyone,
> I have some data where the cases have numerical codes assigned to them
> in a variable called "code1" the format #.## and range from 1.10 to 9.79
> (though it does not include every single number in that range). Each of
> the three characters in that code stands for some common characteristic,
> eg. 1.10 is similar to 1.20 or 1.34 (all are in 1.## format).
> Similarly, 1.10 shares some characteristics with 2.13 or 5.18 (all are
> in #.1# format).
> I wanted to make some computations based on the values of these codes.
> It's easy when I wanted to do the computations for all cases with
> code1=2.** or code=3.2* since it involved a simple DO IF statement:
> DO IF (code1 GE 1.00 & code1 LE 1.99).
> My issue arises when I want to do computations on cases where the codes
> are similar at the second character, eg. all cases with a #.2# code.
> Does SPSS (I'm on v.15) have any wild card characters that I could use
> for doing this?? If not, can I use the INDEX subcommand to specify the
> character instead?
> I would appreciate any help that anyone might be able to provide. Thanks
> a heap in advance.
> - Shahrukh Hashmi
> PRIVILEGED AND CONFIDENTIAL INFORMATION
> This transmittal and any attachments may contain PRIVILEGED AND
> CONFIDENTIAL information and is intended only for the use of the
> addressee. If you are not the designated recipient, or an employee
> or agent authorized to deliver such transmittals to the designated
> recipient, you are hereby notified that any dissemination,
> copying or publication of this transmittal is strictly prohibited. If
> you have received this transmittal in error, please notify us
> immediately by replying to the sender and delete this copy from your
> system. You may also call us at (309) 827-6026 for assistance.