[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem with /Rename with Save Translate
From: |
Ben Pfaff |
Subject: |
Re: Problem with /Rename with Save Translate |
Date: |
Fri, 16 Aug 2019 13:57:30 -0700 |
User-agent: |
Mutt/1.10.1 (2018-07-13) |
Yes, this is a bug or a limitation in SAVE TRANSLATE in PSPP.
On Fri, Aug 16, 2019 at 07:59:34AM -0700, Elio Spinello wrote:
> I'm aware of the datafile limitation, but according to the Save Translate
> section of the manual, "The RENAMEsubcommand can also be used to change the
> names under which variables are saved; because they are used only in the
> output, these names do not have to conform to the usual PSPP variable naming
> rules. "FWIW the same code does run properly under SPSS.ElioSent from my
> T-Mobile 4G LTE Device
> -------- Original message --------From: John Darrington <address@hidden>
> Date: 8/16/19 1:49 AM (GMT-08:00) To: Elio Spinello <address@hidden> Cc:
> 'John Darrington' <address@hidden>, address@hidden Subject: Re: Problem with
> /Rename with Save Translate Variable names (and other identifiers) cannot
> contain spaces.See chapter 6 of the manual.J'On Thu, Aug 15, 2019 at
> 12:42:41PM -0700, Elio Spinello wrote: I'm running it under Windows 10.
> Your example runs find but aside from a minor syntax error I found in my
> code, it appears that the problem is with the long column names
> containing spaces. I have tried using single quotes, double quotes, and
> square brackets. Are they not supported? Elio Spinello
> Elio Spinello, EdD Partner RPM Consulting, LLC 17130 Devonshire
> St. Suite 101 Northridge, CA 91325 v. (818) 831-7607 f. (818)
> 831-9078 mobile: (818) 570-ELIO (3546) -----Original
> Message----- From: John Darrington <address@hidden> Sent: Wednesday,
> August 14, 2019 9:49 PM To: Elio Spinello <address@hidden> Cc: 'John
> Darrington' <address@hidden>; address@hidden Subject: Re: Problem with
> /Rename with Save Translate You don't say what version of pspp you
> are using, but so far as I can recall, there haven't been any changes in
> save translate for quite a while. I tried the following syntax and
> it worked just fine on pspp 1.3.0. Perhaps you can try it too:
> data list notable list /x y *. begin data 1 2 3 4 end
> data. save translate /outfile='xx.csv' /type=csv /replace
> /fieldnames /unselected=delete /rename (x y=a b) .
> J' On Wed, Aug 14, 2019 at 04:12:59PM -0700, Elio Spinello wrote:
> I have not been able to get the /Rename subcommand to work on a "Save
> Translate" command. The error that I consistently get is the following:
> I have tried a
> number of variations to the syntax including:
> SAVE TRANSLATE
> /OUTFILE='e:\Databases\Updates\RCRA\hreport_univ_CA5.csv"
> /TYPE=CSV /MAP /REPLACE
> /FIELDNAMES /Unselected=DELETE
> /RENAME (Var1 Var2=Test1 Test2) .
> SAVE TRANSLATE
> /OUTFILE='e:\Databases\Updates\RCRA\hreport_univ_CA5.csv"
> /TYPE=CSV /MAP /REPLACE
> /FIELDNAMES /Unselected=DELETE
> /RENAME = Var1=Test2 .
> SAVE TRANSLATE
> /OUTFILE='e:\Databases\Updates\RCRA\hreport_univ_CA5.csv"
> /TYPE=CSV /MAP /REPLACE
> /FIELDNAMES /Unselected=DELETE
> /RENAME = (Var1=Test2) .
> -- Avoid eavesdropping. Send strong encrypted email. PGP Public
> key ID: 1024D/2DE827B3 fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67
> 719C 2DE8 27B3 See http://sks-keyservers.net or any PGP keyserver for
> public key. -- Avoid eavesdropping. Send strong encrypted email.PGP
> Public key ID: 1024D/2DE827B3 fingerprint = 8797 A26D 0854 2EAB 0285 A290
> 8A67 719C 2DE8 27B3See http://sks-keyservers.net or any PGP keyserver for
> public key.
> _______________________________________________
> Pspp-users mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/pspp-users
RE: Problem with /Rename with Save Translate, Elio Spinello, 2019/08/15