SPSSX Discussion

get data command questions

Classic

List

Threaded

17 messages Options

Maguin, Eugene

get data command questions

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

datatypemin percentage=95.0/

variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

>Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required. <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

"DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

Rick Oliver

Re: get data command questions

The colon in the error message is misleading and will probably cause an error if you include it in your syntax. Other than that, I can't shed any light on the issue, since your syntax looks correct to me.

The colon is just meant to separate the subcommand name from the error condition.

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

spss.giesel@yahoo.de

Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel
Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

Maguin, Eugene

Re: get data command questions

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

spss.giesel@yahoo.de

Re: get data command questions

Yes, but the slash might mean "divided by"

Mario Giesel
Munich, Germany

Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <[hidden email]> Folgendes geschrieben:

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

Jon Peck

Re: get data command questions

I don't think so. The keyword does not take expressions.

On Thu, May 2, 2019 at 2:16 PM Mario Giesel <[hidden email]> wrote:

Yes, but the slash might mean "divided by"

Mario Giesel
Munich, Germany

Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <[hidden email]> Folgendes geschrieben:

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

The colon in the error message is misleading and will probably cause an error if you include it in your syntax. Other than that, I can't shed any light on the issue, since your syntax looks correct to me.

The colon is just meant to separate the subcommand name from the error condition.

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

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

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

Jon K Peck
[hidden email]

MLIves

Re: get data command questions

I wonder if it is a command layout question.

When I copied the original order into SPSS v25 syntax, neither the /DELIMITERS line nor the /DATATYPEMIN line were color-coded as expected.

I’ve had trouble when this happened.

Would it work using a version with old-style formatting were everything color-coded as expected?

GET DATA /TYPE=TXT

/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"

/DELCASE=LINE

/DELIMITERS="#"

/ARRANGEMENT=DELIMITED

/FIRSTCASE=2

/DATATYPEMIN PERCENTAGE=95.0

/VARIABLES=ExcelFileName AUTO Labelname AUTO Variable AUTO ValueLabels AUTO.

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jon Peck
Sent: Thursday, May 02, 2019 4:24 PM
To: [hidden email]
Subject: Re: [SPSSX-L] get data command questions

I don't think so. The keyword does not take expressions.

On Thu, May 2, 2019 at 2:16 PM Mario Giesel <[hidden email]> wrote:

Yes, but the slash might mean "divided by"

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <[hidden email]> Folgendes geschrieben:

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

The colon in the error message is misleading and will probably cause an error if you include it in your syntax. Other than that, I can't shed any light on the issue, since your syntax looks correct to me.

The colon is just meant to separate the subcommand name from the error condition.

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

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

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

Jon K Peck
[hidden email]

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

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

Maguin, Eugene

Re: get data command questions

In reply to this post by Jon Peck

This is truly amazing! So amazing, it’s so surprising; it’s worth laughing about.

From yesterday, this did not work and showed the described error.

get data /TYPE=TXT/file='C:\Users\emaguin\Box\U\Chris StVil\'+

'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/

delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/

datatypemin percentage=95.0/

variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.

Execution of this command stops.

execute.

Error # 105. Command name: execute

This command is not valid before a working file has been defined.

Execution of this command stops.

However, this does work. So the problem is that “datatypemin percentage” must be in caps. Gotta wonder how that specific subcommand got treated differently from the other subcommands making up the get data command.

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/

delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/

DATATYPEMIN PERCENTAGE=95.0/

variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

While I’m at it, I’d like to ask about the operation of the setting controlling placement of syntax pasted from the menu system. I think it’s only controlled in the Edit > Options > Syntax Editor: “Paste syntax from dialogs” but maybe it’s also controlled someplace else. My setting is “At cursor or selection”. Yesterday, when I trying to figure out the get data problem, I found that pasting the get data command syntax placed the pasted syntax at the bottom of the file even though the cursor was placed a couple of lines below the previous syntax statement that was located near the top of the file.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Jon Peck
Sent: Thursday, May 2, 2019 4:24 PM
To: [hidden email]
Subject: Re: get data command questions

I don't think so. The keyword does not take expressions.

On Thu, May 2, 2019 at 2:16 PM Mario Giesel <[hidden email]> wrote:

Yes, but the slash might mean "divided by"

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <[hidden email]> Folgendes geschrieben:

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

The colon in the error message is misleading and will probably cause an error if you include it in your syntax. Other than that, I can't shed any light on the issue, since your syntax looks correct to me.

The colon is just meant to separate the subcommand name from the error condition.

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

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

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

Jon K Peck
[hidden email]

Rick Oliver

Re: get data command questions

The all caps thing is definitely a bug. Syntax is case insensitive.

On Fri, May 3, 2019, 9:20 AM Maguin, Eugene <[hidden email]> wrote:

This is truly amazing! So amazing, it’s so surprising; it’s worth laughing about.

From yesterday, this did not work and showed the described error.

get data /TYPE=TXT/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/

   delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.

Execution of this command stops.

execute.

Error # 105. Command name: execute

This command is not valid before a working file has been defined.

Execution of this command stops.

However, this does work. So the problem is that “datatypemin percentage” must be in caps. Gotta wonder how that specific subcommand got treated differently from the other subcommands making up the get data command.

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/

   delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/

   DATATYPEMIN PERCENTAGE=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

While I’m at it, I’d like to ask about the operation of the setting controlling placement of syntax pasted from the menu system. I think it’s only controlled in the Edit > Options > Syntax Editor: “Paste syntax from dialogs” but maybe it’s also controlled someplace else. My setting is “At cursor or selection”. Yesterday, when I trying to figure out the get data problem, I found that pasting the get data command syntax placed the pasted syntax at the bottom of the file even though the cursor was placed a couple of lines below the previous syntax statement that was located near the top of the file.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Jon Peck
Sent: Thursday, May 2, 2019 4:24 PM
To: [hidden email]
Subject: Re: get data command questions

I don't think so. The keyword does not take expressions.

On Thu, May 2, 2019 at 2:16 PM Mario Giesel <[hidden email]> wrote:

Yes, but the slash might mean "divided by"

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <[hidden email]> Folgendes geschrieben:

I understand your question but I think the answer is No because when I go through the menu system, 95.0 is the default value.

Gene Maguin

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Mario Giesel
Sent: Thursday, May 2, 2019 3:15 PM
To: [hidden email]
Subject: Re: get data command questions

Is it possible that

datatypemin percentage=95.0/

causes the error? The command might interpret it as the beginning of a fraction.

Mario Giesel

Munich, Germany

Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <[hidden email]> Folgendes geschrieben:

The colon in the error message is misleading and will probably cause an error if you include it in your syntax. Other than that, I can't shed any light on the issue, since your syntax looks correct to me.

The colon is just meant to separate the subcommand name from the error condition.

On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <[hidden email]> wrote:

Having been here before, I may be making a mistake that I can’t see.

That said, I thought I’d try to write a get data command for a text file with the variable names in line 1 and first case in line 2 – to see if I could do because I routinely have trouble with it.

This is what I wrote

get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+

   'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/

   firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/

   datatypemin percentage=95.0/

   variables=ExcelFileName auto LabelName auto Variable auto ValueLabels auto.

execute.

I get this error.

    >Error. Command name: get data

(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.    <<< notice the colon!!

Execution of this command stops.

execute.

So, I went through the file -> import data menu system and pasted the syntax. This works but to my eye they are exactly the same except for subcommand order.

GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris StVil\ProjectChange\"+

   "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/

   DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/

   DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO

   Variable AUTO ValueLabels AUTO.

EXECUTE.

So probably something I’m doing but I don’t see it. Help please.

Thanks, Gene Maguin

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

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

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

--

Jon K Peck
[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

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

Bruce Weaver

Re: get data command questions

Administrator

In reply to this post by Maguin, Eugene

Confirmed! I just generated a GET DATA command via the GUI, but then
replaced

/DATATYPEMIN PERCENTAGE=95.0

with

/datatypemin percentage=95.0

The result was this error message:

>Error. Command name: GET DATA
>(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.
>Execution of this command stops.

When I reverted to /DATATYPEMIN PERCENTAGE=95.0, it worked just fine.

Good catch, Gene.

Maguin, Eugene wrote

> This is truly amazing! So amazing, it’s so surprising; it’s worth laughing
> about.
> From yesterday, this did not work and showed the described error.
>
>
> get data /TYPE=TXT/file='C:\Users\emaguin\Box\U\Chris StVil\'+
> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/
> delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/
> datatypemin percentage=95.0/
> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
> auto.
>
> Error. Command name: get data
> (2295) Subcommand DATATYPEMIN: PERCENTAGE is required.
> Execution of this command stops.
> execute.
>
> Error # 105. Command name: execute
> This command is not valid before a working file has been defined.
> Execution of this command stops.
>
>
> However, this does work. So the problem is that “datatypemin percentage”
> must be in caps. Gotta wonder how that specific subcommand got treated
> differently from the other subcommands making up the get data command.
>
>
> get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+
> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/
> delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/
> DATATYPEMIN PERCENTAGE=95.0/
> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
> auto.
> execute.
>
>
> While I’m at it, I’d like to ask about the operation of the setting
> controlling placement of syntax pasted from the menu system. I think it’s
> only controlled in the Edit > Options > Syntax Editor: “Paste syntax from
> dialogs” but maybe it’s also controlled someplace else. My setting is “At
> cursor or selection”. Yesterday, when I trying to figure out the get data
> problem, I found that pasting the get data command syntax placed the
> pasted syntax at the bottom of the file even though the cursor was placed
> a couple of lines below the previous syntax statement that was located
> near the top of the file.
>
> Gene Maguin
>
>
>
>
> From: SPSSX(r) Discussion <

> SPSSX-L@.UGA

> > On Behalf Of Jon Peck
> Sent: Thursday, May 2, 2019 4:24 PM
> To:

> SPSSX-L@.UGA

> Subject: Re: get data command questions
>
> I don't think so. The keyword does not take expressions.
>
> On Thu, May 2, 2019 at 2:16 PM Mario Giesel <

> 0000055bfbeaad14-dmarc-request@.uga

> <mailto:

> 0000055bfbeaad14-dmarc-request@.uga

> >> wrote:
> Yes, but the slash might mean "divided by"
>
> Mario Giesel
> Munich, Germany
>
>
> Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <

> emaguin@

> <mailto:

> emaguin@

> >> Folgendes geschrieben:
>
>
>
> I understand your question but I think the answer is No because when I go
> through the menu system, 95.0 is the default value.
>
> Gene Maguin
>
>
>
> From: SPSSX(r) Discussion <

> SPSSX-L@.UGA

> <mailto:

> SPSSX-L@.UGA

> >> On Behalf Of Mario Giesel
> Sent: Thursday, May 2, 2019 3:15 PM
> To:

> SPSSX-L@.UGA

> <mailto:

> SPSSX-L@.UGA

> >
> Subject: Re: get data command questions
>
>
>
> Is it possible that
>
>
>
> datatypemin percentage=95.0/
>
>
>
> causes the error? The command might interpret it as the beginning of a
> fraction.
>
>
>
> Mario Giesel
>
> Munich, Germany
>
>
>
>
>
> Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <

> richard.oliver.444@

> <mailto:

> richard.oliver.444@

> >> Folgendes geschrieben:
>
>
>
>
>
> The colon in the error message is misleading and will probably cause an
> error if you include it in your syntax. Other than that, I can't shed any
> light on the issue, since your syntax looks correct to me.
>
> The colon is just meant to separate the subcommand name from the error
> condition.
>
>
>
> On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <

> emaguin@

> <mailto:

> emaguin@

> >> wrote:
>
> Having been here before, I may be making a mistake that I can’t see.
>
> That said, I thought I’d try to write a get data command for a text file
> with the variable names in line 1 and first case in line 2 – to see if I
> could do because I routinely have trouble with it.
>
> This is what I wrote
>
>
>
> get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+
>
> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/
>
> firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/
>
> datatypemin percentage=95.0/
>
> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
> auto.
>
> execute.
>
>
>
> I get this error.
>
>
>
> >Error. Command name: get data
>
> (2295) Subcommand DATATYPEMIN: PERCENTAGE is required. <<< notice the
> colon!!
>
> Execution of this command stops.
>
> execute.
>
>
>
> So, I went through the file -> import data menu system and pasted the
> syntax. This works but to my eye they are exactly the same except for
> subcommand order.
>
>
>
>
>
> GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris
> StVil\ProjectChange\"+
>
> "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/
>
> DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/
>
> DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname AUTO
>
> Variable AUTO ValueLabels AUTO.
>
> EXECUTE.
>
>
>
> So probably something I’m doing but I don’t see it. Help please.
>
>
>
> Thanks, Gene Maguin
>
> ===================== To manage your subscription to SPSSX-L, send a
> message to

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

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

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

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

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

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

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

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

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

> > (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
>
>
> --
> Jon K Peck

> jkpeck@

> <mailto:

> jkpeck@

> >
> ===================== To manage your subscription to SPSSX-L, send a
> message to

> LISTSERV@.UGA

> <mailto:

> LISTSERV@.UGA

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

> LISTSERV@.UGA

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

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).

David Marso

Re: get data command questions

Administrator

Quite ODD. I was going to suggest case sensitivity but rejected that as
utterly absurd.
Didn't even try it but that seems to be the CASE. [pun intentional].
--

Bruce Weaver wrote

> Confirmed! I just generated a GET DATA command via the GUI, but then
> replaced
>
> /DATATYPEMIN PERCENTAGE=95.0
>
> with
>
> /datatypemin percentage=95.0
>
> The result was this error message:
>
>>Error. Command name: GET DATA
>>(2295) Subcommand DATATYPEMIN: PERCENTAGE is required.
>>Execution of this command stops.
>
> When I reverted to /DATATYPEMIN PERCENTAGE=95.0, it worked just fine.
>
> Good catch, Gene.
>
>
>
> Maguin, Eugene wrote
>> This is truly amazing! So amazing, it’s so surprising; it’s worth
>> laughing
>> about.
>> From yesterday, this did not work and showed the described error.
>>
>>
>> get data /TYPE=TXT/file='C:\Users\emaguin\Box\U\Chris StVil\'+
>> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/
>> delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/
>> datatypemin percentage=95.0/
>> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
>> auto.
>>
>> Error. Command name: get data
>> (2295) Subcommand DATATYPEMIN: PERCENTAGE is required.
>> Execution of this command stops.
>> execute.
>>
>> Error # 105. Command name: execute
>> This command is not valid before a working file has been defined.
>> Execution of this command stops.
>>
>>
>> However, this does work. So the problem is that “datatypemin percentage”
>> must be in caps. Gotta wonder how that specific subcommand got treated
>> differently from the other subcommands making up the get data command.
>>
>>
>> get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+
>> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1.txt'/
>> delcase=line/delimiters="#"/arrangement=delimited/firstcase=2/
>> DATATYPEMIN PERCENTAGE=95.0/
>> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
>> auto.
>> execute.
>>
>>
>> While I’m at it, I’d like to ask about the operation of the setting
>> controlling placement of syntax pasted from the menu system. I think it’s
>> only controlled in the Edit > Options > Syntax Editor: “Paste syntax from
>> dialogs” but maybe it’s also controlled someplace else. My setting is “At
>> cursor or selection”. Yesterday, when I trying to figure out the get data
>> problem, I found that pasting the get data command syntax placed the
>> pasted syntax at the bottom of the file even though the cursor was placed
>> a couple of lines below the previous syntax statement that was located
>> near the top of the file.
>>
>> Gene Maguin
>>
>>
>>
>>
>> From: SPSSX(r) Discussion <
>
>> SPSSX-L@.UGA
>
>> > On Behalf Of Jon Peck
>> Sent: Thursday, May 2, 2019 4:24 PM
>> To:
>
>> SPSSX-L@.UGA
>
>> Subject: Re: get data command questions
>>
>> I don't think so. The keyword does not take expressions.
>>
>> On Thu, May 2, 2019 at 2:16 PM Mario Giesel <
>
>> 0000055bfbeaad14-dmarc-request@.uga
>
>> <mailto:
>
>> 0000055bfbeaad14-dmarc-request@.uga
>
>> >> wrote:
>> Yes, but the slash might mean "divided by"
>>
>> Mario Giesel
>> Munich, Germany
>>
>>
>> Am Donnerstag, 2. Mai 2019, 21:53:22 MESZ hat Maguin, Eugene <
>
>> emaguin@
>
>> <mailto:
>
>> emaguin@
>
>> >> Folgendes geschrieben:
>>
>>
>>
>> I understand your question but I think the answer is No because when I go
>> through the menu system, 95.0 is the default value.
>>
>> Gene Maguin
>>
>>
>>
>> From: SPSSX(r) Discussion <
>
>> SPSSX-L@.UGA
>
>> <mailto:
>
>> SPSSX-L@.UGA
>
>> >> On Behalf Of Mario Giesel
>> Sent: Thursday, May 2, 2019 3:15 PM
>> To:
>
>> SPSSX-L@.UGA
>
>> <mailto:
>
>> SPSSX-L@.UGA
>
>> >
>> Subject: Re: get data command questions
>>
>>
>>
>> Is it possible that
>>
>>
>>
>> datatypemin percentage=95.0/
>>
>>
>>
>> causes the error? The command might interpret it as the beginning of a
>> fraction.
>>
>>
>>
>> Mario Giesel
>>
>> Munich, Germany
>>
>>
>>
>>
>>
>> Am Donnerstag, 2. Mai 2019, 20:05:03 MESZ hat Rick Oliver <
>
>> richard.oliver.444@
>
>> <mailto:
>
>> richard.oliver.444@
>
>> >> Folgendes geschrieben:
>>
>>
>>
>>
>>
>> The colon in the error message is misleading and will probably cause an
>> error if you include it in your syntax. Other than that, I can't shed any
>> light on the issue, since your syntax looks correct to me.
>>
>> The colon is just meant to separate the subcommand name from the error
>> condition.
>>
>>
>>
>> On Thu, May 2, 2019 at 12:19 PM Maguin, Eugene <
>
>> emaguin@
>
>> <mailto:
>
>> emaguin@
>
>> >> wrote:
>>
>> Having been here before, I may be making a mistake that I can’t see.
>>
>> That said, I thought I’d try to write a get data command for a text file
>> with the variable names in line 1 and first case in line 2 – to see if I
>> could do because I routinely have trouble with it.
>>
>> This is what I wrote
>>
>>
>>
>> get data /type=txt/file='C:\Users\emaguin\Box\U\Chris StVil\'+
>>
>> 'ProjectChange\DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt'/
>>
>> firstcase=2/delcase=line/delimiters="#"/arrangement=delimited/
>>
>> datatypemin percentage=95.0/
>>
>> variables=ExcelFileName auto LabelName auto Variable auto ValueLabels
>> auto.
>>
>> execute.
>>
>>
>>
>> I get this error.
>>
>>
>>
>> >Error. Command name: get data
>>
>> (2295) Subcommand DATATYPEMIN: PERCENTAGE is required. <<< notice the
>> colon!!
>>
>> Execution of this command stops.
>>
>> execute.
>>
>>
>>
>> So, I went through the file -> import data menu system and pasted the
>> syntax. This works but to my eye they are exactly the same except for
>> subcommand order.
>>
>>
>>
>>
>>
>> GET DATA /TYPE=TXT/FILE="C:\Users\emaguin\Box\U\Chris
>> StVil\ProjectChange\"+
>>
>> "DataDoc\Project CHANGE_ValueLabelKey_042919.Mod1a.txt"/DELCASE=LINE/
>>
>> DELIMITERS="#"/ARRANGEMENT=DELIMITED/FIRSTCASE=2/
>>
>> DATATYPEMIN PERCENTAGE=95.0/VARIABLES=ExcelFileName AUTO Labelname
>> AUTO
>>
>> Variable AUTO ValueLabels AUTO.
>>
>> EXECUTE.
>>
>>
>>
>> So probably something I’m doing but I don’t see it. Help please.
>>
>>
>>
>> Thanks, Gene Maguin
>>
>> ===================== To manage your subscription to SPSSX-L, send a
>> message to
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>>
>>
>> --
>> Jon K Peck
>
>> jkpeck@
>
>> <mailto:
>
>> jkpeck@
>
>> >
>> ===================== To manage your subscription to SPSSX-L, send a
>> message to
>
>> LISTSERV@.UGA
>
>> <mailto:
>
>> LISTSERV@.UGA
>
>> > (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
>
>> LISTSERV@.UGA
>
>> (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
>
>
>
>
>
> -----
> --
> Bruce Weaver

> bweaver@

> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

> (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?"
--
Sent from: http://spssx-discussion.1045642.n5.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

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?"

Bruce Weaver

Re: get data command questions

Administrator

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

Rick Oliver

Re: get data command questions

I have reported this to the IBM SPSS Statistics QA team. It's definitely a bug. I know because I designed the feature and the syntax -- and a keyword that must be specified in all caps violates the basic syntax rules of the application.

On Fri, May 3, 2019 at 12:58 PM Bruce Weaver <[hidden email]> wrote:

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

Maguin, Eugene

Re: get data command questions

Rick, Thank you for that.

May I ask for a comment on my question about insertion point control of pasted syntax. Thanks.

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Rick Oliver
Sent: Friday, May 3, 2019 2:42 PM
To: [hidden email]
Subject: Re: get data command questions

On Fri, May 3, 2019 at 12:58 PM Bruce Weaver <[hidden email]> wrote:

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

Rick Oliver

Re: get data command questions

Official disclaimer:

I no longer work for IBM, and I didn't work directly on the any of the syntax editor features.

That said, AFAIK, the insertion point for syntax pasted from dialogs is controlled only by changing the selected option in Edit>Options>Syntax Editor, and it usually works as I would expect...with some exceptions. Most notably, file access commands like GET and GET DATA. I suspect this is designed behavior, although I don't know the rationale.

On Fri, May 3, 2019 at 2:11 PM Maguin, Eugene <[hidden email]> wrote:

Rick, Thank you for that.

May I ask for a comment on my question about insertion point control of pasted syntax. Thanks.

While I’m at it, I’d like to ask about the operation of the setting controlling placement of syntax pasted from the menu system. I think it’s only controlled in the Edit > Options > Syntax Editor: “Paste syntax from dialogs” but maybe it’s also controlled someplace else. My setting is “At cursor or selection”. Yesterday, when I trying to figure out the get data problem, I found that pasting the get data command syntax placed the pasted syntax at the bottom of the file even though the cursor was placed a couple of lines below the previous syntax statement that was located near the top of the file.

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Rick Oliver
Sent: Friday, May 3, 2019 2:42 PM
To: [hidden email]
Subject: Re: get data command questions

I have reported this to the IBM SPSS Statistics QA team. It's definitely a bug. I know because I designed the feature and the syntax -- and a keyword that must be specified in all caps violates the basic syntax rules of the application.

On Fri, May 3, 2019 at 12:58 PM Bruce Weaver <[hidden email]> wrote:

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

Rick Oliver

Re: get data command questions

I should clarify that the exception is that file access commands like GET and GET DATA always seem to get pasted to the bottom of the syntax editor window, regardless of the setting for insertion point for syntax pasted from dialogs.

On Fri, May 3, 2019 at 2:31 PM Rick Oliver <[hidden email]> wrote:

Official disclaimer:

I no longer work for IBM, and I didn't work directly on the any of the syntax editor features.

That said, AFAIK, the insertion point for syntax pasted from dialogs is controlled only by changing the selected option in Edit>Options>Syntax Editor, and it usually works as I would expect...with some exceptions. Most notably, file access commands like GET and GET DATA. I suspect this is designed behavior, although I don't know the rationale.

On Fri, May 3, 2019 at 2:11 PM Maguin, Eugene <[hidden email]> wrote:

Rick, Thank you for that.

May I ask for a comment on my question about insertion point control of pasted syntax. Thanks.

While I’m at it, I’d like to ask about the operation of the setting controlling placement of syntax pasted from the menu system. I think it’s only controlled in the Edit > Options > Syntax Editor: “Paste syntax from dialogs” but maybe it’s also controlled someplace else. My setting is “At cursor or selection”. Yesterday, when I trying to figure out the get data problem, I found that pasting the get data command syntax placed the pasted syntax at the bottom of the file even though the cursor was placed a couple of lines below the previous syntax statement that was located near the top of the file.

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Rick Oliver
Sent: Friday, May 3, 2019 2:42 PM
To: [hidden email]
Subject: Re: get data command questions

I have reported this to the IBM SPSS Statistics QA team. It's definitely a bug. I know because I designed the feature and the syntax -- and a keyword that must be specified in all caps violates the basic syntax rules of the application.

On Fri, May 3, 2019 at 12:58 PM Bruce Weaver <[hidden email]> wrote:

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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

Maguin, Eugene

Re: get data command questions

Yes, I understand re IBM. Thank you for the comment. Gene Maguin

From: Rick Oliver <[hidden email]>
Sent: Friday, May 3, 2019 3:43 PM
To: Maguin, Eugene <[hidden email]>
Cc: [hidden email]
Subject: Re: get data command questions

On Fri, May 3, 2019 at 2:31 PM Rick Oliver <[hidden email]> wrote:

Official disclaimer:

I no longer work for IBM, and I didn't work directly on the any of the syntax editor features.

That said, AFAIK, the insertion point for syntax pasted from dialogs is controlled only by changing the selected option in Edit>Options>Syntax Editor, and it usually works as I would expect...with some exceptions. Most notably, file access commands like GET and GET DATA. I suspect this is designed behavior, although I don't know the rationale.

On Fri, May 3, 2019 at 2:11 PM Maguin, Eugene <[hidden email]> wrote:

Rick, Thank you for that.

May I ask for a comment on my question about insertion point control of pasted syntax. Thanks.

While I’m at it, I’d like to ask about the operation of the setting controlling placement of syntax pasted from the menu system. I think it’s only controlled in the Edit > Options > Syntax Editor: “Paste syntax from dialogs” but maybe it’s also controlled someplace else. My setting is “At cursor or selection”. Yesterday, when I trying to figure out the get data problem, I found that pasting the get data command syntax placed the pasted syntax at the bottom of the file even though the cursor was placed a couple of lines below the previous syntax statement that was located near the top of the file.

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Rick Oliver
Sent: Friday, May 3, 2019 2:42 PM
To: [hidden email]
Subject: Re: get data command questions

I have reported this to the IBM SPSS Statistics QA team. It's definitely a bug. I know because I designed the feature and the syntax -- and a keyword that must be specified in all caps violates the basic syntax rules of the application.

On Fri, May 3, 2019 at 12:58 PM Bruce Weaver <[hidden email]> wrote:

Yes, very odd indeed. I still had my syntax from the earlier post, so tried
three more variations, all of which failed.

/Datatypemin Percentage=95.0
/DATATYPEMIn PERCENTAGe=95.0
/DataTypeMin Percentage=95.0

David Marso wrote
> Quite ODD. I was going to suggest case sensitivity but rejected that as
> utterly absurd.
> Didn't even try it but that seems to be the CASE. [pun intentional].
> --

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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