find and replace syntax - problem with quote character

[Brian Moore-7]

Hi all-

I’ve used the following to get rid of special characters in a strong, but have run into a problem because the quote symbol “ is a character I need to get rid of.  I tried using single quotes to enclose it & that still didn’t work (error message at the end if that is helpful).

I’d love to know the “real answer” if anyone does, but a workaround that cleans out everything but alpha and numeric characters would work as well.

I’m using V15.

Thanks,

Brian

This works:

DO IF (INDEX(Glossary_Term,"]")>0).

LOOP.

COMPUTE Glossary_Term = CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,"]")-1),"",

  SUBSTR(Glossary_Term,INDEX(Glossary_Term,"]")+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,"]"))).

END LOOP IF (INDEX(Glossary_Term,"]")=0).

END IF.

EXECUTE.

But exactly as above subbing “ for ] does not work, nor does what is below.

DO IF (INDEX(Glossary_Term,'"')>0).

LOOP.

COMPUTE Glossary_Term = CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,'"')-1),"",

  SUBSTR(Glossary_Term,INDEX(Glossary_Term,'"')+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,'"'))).

END LOOP IF (INDEX(Glossary_Term,'"')=0).

END IF.

EXECUTE.

>Error # 4095.  Command name: EXECUTE

>The transformations program contains an unclosed LOOP, DO IF, or complex

>file structure.  Use the level-of-control shown to the left of the SPSS

>commands to determine the range of LOOPs and DO IFs.

>This command not executed.

Brian Moore
Market Research Manager
WorldatWork

14040 N. Northsight Blvd.
Scottsdale, AZ. 85260 USA
Tel: [phone] Fax: [phone]
E-mail: [hidden email]
www.worldatwork.org

UPCOMING CONFERENCES:
Total Rewards 2010
May 16-19  |  Dallas / Ft.Worth, TX

The GTA Rewards Association
Total Rewards 2010 Canadian Conference
In partnership with the Ottawa Region Rewards Association and WorldatWork
Sept. 13-15 | Toronto

[Mike Pritchard]

I’m defeated by SPSS and turning to Excel for this little problem, which appears to be partly caused by my improper setting up of the survey.  If the list can come up with a solution – at least I’ll be in better shape for next time.  It is probably very simple, but I’ve been staring at the screen too long.

I have a set of food categories for which I’m testing frequency of consumption, and also reasons.  The analysis of frequency is fine, but the analysis of reasons has me beat.  There were 3 questions for each category – common reasons of Enjoy/Healthy/Like Taste – each as a Yes or No.  Ideally what I’d like from SPSS is a set of frequencies based on those who ever consume.   Failing that, a set of counts would be fine – then I can just finish off with Excel to produce a final table.

As I write this it sounds simple, but I’m stumped after trying various combinations of crosstabs and custom tables.  I’m using SPSS V16.

Thanks in advance.

Mike

_________________________________________________________________________
Mike Pritchard | [hidden email] | 5 Circles Research | 425-444-3410
Helping companies build competitive advantage

 

 

[John F Hall]

Sounds like you need multiple response.  Assuming Yes is coded 1

 

mult resp groups = reasons 'Reasons given' (reason1 to reason3 (1))

    /var food1 ...foodn

    /tab food1 ....foodn by reasons.

 

This will pick up var labels, not value labels for reason1 to reason3.  If you like you can do the following instead.  

 

recode reason2 (1=2) /reason3 (1=3) .

value labels reason1 1 'Enjoy' 2 'Healthy' 3 'Like taste' .

mult resp groups = reasons 'Reasons given' (reason1 to reason3 (1,3))

    /var food1 ...foodn

    /tab food1 ....foodn by reasons.

 

Note that mult resp only picks up value labels from the first variable in the list.

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Thursday, October 15, 2009 3:50 AM

Subject: Setting up and reporting on multiple reasons

I’m defeated by SPSS and turning to Excel for this little problem, which appears to be partly caused by my improper setting up of the survey.  If the list can come up with a solution – at least I’ll be in better shape for next time.  It is probably very simple, but I’ve been staring at the screen too long.

I have a set of food categories for which I’m testing frequency of consumption, and also reasons.  The analysis of frequency is fine, but the analysis of reasons has me beat.  There were 3 questions for each category – common reasons of Enjoy/Healthy/Like Taste – each as a Yes or No.  Ideally what I’d like from SPSS is a set of frequencies based on those who ever consume.   Failing that, a set of counts would be fine – then I can just finish off with Excel to produce a final table.

As I write this it sounds simple, but I’m stumped after trying various combinations of crosstabs and custom tables.  I’m using SPSS V16.

Thanks in advance.

Mike

_________________________________________________________________________
Mike Pritchard | [hidden email] | 5 Circles Research | 425-444-3410
Helping companies build competitive advantage

 

 

[ViAnn Beadle]

Tabulation problems like this are always very difficult to describe succinctly but I’m going to guess that you are trying to cross paired multiple responses. Basically the unit of analysis is here is a category of food consumed and not a person. If the file is structured so that a case is a person, you can change it with the VARSTOCASES command.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mike Pritchard
Sent: Wednesday, October 14, 2009 7:50 PM
To: [hidden email]
Subject: Setting up and reporting on multiple reasons

 

I’m defeated by SPSS and turning to Excel for this little problem, which appears to be partly caused by my improper setting up of the survey.  If the list can come up with a solution – at least I’ll be in better shape for next time.  It is probably very simple, but I’ve been staring at the screen too long.

I have a set of food categories for which I’m testing frequency of consumption, and also reasons.  The analysis of frequency is fine, but the analysis of reasons has me beat.  There were 3 questions for each category – common reasons of Enjoy/Healthy/Like Taste – each as a Yes or No.  Ideally what I’d like from SPSS is a set of frequencies based on those who ever consume.   Failing that, a set of counts would be fine – then I can just finish off with Excel to produce a final table.

As I write this it sounds simple, but I’m stumped after trying various combinations of crosstabs and custom tables.  I’m using SPSS V16.

Thanks in advance.

Mike

_________________________________________________________________________
Mike Pritchard | [hidden email] | 5 Circles Research | 425-444-3410
Helping companies build competitive advantage

 

 

[Albert-Jan Roskam]

Hi Brian!

REPLACE comes in handy here:

data list free / x (a20).
begin data
'lalala"lalala'
"lalala'lalala"
end data.

compute x = replace(replace(x, "'",""),'"', '').

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Before you criticize someone, walk a mile in their shoes, that way
when you do criticize them, you're a mile away and you have their shoes!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


--- On Thu, 10/15/09, Brian Moore <[hidden email]> wrote:

> From: Brian Moore <[hidden email]>
> Subject: [SPSSX-L] find and replace syntax - problem with quote character
> To: [hidden email]
> Date: Thursday, October 15, 2009, 12:40 AM
>
>
>
>
>
> find and replace syntax - problem with quote
> character
>
>
>
>
> Hi all-
>
> I’ve used the
> following to get rid of special
> characters in a strong, but have run into a problem because
> the quote symbol “ is a character I need to get rid of.�  I tried using
> single quotes to enclose it & that still didn’t work (error message at the end if
> that is helpful).
>
> I’d love to know the “real answer” if anyone does,
> but a workaround that cleans out everything
> but alpha and numeric characters would work as well.
>
> I’m using V15.
>
> Thanks,
>
> Brian
>
> This works:
>
> DO IF
> (INDEX(Glossary_Term,"]")>0).
>
> LOOP.
>
> COMPUTE Glossary_Term =
> CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,"]")-1),"",
>
> �
> SUBSTR(Glossary_Term,INDEX(Glossary_Term,"]")+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,"]"))).
>
> END LOOP IF
> (INDEX(Glossary_Term,"]")=0).
>
> END IF.
>
> EXECUTE.
>
>
>
>
>
> But exactly as above subbing “ for ] does not
> work, nor does what is below.
>
>
>
> DO IF
> (INDEX(Glossary_Term,'"')>0).
>
> LOOP.
>
> COMPUTE Glossary_Term =
> CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,'"')-1),"",
>
> �
> SUBSTR(Glossary_Term,INDEX(Glossary_Term,'"')+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,'"'))).
>
> END LOOP IF
> (INDEX(Glossary_Term,'"')=0).
>
> END IF.
>
> EXECUTE.
>
> >Error # 4095.�  Command
> name: EXECUTE
>
> >The transformations program
> contains an unclosed LOOP, DO IF, or
> complex
>
> >file structure.�  Use
> the level-of-control shown to the left of the
> SPSS
>
> >commands to determine the
> range of LOOPs and DO IFs.
>
> >This command not
> executed.
>
>
>
>
>
> Brian Moore
>
> Market Research Manager
>
> WorldatWork
>
> 14040 N. Northsight Blvd.
>
> Scottsdale, AZ. 85260 USA
>
> Tel: [phone] Fax: [phone]
>
> E-mail: [hidden email]
>
> www.worldatwork.org
>
>
>
>
>
> UPCOMING CONFERENCES:
>
> Total Rewards
> 2010
>
> May 16-19 � | � Dallas / Ft.Worth,
> TX
>
> The GTA Rewards Association
>
> Total Rewards 2010
> Canadian Conference
>
> In partnership with the Ottawa Region Rewards Association
> and WorldatWork
>
> Sept. 13-15� |� Toronto
>
>
>
>
>
>
>
>
>

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

[mpirritano]

Hey folks,

 

I’d like to add a legend for this graph. I’m not sure how to do it since each line in the graph is a separate element.

 

Here’s the code:

 

BEGIN GPL

              SOURCE: s=userSource(id("graphdataset"))

              DATA: month_year=col(source(s), name("month_year"))

              DATA: ed_1000=col(source(s), name("ed_1000"))

              DATA: office_1000=col(source(s), name("office_1000"))

              DATA: outpatient_1000=col(source(s), name("outpatient_1000"))

              DATA: in_days_1000=col(source(s), name("in_days_1000"))

              TRANS: month_year_ed_1000=eval("ED visits per 1000")

              TRANS: month_year_office_1000=eval("Office visits per 1000")

              TRANS: month_year_outpatient_1000=eval("Outpatient visits per 1000")

              TRANS: month_year_in_days_1000=eval("Inpatient days per 1000")

              GUIDE: text.title(label("Utilization per 1000 Members by Place of Service"))

              GUIDE: axis(dim(1), label("Time"))

              GUIDE: axis(dim(2), label("Visits/ Days(for Inpatient Days) per 1000"))

              ELEMENT: point(position(month_year*ed_1000), color.interior(color.salmon))

              ELEMENT: point(position(month_year*office_1000), color.interior(color.turquoise))

              ELEMENT: point(position(month_year*outpatient_1000), color.interior(color.lawngreen))

              ELEMENT: point(position(month_year*in_days_1000), color.interior(color.cornflowerblue))        

              ELEMENT: line(position(smooth.linear(month_year*ed_1000)), size(size."2%"), color.interior(color.salmon))

              ELEMENT: line(position(smooth.linear(month_year*office_1000)), size(size."2%"),color.interior(color.turquoise))

              ELEMENT: line(position(smooth.linear(month_year*outpatient_1000)), size(size."2%"),color.interior(color.lawngreen))

              ELEMENT: line(position(smooth.linear(month_year*in_days_1000)), size(size."2%"),color.interior(color.cornflowerblue))                

            END GPL.

            OMSEND.

 

Any help would be much appreciated!

 

Thanks

matt

 

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

[phone]

[ViAnn Beadle]

If you provide an argument, rather than a constant, to the color.interior function, you will get a legend. For example, use something like this for the 1^st element:

 

ELEMENT: point(position(month_year*ed_1000), color.interior(“ED visits per 1000”))

 

To keep the choices of colors, you have two options—use a custom template with those colors in the color cycle or use the map function to map the strings to the colors.

 

I’m not sure what your are trying to do with the TRANS statements. You are setting a variable to a string but then you never use that variable anywhere.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Pirritano, Matthew
Sent: Thursday, October 15, 2009 9:38 AM
To: [hidden email]
Subject: gpl question: how to add a legend

 

Hey folks,

 

I’d like to add a legend for this graph. I’m not sure how to do it since each line in the graph is a separate element.

 

Here’s the code:

 

BEGIN GPL

              SOURCE: s=userSource(id("graphdataset"))

              DATA: month_year=col(source(s), name("month_year"))

              DATA: ed_1000=col(source(s), name("ed_1000"))

              DATA: office_1000=col(source(s), name("office_1000"))

              DATA: outpatient_1000=col(source(s), name("outpatient_1000"))

              DATA: in_days_1000=col(source(s), name("in_days_1000"))

              TRANS: month_year_ed_1000=eval("ED visits per 1000")

              TRANS: month_year_office_1000=eval("Office visits per 1000")

              TRANS: month_year_outpatient_1000=eval("Outpatient visits per 1000")

              TRANS: month_year_in_days_1000=eval("Inpatient days per 1000")

              GUIDE: text.title(label("Utilization per 1000 Members by Place of Service"))

              GUIDE: axis(dim(1), label("Time"))

              GUIDE: axis(dim(2), label("Visits/ Days(for Inpatient Days) per 1000"))

              ELEMENT: point(position(month_year*ed_1000), color.interior(color.salmon))

              ELEMENT: point(position(month_year*office_1000), color.interior(color.turquoise))

              ELEMENT: point(position(month_year*outpatient_1000), color.interior(color.lawngreen))

              ELEMENT: point(position(month_year*in_days_1000), color.interior(color.cornflowerblue))        

              ELEMENT: line(position(smooth.linear(month_year*ed_1000)), size(size."2%"), color.interior(color.salmon))

              ELEMENT: line(position(smooth.linear(month_year*office_1000)), size(size."2%"),color.interior(color.turquoise))

              ELEMENT: line(position(smooth.linear(month_year*outpatient_1000)), size(size."2%"),color.interior(color.lawngreen))

              ELEMENT: line(position(smooth.linear(month_year*in_days_1000)), size(size."2%"),color.interior(color.cornflowerblue))                

            END GPL.

            OMSEND.

 

Any help would be much appreciated!

 

Thanks

matt

 

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

[phone]

[Raffe, Sydelle, SSA]

Oh wow -- this came just in time. Didn't know about REPLACE. Thank you.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Albert-Jan Roskam
Sent: Thursday, October 15, 2009 7:50 AM
To: [hidden email]
Subject: Re: find and replace syntax - problem with quote character


Hi Brian!

REPLACE comes in handy here:

data list free / x (a20).
begin data
'lalala"lalala'
"lalala'lalala"
end data.

compute x = replace(replace(x, "'",""),'"', '').

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Before you criticize someone, walk a mile in their shoes, that way
when you do criticize them, you're a mile away and you have their shoes!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


--- On Thu, 10/15/09, Brian Moore <[hidden email]> wrote:

> From: Brian Moore <[hidden email]>
> Subject: [SPSSX-L] find and replace syntax - problem with quote character
> To: [hidden email]
> Date: Thursday, October 15, 2009, 12:40 AM
>
>
>
>
>
> find and replace syntax - problem with quote
> character
>
>
>
>
> Hi all-
>
> I’ve used the
> following to get rid of special
> characters in a strong, but have run into a problem because
> the quote symbol “ is a character I need to get rid of.  I tried using
> single quotes to enclose it & that still didn’t work (error message at the end if
> that is helpful).
>
> I’d love to know the “real answer” if anyone does,
> but a workaround that cleans out everything
> but alpha and numeric characters would work as well.
>
> I’m using V15.
>
> Thanks,
>
> Brian
>
> This works:
>
> DO IF
> (INDEX(Glossary_Term,"]")>0).
>
> LOOP.
>
> COMPUTE Glossary_Term =
> CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,"]")-1),"",
>
>
> SUBSTR(Glossary_Term,INDEX(Glossary_Term,"]")+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,"]"))).
>
> END LOOP IF
> (INDEX(Glossary_Term,"]")=0).
>
> END IF.
>
> EXECUTE.
>
>
>
>
>
> But exactly as above subbing “ for ] does not
> work, nor does what is below.
>
>
>
> DO IF
> (INDEX(Glossary_Term,'"')>0).
>
> LOOP.
>
> COMPUTE Glossary_Term =
> CONCAT(SUBSTR(Glossary_Term,1,INDEX(Glossary_Term,'"')-1),"",
>
>
> SUBSTR(Glossary_Term,INDEX(Glossary_Term,'"')+1,LENGTH(Glossary_Term)-INDEX(Glossary_Term,'"'))).
>
> END LOOP IF
> (INDEX(Glossary_Term,'"')=0).
>
> END IF.
>
> EXECUTE.
>
> >Error # 4095.  Command
> name: EXECUTE
>
> >The transformations program
> contains an unclosed LOOP, DO IF, or
> complex
>
> >file structure.  Use
> the level-of-control shown to the left of the
> SPSS
>
> >commands to determine the
> range of LOOPs and DO IFs.
>
> >This command not
> executed.
>
>
>
>
>
> Brian Moore
>
> Market Research Manager
>
> WorldatWork
>
> 14040 N. Northsight Blvd.
>
> Scottsdale, AZ. 85260 USA
>
> Tel: [phone] Fax: [phone]
>
> E-mail: [hidden email]
>
> www.worldatwork.org
>
>
>
>
>
> UPCOMING CONFERENCES:
>
> Total Rewards
> 2010
>
> May 16-19  |  Dallas / Ft.Worth,
> TX
>
> The GTA Rewards Association
>
> Total Rewards 2010
> Canadian Conference
>
> In partnership with the Ottawa Region Rewards Association
> and WorldatWork
>
> Sept. 13-15 | Toronto
>
>
>
>
>
>
>
>
>

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

[mpirritano]

ViAnn!

 

Thanks! Works like a charm! The TRANS statements are the result of pasting the syntax.

 

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

[phone]

---

From: ViAnn Beadle [mailto:[hidden email]]
Sent: Thursday, October 15, 2009 1:43 PM
To: Pirritano, Matthew; [hidden email]
Subject: RE: gpl question: how to add a legend

 

If you provide an argument, rather than a constant, to the color.interior function, you will get a legend. For example, use something like this for the 1^st element:

 

ELEMENT: point(position(month_year*ed_1000), color.interior(“ED visits per 1000”))

 

To keep the choices of colors, you have two options—use a custom template with those colors in the color cycle or use the map function to map the strings to the colors.

 

I’m not sure what your are trying to do with the TRANS statements. You are setting a variable to a string but then you never use that variable anywhere.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Pirritano, Matthew
Sent: Thursday, October 15, 2009 9:38 AM
To: [hidden email]
Subject: gpl question: how to add a legend

 

Hey folks,

 

I’d like to add a legend for this graph. I’m not sure how to do it since each line in the graph is a separate element.

 

Here’s the code:

 

BEGIN GPL

              SOURCE: s=userSource(id("graphdataset"))

              DATA: month_year=col(source(s), name("month_year"))

              DATA: ed_1000=col(source(s), name("ed_1000"))

              DATA: office_1000=col(source(s), name("office_1000"))

              DATA: outpatient_1000=col(source(s), name("outpatient_1000"))

              DATA: in_days_1000=col(source(s), name("in_days_1000"))

              TRANS: month_year_ed_1000=eval("ED visits per 1000")

              TRANS: month_year_office_1000=eval("Office visits per 1000")

              TRANS: month_year_outpatient_1000=eval("Outpatient visits per 1000")

              TRANS: month_year_in_days_1000=eval("Inpatient days per 1000")

              GUIDE: text.title(label("Utilization per 1000 Members by Place of Service"))

              GUIDE: axis(dim(1), label("Time"))

              GUIDE: axis(dim(2), label("Visits/ Days(for Inpatient Days) per 1000"))

              ELEMENT: point(position(month_year*ed_1000), color.interior(color.salmon))

              ELEMENT: point(position(month_year*office_1000), color.interior(color.turquoise))

              ELEMENT: point(position(month_year*outpatient_1000), color.interior(color.lawngreen))

              ELEMENT: point(position(month_year*in_days_1000), color.interior(color.cornflowerblue))        

              ELEMENT: line(position(smooth.linear(month_year*ed_1000)), size(size."2%"), color.interior(color.salmon))

              ELEMENT: line(position(smooth.linear(month_year*office_1000)), size(size."2%"),color.interior(color.turquoise))

              ELEMENT: line(position(smooth.linear(month_year*outpatient_1000)), size(size."2%"),color.interior(color.lawngreen))

              ELEMENT: line(position(smooth.linear(month_year*in_days_1000)), size(size."2%"),color.interior(color.cornflowerblue))                

            END GPL.

            OMSEND.

 

Any help would be much appreciated!

 

Thanks

matt

 

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

[phone]