RE: Problem with /Rename with Save Translate

[Elio Spinello]

...and the version is 1.2

-----Original Message-----
From: Elio Spinello <address@hidden> 
Sent: Thursday, August 15, 2019 12:43 PM
To: 'John Darrington' <address@hidden>
Cc: 'address@hidden' <address@hidden>
Subject: RE: Problem with /Rename with Save Translate

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.