[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem with /Rename with Save Translate
From: |
Elio Spinello |
Subject: |
Re: Problem with /Rename with Save Translate |
Date: |
Fri, 16 Aug 2019 07:59:34 -0700 |
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.
RE: Problem with /Rename with Save Translate, Elio Spinello, 2019/08/15