SPSSX Discussion

Recoding system missing with max value

Classic

List

Threaded

27 messages Options

David Marso

Re: Recoding system missing with max value

Administrator

min wrote

Hi David,

Since I am new in using syntax, I am not sure what is the code to your suggestion. If you don't mind, can you write the code for me.

Thanks a lot.

Look up AGGREGATE and MATCH and try to do it yourself.
Give a man a fish blah blah blah.

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"

Maguin, Eugene

Re: Recoding system missing with max value

In reply to this post by min

I should have asked this yesterday because I'm confused. You said you have test data and real data. Are both of those files spss system data files (i.e., they have a 'sav' extension)? If you know, what was the version numbers of spss that saved those files? (My understanding but maybe I'm wrong, is that spss system data files are backwards compatible. So, version 22, for instance, will read data files saved by much, much earlier versions of spss. Forward compatibility almost has to be bounded by Unicode.)

Let's talk about the version(s) of spss that you are using. Do you have one version or two versions of spss? What is(are) the version number(s)?

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min
Sent: Thursday, June 25, 2015 8:59 PM
To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

The real data is using spss 11.5. and yes, it does not work on my real data.
Do you have any other suggestion how to do this?

Thanks.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729964.html
Sent from the SPSSX Discussion mailing list archive at 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

min

Re: Recoding system missing with max value

Hi Gene,

The spss for my real data ( is using spss 11.5 and I have to generate the result only by using remote system and I can't see the data) that's the reason I have a test data (that why I generate myself to understand the way that the data was arranged) and my test data is using spss 21.

It is complicate to explain about my real data. So basically it is quite a problem for me to fine the right code for spss 11.5.

Yasmin

Sent from my Samsung device

-------- Original message --------
From: "Maguin, Eugene [via SPSSX Discussion]" <[hidden email]>
Date: 26/06/2015 11:01 pm (GMT+08:00)
To: min <[hidden email]>
Subject: Re: Recoding system missing with max value

I should have asked this yesterday because I'm confused. You said you have test data and real data. Are both of those files spss system data files (i.e., they have a 'sav' extension)? If you know, what was the version numbers of spss that saved those files? (My understanding but maybe I'm wrong, is that spss system data files are backwards compatible. So, version 22, for instance, will read data files saved by much, much earlier versions of spss. Forward compatibility almost has to be bounded by Unicode.)

Let's talk about the version(s) of spss that you are using. Do you have one version or two versions of spss? What is(are) the version number(s)?

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min
Sent: Thursday, June 25, 2015 8:59 PM
To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

The real data is using spss 11.5. and yes, it does not work on my real data.
Do you have any other suggestion how to do this?

Thanks.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729964.html
Sent from the SPSSX Discussion mailing list archive at 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

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729981.html

To unsubscribe from Recoding system missing with max value, click here.
NAML

Maguin, Eugene

Re: Recoding system missing with max value

What you just described greatly helps to understand the larger context of the problem.

To solve your problem, you have to write code that works on version 11.5. Correct me if I’m wrong but I believe that you already have this code courtesy of David or Bruce. When you run that code on the remote computer running 11.5 does the code work? If not, post the code used and the error(s) received. State clearly that the problem occurs when using version 11.5.

I don’t mean this question to be insulting but you made an example dataset that you used with your current spss version, does that dataset accurately represent the complexity in the remote dataset?

Gene Maguin

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min
Sent: Saturday, June 27, 2015 8:48 AM
To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

It is complicate to explain about my real data. So basically it is quite a problem for me to fine the right code for spss 11.5.

Yasmin

Sent from my Samsung device

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729981.html

To unsubscribe from Recoding system missing with max value, click here.
NAML

View this message in context: Re: Recoding system missing with max value
Sent from the SPSSX Discussion mailing list archive at 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

David Marso

Re: Recoding system missing with max value

Administrator

What I was trying to point 'min' to was something like.

REPLACING

AGGREGATE OUTFILE * MODE REPLACE VARIABLES..../ blah blah blah...
with

SORT CASES BY <break variables>.
AGGREGATE OUTFILE <some temporary file somewhere > / BREAK <break variables> / blah blah blah...
MATCH FILES / FILE * /TABLE <some temporary file somewhere > / BY <break variables> .

Of course a little RTFM before trying this might be quite efficacious (there is no < or > in the functional syntax) .

Maguin, Eugene wrote

What you just described greatly helps to understand the larger context of the problem.
To solve your problem, you have to write code that works on version 11.5. Correct me if I'm wrong but I believe that you already have this code courtesy of David or Bruce. When you run that code on the remote computer running 11.5 does the code work? If not, post the code used and the error(s) received. State clearly that the problem occurs when using version 11.5.
I don't mean this question to be insulting but you made an example dataset that you used with your current spss version, does that dataset accurately represent the complexity in the remote dataset?
Gene Maguin

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min
Sent: Saturday, June 27, 2015 8:48 AM
To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

The spss for my real data ( is using spss 11.5 and I have to generate the result only by using remote system and I can't see the data) that's the reason I have a test data (that why I generate myself to understand the way that the data was arranged) and my test data is using spss 21.

It is complicate to explain about my real data. So basically it is quite a problem for me to fine the right code for spss 11.5.

Yasmin

Sent from my Samsung device

-------- Original message --------
From: "Maguin, Eugene [via SPSSX Discussion]" <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=0>>
Date: 26/06/2015 11:01 pm (GMT+08:00)
To: min <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=1>>
Subject: Re: Recoding system missing with max value

I should have asked this yesterday because I'm confused. You said you have test data and real data. Are both of those files spss system data files (i.e., they have a 'sav' extension)? If you know, what was the version numbers of spss that saved those files? (My understanding but maybe I'm wrong, is that spss system data files are backwards compatible. So, version 22, for instance, will read data files saved by much, much earlier versions of spss. Forward compatibility almost has to be bounded by Unicode.)

Let's talk about the version(s) of spss that you are using. Do you have one version or two versions of spss? What is(are) the version number(s)?

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=0>] On Behalf Of min
Sent: Thursday, June 25, 2015 8:59 PM
To: [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=1>
Subject: Re: Recoding system missing with max value

Hi Gene,

The real data is using spss 11.5. and yes, it does not work on my real data.
Do you have any other suggestion how to do this?

Thanks.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729964.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=2> (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]</user/SendEmail.jtp?type=node&node=5729981&i=3> (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

________________________________
If you reply to this email, your message will be added to the discussion below:
http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729981.html
To unsubscribe from Recoding system missing with max value, click here.
NAML<http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________
View this message in context: Re: Recoding system missing with max value<http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729985.html>
Sent from the SPSSX Discussion mailing list archive<http://spssx-discussion.1045642.n5.nabble.com/> at Nabble.com.
===================== To manage your subscription to SPSSX-L, send a message to [hidden email]<mailto:[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

min

Re: Recoding system missing with max value

Hi David

Unfortunately the code that you give doesn't work too.

Sent from my Samsung device

-------- Original message --------
From: "David Marso [via SPSSX Discussion]" <[hidden email]>
Date: 29/06/2015 10:22 pm (GMT+08:00)
To: min <[hidden email]>
Subject: Re: Recoding system missing with max value

What I was trying to point 'min' to was something like.

REPLACING

AGGREGATE OUTFILE * MODE REPLACE VARIABLES..../ blah blah blah...
with

SORT CASES BY <break variables>.
AGGREGATE OUTFILE <some temporary file somewhere > / BREAK <break variables> / blah blah blah...
MATCH FILES / FILE * /TABLE <some temporary file somewhere > / BY <break variables> .

Of course a little RTFM before trying this might be quite efficacious (there is no < or > in the functional syntax) .

Maguin, Eugene wrote

What you just described greatly helps to understand the larger context of the problem.
To solve your problem, you have to write code that works on version 11.5. Correct me if I'm wrong but I believe that you already have this code courtesy of David or Bruce. When you run that code on the remote computer running 11.5 does the code work? If not, post the code used and the error(s) received. State clearly that the problem occurs when using version 11.5.
I don't mean this question to be insulting but you made an example dataset that you used with your current spss version, does that dataset accurately represent the complexity in the remote dataset?
Gene Maguin

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min
Sent: Saturday, June 27, 2015 8:48 AM
To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

The spss for my real data ( is using spss 11.5 and I have to generate the result only by using remote system and I can't see the data) that's the reason I have a test data (that why I generate myself to understand the way that the data was arranged) and my test data is using spss 21.

It is complicate to explain about my real data. So basically it is quite a problem for me to fine the right code for spss 11.5.

Yasmin

Sent from my Samsung device

-------- Original message --------
From: "Maguin, Eugene [via SPSSX Discussion]" <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=0>>
Date: 26/06/2015 11:01 pm (GMT+08:00)
To: min <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=1>>
Subject: Re: Recoding system missing with max value

I should have asked this yesterday because I'm confused. You said you have test data and real data. Are both of those files spss system data files (i.e., they have a 'sav' extension)? If you know, what was the version numbers of spss that saved those files? (My understanding but maybe I'm wrong, is that spss system data files are backwards compatible. So, version 22, for instance, will read data files saved by much, much earlier versions of spss. Forward compatibility almost has to be bounded by Unicode.)

Let's talk about the version(s) of spss that you are using. Do you have one version or two versions of spss? What is(are) the version number(s)?

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=0>] On Behalf Of min
Sent: Thursday, June 25, 2015 8:59 PM
To: [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=1>
Subject: Re: Recoding system missing with max value

Hi Gene,

The real data is using spss 11.5. and yes, it does not work on my real data.
Do you have any other suggestion how to do this?

Thanks.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729964.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=2> (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]</user/SendEmail.jtp?type=node&node=5729981&i=3> (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

________________________________
If you reply to this email, your message will be added to the discussion below:
http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729981.html
To unsubscribe from Recoding system missing with max value, click here.
NAML<http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________
View this message in context: Re: Recoding system missing with max value<http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729985.html>
Sent from the SPSSX Discussion mailing list archive<http://spssx-discussion.1045642.n5.nabble.com/> at Nabble.com.
===================== To manage your subscription to SPSSX-L, send a message to [hidden email]<mailto:[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

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729999.html

To unsubscribe from Recoding system missing with max value, click here.
NAML

David Marso

Re: Recoding system missing with max value

Administrator

You REALLY NEED TO ELABORATE!!!!!!
You have not even definitively convinced us of what version of SPSS you are using.
If you want any further assistance you need to back up and post
EXACTLY the code you are running and any error messages, version of SPSS .
In fact, start from the beginning and restate the question.
What have you tried?
Why is it that you can't see the data?
Maybe try LIST command?

---------------------

min wrote

Hi David
Unfortunately the code that you give doesn't work too.

Sent from my Samsung device

-------- Original message --------
From: "David Marso [via SPSSX Discussion]" <[hidden email]>
Date: 29/06/2015 10:22 pm (GMT+08:00)
To: min <[hidden email]>
Subject: Re: Recoding system missing with max value

What I was trying to point 'min' to was something like.

REPLACING

AGGREGATE OUTFILE * MODE REPLACE VARIABLES..../ blah blah blah...

with

SORT CASES BY <break variables>.

AGGREGATE OUTFILE <some temporary file somewhere > / BREAK <break variables> / blah blah blah...

MATCH FILES / FILE * /TABLE <some temporary file somewhere > / BY <break variables> .

Of course a little RTFM before trying this might be quite efficacious (there is no < or > in the functional syntax) .

Maguin, Eugene wrote
What you just described greatly helps to understand the larger context of the problem.

To solve your problem, you have to write code that works on version 11.5. Correct me if I'm wrong but I believe that you already have this code courtesy of David or Bruce. When you run that code on the remote computer running 11.5 does the code work? If not, post the code used and the error(s) received. State clearly that the problem occurs when using version 11.5.

I don't mean this question to be insulting but you made an example dataset that you used with your current spss version, does that dataset accurately represent the complexity in the remote dataset?

Gene Maguin

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of min

Sent: Saturday, June 27, 2015 8:48 AM

To: [hidden email]
Subject: Re: Recoding system missing with max value

Hi Gene,

The spss for my real data ( is using spss 11.5 and I have to generate the result only by using remote system and I can't see the data) that's the reason I have a test data (that why I generate myself to understand the way that the data was arranged) and my test data is using spss 21.

It is complicate to explain about my real data. So basically it is quite a problem for me to fine the right code for spss 11.5.

Yasmin

Sent from my Samsung device

-------- Original message --------

From: "Maguin, Eugene [via SPSSX Discussion]" <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=0>>

Date: 26/06/2015 11:01 pm (GMT+08:00)

To: min <[hidden email]</user/SendEmail.jtp?type=node&node=5729985&i=1>>

Subject: Re: Recoding system missing with max value

I should have asked this yesterday because I'm confused. You said you have test data and real data. Are both of those files spss system data files (i.e., they have a 'sav' extension)? If you know, what was the version numbers of spss that saved those files? (My understanding but maybe I'm wrong, is that spss system data files are backwards compatible. So, version 22, for instance, will read data files saved by much, much earlier versions of spss. Forward compatibility almost has to be bounded by Unicode.)

Let's talk about the version(s) of spss that you are using. Do you have one version or two versions of spss? What is(are) the version number(s)?

Gene Maguin

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

From: SPSSX(r) Discussion [mailto:[hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=0>] On Behalf Of min

Sent: Thursday, June 25, 2015 8:59 PM

To: [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=1>

Subject: Re: Recoding system missing with max value

Hi Gene,

The real data is using spss 11.5. and yes, it does not work on my real data.

Do you have any other suggestion how to do this?

Thanks.

--

View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729964.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================

To manage your subscription to SPSSX-L, send a message to [hidden email]</user/SendEmail.jtp?type=node&node=5729981&i=2> (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]</user/SendEmail.jtp?type=node&node=5729981&i=3> (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

________________________________

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729981.html
To unsubscribe from Recoding system missing with max value, click here.

NAML<http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________

View this message in context: Re: Recoding system missing with max value<http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729985.html>
Sent from the SPSSX Discussion mailing list archive<http://spssx-discussion.1045642.n5.nabble.com/> at Nabble.com.

===================== To manage your subscription to SPSSX-L, send a message to [hidden email]<mailto:[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

Please reply to the list and not to my personal email.

Those desiring my consulting or training services please feel free to email me.

---

"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."

Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"

If you reply to this email, your message will be added to the discussion below:
http://spssx-discussion.1045642.n5.nabble.com/Recoding-system-missing-with-max-value-tp5729895p5729999.html

To unsubscribe from Recoding system missing with max value, click here.

NAML