Re: Problem with /Rename with Save Translate

[John Darrington]

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 27B3
See http://sks-keyservers.net or any PGP keyserver for public key.