|
Is there anywhere to download the CD image/zip for SPSS v14?
I am trying to reinstall on my new laptop, but can't locate the original CD. Any help? ===================== 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 |
|
All,
I have a 6 character string var (HEDLEV) with many missing values. I have another 6 character string (FICE) which fills in most of the missing val;ues in the first string. I want to concatenate the 2 such that: HEDLEV FICE CONCAT 000001 000001 000002 000002 000003 000003 000004 000004 000005 000005 000006 000006 000007 000007 000008 000008 etc. Please not that I did not do the obvious--turn them into numbers and simply add across, because I need to keep the 6-character structure (preceding zeros). This should be simple. What am I not remembering? Mark *************************************************************************************************************************************************************** Mark A. Davenport Ph.D. Senior Research Analyst Office of Institutional Research The University of North Carolina at Greensboro 336.256.0395 [hidden email] 'An approximate answer to the right question is worth a good deal more than an exact answer to an approximate question.' --a paraphrase of J. W. Tukey (1962) ===================== 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 |
|
Mark,
I'm going to guess you don't really want to concatenate the two fields. I'd suggest trying COMPUTE CONCAT=HEDLEV . IF (CONCAT= '') CONCAT=FICE . /* that's two apostrophes */ What you didn't show in your example was something like >HEDLEV FICE CONCAT >000009 000010 ????????????? Do you want CONCAT to be equal to 000009000010 or to 000009? My solution would give you the second result. The first result might be gotten by something like (untested) COMPUTE CONCAT=concat(RTRIM(HEDLEV),RTRIM(FICE)) . Catherine At 11/5/2007 02:54 PM, Mark A Davenport MADAVENP wrote: >All, > >I have a 6 character string var (HEDLEV) with many missing values. I have >another 6 character string (FICE) which fills in most of the missing >val;ues in the first string. I want to concatenate the 2 such that: > >HEDLEV FICE CONCAT >000001 000001 >000002 000002 > 000003 000003 >000004 000004 >000005 000005 > 000006 000006 > 000007 000007 >000008 000008 > >etc. > >Please not that I did not do the obvious--turn them into numbers and >simply add across, because I need to keep the 6-character structure >(preceding zeros). > >This should be simple. What am I not remembering? > >Mark > >*************************************************************************************************************************************************************** >Mark A. Davenport Ph.D. >Senior Research Analyst >Office of Institutional Research >The University of North Carolina at Greensboro >336.256.0395 >[hidden email] > >'An approximate answer to the right question is worth a good deal more >than an exact answer to an approximate question.' --a paraphrase of J. W. >Tukey (1962) > >===================== >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 Catherine Kubitschek ([hidden email]) Sr. Programmer/Analyst 574/631-3550 Institutional Research 210 Flanner Hall University of Notre Dame Notre Dame, IN 46556-5611 ===================== 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 |
|
In reply to this post by Mark A Davenport MADAVENP
I don't have SPSS running so I cannot test this.
string newstring (a6). compute newstring = max(HEDLEV, FICE). *or* string newstring(a6). do if hedlev eq ' '. compute newstring= fice. else. compute newstring= hedlev. end if. *or* if you did it as numbers you could always format the new variable to (N6). Art Kendall Social Research Consultants Mark A Davenport MADAVENP wrote: > All, > > I have a 6 character string var (HEDLEV) with many missing values. I have > another 6 character string (FICE) which fills in most of the missing > val;ues in the first string. I want to concatenate the 2 such that: > > HEDLEV FICE CONCAT > 000001 000001 > 000002 000002 > 000003 000003 > 000004 000004 > 000005 000005 > 000006 000006 > 000007 000007 > 000008 000008 > > etc. > > Please not that I did not do the obvious--turn them into numbers and > simply add across, because I need to keep the 6-character structure > (preceding zeros). > > This should be simple. What am I not remembering? > > Mark > > *************************************************************************************************************************************************************** > Mark A. Davenport Ph.D. > Senior Research Analyst > Office of Institutional Research > The University of North Carolina at Greensboro > 336.256.0395 > [hidden email] > > 'An approximate answer to the right question is worth a good deal more > than an exact answer to an approximate question.' --a paraphrase of J. W. > Tukey (1962) > > ===================== > 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 |
|
In reply to this post by Mark A Davenport MADAVENP
Mark,
here are two options. Best regards, Florio DATA LIST FIXED /HEDLEV 1-6 (A) FICE 7-12 (A). BEGIN DATA. 000001 000002 000003 000004 000005 000006 000007 000008 END DATA. STRING CONCAT1(A6). COMPUTE CONCAT1 = CONCAT(LTRIM(HEDLEV),LTRIM(FICE)). STRING CONCAT2(A6). IF HEDLEV NE '' CONCAT2 = HEDLEV. IF FICE NE '' CONCAT2 = FICE. EXECUTE. At 02:54 PM 11/5/2007, Mark A Davenport MADAVENP wrote: >All, > >I have a 6 character string var (HEDLEV) with many missing values. I have >another 6 character string (FICE) which fills in most of the missing >val;ues in the first string. I want to concatenate the 2 such that: > >HEDLEV FICE CONCAT >000001 000001 >000002 000002 > 000003 000003 >000004 000004 >000005 000005 > 000006 000006 > 000007 000007 >000008 000008 > >etc. > >Please not that I did not do the obvious--turn them into numbers and >simply add across, because I need to keep the 6-character structure >(preceding zeros). > >This should be simple. What am I not remembering? > >Mark > >*************************************************************************************************************************************************************** >Mark A. Davenport Ph.D. >Senior Research Analyst >Office of Institutional Research >The University of North Carolina at Greensboro >336.256.0395 >[hidden email] > >'An approximate answer to the right question is worth a good deal more >than an exact answer to an approximate question.' --a paraphrase of J. W. >Tukey (1962) > >===================== >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 |
|
In reply to this post by Mark A Davenport MADAVENP
At 09:54 AM 11/5/2007, Mark A Davenport MADAVENP wrote:
>All, > >I have a 6 character string var (HEDLEV) with many missing values. I have >another 6 character string (FICE) which fills in most of the missing >val;ues in the first string. I want to concatenate the 2 such that: > >HEDLEV FICE CONCAT >000001 000001 >000002 000002 > 000003 000003 >000004 000004 >000005 000005 > 000006 000006 > 000007 000007 >000008 000008 > >etc. > >Please not that I did not do the obvious--turn them into numbers and >simply add across, because I need to keep the 6-character structure >(preceding zeros). > >This should be simple. What am I not remembering? Doesn't look to me like you're concatenating. Is one of the two variables always blank? If so, you could use logic something like this (syntax may not be correct): COMPUTE CONCAT = HEDLEV . IF HEDLEV = ' ' THEN HEDLEV = FICE . Bob >Mark > >*************************************************************************************************************************************************************** >Mark A. Davenport Ph.D. >Senior Research Analyst >Office of Institutional Research >The University of North Carolina at Greensboro >336.256.0395 >[hidden email] > >'An approximate answer to the right question is worth a good deal more >than an exact answer to an approximate question.' --a paraphrase of J. W. >Tukey (1962) > >===================== >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 Robert M. Schacht, Ph.D. <[hidden email]> Pacific Basin Rehabilitation Research & Training Center 1268 Young Street, Suite #204 Research Center, University of Hawaii Honolulu, HI 96814 ===================== 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 |
|
I got several different but effective solutions. Thanks all!
Mark *************************************************************************************************************************************************************** Mark A. Davenport Ph.D. Senior Research Analyst Office of Institutional Research The University of North Carolina at Greensboro 336.256.0395 [hidden email] 'An approximate answer to the right question is worth a good deal more than an exact answer to an approximate question.' --a paraphrase of J. W. Tukey (1962) ===================== 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 |
| Free forum by Nabble | Edit this page |
