Re: Problem with /Rename with Save Translate

[Elio Spinello]

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.