RE: Problem with /Rename with Save Translate

[Elio Spinello]

Here is the code that I ran in SPSS.  Some of the really long names were
truncated, but it ran successfully without error messages (other than a
message about the truncations) and it produced the output file.

Elio

Elio Spinello, EdD
Partner
RPM Consulting, LLC
17130 Devonshire St.  Suite 101
Nothridge, CA  91325
(818) 831-7607



SAVE TRANSLATE 
/OUTFILE="e:\Databases\Updates\RCRA\hreport_univ_CA5.csv"
  /TYPE=CSV
  /MAP
  /REPLACE
  /FIELDNAMES
  /Unselected=DELETE
   /RENAME=
Var1    =       "EPA Handler ID"
Var2    =       "Activity Location"
Var3    =       "Source Type"
Var4    =       "Sequence Number"
Var5    =       "Receive Date"
Var6    =       "Handler Name"
Var7    =       "Non-Notifier"
Var8    =       "Acknowledge Flag Date"
Var9    =       "Acknowledge Flag"
Var10   =       "Accessibility"
Var11   =       "Location Street Number"
Var12   =       "Location Street 1"
Var13   =       "Location Street 2"
Var14   =       "Location City"
Var15   =       "Location State"
Var16   =       "Location Zip Code"
Var17   =       "Location Country"
Var18   =       "County Code"
Var19   =       "State District Owner"
Var20   =       "State District"
Var21   =       "Land Type"
Var22   =       "Mailing Street Number"
Var23   =       "Mailing Street 1"
Var25   =       "Mailing City"
Var26   =       "Mailing State"
Var27   =       "Mailing Zip Code"
Var28   =       "Mailing Country"
Var29   =       "Contact First Name"
Var30   =       "Contact Middle Initial"
Var31   =       "Contact Last Name"
Var32   =       "Contact Street Number"
Var33   =       "Contact Street 1"
Var34   =       "Contact Street 2"
Var35   =       "Contact City"
Var36   =       "Contact State"
Var37   =       "Contact Zip Code"
Var38   =       "Contact Country"
Var39   =       "Contact Telephone Number"
Var40   =       "Contact Telephone Extension"
Var41   =       "Contact Facsimile Number"
Var42   =       "Contact Email Address"
Var43   =       "Contact Title"
Var44   =       "Federal Waste Generator Code Owner"
Var45   =       "Federal Waste Generator Code"
Var46   =       "State Waste Generator Code Owner"
Var47   =       "State Waste Generator Code"
Var48   =       "Short-Term Generator Activity"
Var49   =       "Importer Activity"
Var50   =       "Mixed Waste Generator"
Var51   =       "Transporter Activity"
Var52   =       "Transfer Facility Activity"
Var53   =       "TSD Activity"
Var54   =       "Recycler Activity with Storage"
Var55   =       "Small Quantity On-site Burner Exemption"
Var56   =       "Smelting, Melting, and Refining Furnace Exemption"
Var57   =       "Underground Injection Control"
Var58   =       "Off-site Waste Receipt"
Var59   =       "Universal Waste Destination Facility"
Var60   =       "Used Oil Transporter"
Var61   =       "Used Oil Transfer Facility"
Var62   =       "Used Oil Processor"
Var63   =       "Used Oil Refiner"
Var64   =       "Off-specification Used Oil Burner"
Var65   =       "Mktr ship oil to burnerr"
Var66   =       "Mktr Who First Claims the Used Oil Meets Spec"
Var67   =       "Subpart K - College or University"
Var68   =       "Subpart K - Teaching Hospital"
Var69   =       "Subpart K - Non-profit Research Institute"
Var70   =       "Subpart K - Withdrawal"
Var71   =       "Include in National Report"
Var72   =       "Biennial Report Cycle"
Var73   =       "Large Quantity Handler of Universal Waste"
Var74   =       "Recognized Trader Importer"
Var75   =       "Recognized Trader Exporter"
Var76   =       "Spent Lead Acid Battery Importer"
Var77   =       "Spent Lead Acid Battery Exporter"
Var78   =       "Current Record"
Var79   =       "Non-storage Recycler Activity"
Var80   =       "Electronic Manifest Broker"
  /CELLS=VALUES
  .

-----Original Message-----
From: John Darrington <address@hidden> 
Sent: Friday, August 16, 2019 11:59 AM
To: Elio Spinello <address@hidden>
Cc: John Darrington <address@hidden>; address@hidden
Subject: Re: Problem with /Rename with Save Translate

Can you send us the code which runs on spss but not on pspp.

Thank you.

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.

--
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.