tr: SPSSINC Process Files translate SAV files into xls files

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

tr: SPSSINC Process Files translate SAV files into xls files

John F Hall

This message is not from me.  How did it happens?

John F Hall

[Retired academic survey researcher]

IBM-SPSS Academic author 9900074

 

Email:        johnfhall@... 

Website:   http://surveyresearch.weebly.com/

Course:     http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research: http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

 

 

 

 

 

> Message du 14/09/17 18:31

> De : "SUBSCRIBE SPSSX-JohnF" <[hidden email]>
> A : [hidden email]
> Copie à :
> Objet : SPSSINC Process Files translate SAV files into xls files
>
> Any help would be appreciated....I have the following code\syntax.....which runs, however the supposed excel files can't be read by excel....indicates wrong format or the file is corrupted. Looked at it using "Notepad" and it is gobbly-gook, although I
> saw the word "workbook" in the mess of gobbly-gook. Thanks for any assistance......
>
> SPSSINC PROCESS FILES INPUTDATA="C:\state_files\*.SAV"
> SYNTAX="C:/state_files//TransFiles2.sps"
> OUTPUTDATADIR="C:/temp/testONE/Completed/"
> VIEWERFILE= "C:/temp/testONE/OUTPUT.SPV"
> LOGFILE="C:/temp/testONE/log.txt" MACRONAME="!JOB" LOGFILEMODE=APPEND
> /MACRODEFS ITEMS.
>
> Here is the translate code\syntax....TransFiles2.sps
>
> GET FILE = "job_inputfile".
> SAVE TRANSLATE OUTFILE=!Out
> /TYPE=XLS
> /VERSION=12
> /MAP
> /REPLACE
> /FIELDNAMES
> /CELLS=LABELS
> /KEEP=state fipscode.
> exe.
> define !out () !quote(!concat(!unquote(!eval(!job_outputdatadir)), "/",
> !unquote(!eval(!job_datafileroot)), ".xls"))
> !enddefine.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: tr: SPSSINC Process Files translate SAV files into xls files

David Marso
Administrator
Are you subscribed as "SUBSCRIBE SPSSX-JohnF"?


John F Hall wrote
> This message is not from me.  How did it happens?
>
>
> John F Hall
> [Retired academic survey researcher]
> IBM-SPSS Academic author 9900074
>  
> Email:        

> johnfhall@

>  
> Website:   http://surveyresearch.weebly.com/
> Course:   
>  http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html
> Research: http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html
>  
>  
>  
>  
>  
>  
>> Message du 14/09/17 18:31
>> De : "SUBSCRIBE SPSSX-JohnF" <

> 000004580c0d28ae-dmarc-request@.UGA

>>
>> A :

> SPSSX-L@.UGA

>> Copie à :
>> Objet : SPSSINC Process Files translate SAV files into xls files
>>
>> Any help would be appreciated....I have the following
>> code\syntax.....which runs, however the supposed excel files can't be
>> read by excel....indicates wrong format or the file is corrupted. Looked
>> at it using "Notepad" and it is gobbly-gook, although I
>> saw the word "workbook" in the mess of gobbly-gook. Thanks for any
>> assistance......
>>
>> SPSSINC PROCESS FILES INPUTDATA="C:\state_files\*.SAV"
>> SYNTAX="C:/state_files//TransFiles2.sps"
>> OUTPUTDATADIR="C:/temp/testONE/Completed/"
>> VIEWERFILE= "C:/temp/testONE/OUTPUT.SPV"
>> LOGFILE="C:/temp/testONE/log.txt" MACRONAME="!JOB" LOGFILEMODE=APPEND
>> /MACRODEFS ITEMS.
>>
>> Here is the translate code\syntax....TransFiles2.sps
>>
>> GET FILE = "job_inputfile".
>> SAVE TRANSLATE OUTFILE=!Out
>> /TYPE=XLS
>> /VERSION=12
>> /MAP
>> /REPLACE
>> /FIELDNAMES
>> /CELLS=LABELS
>> /KEEP=state fipscode.
>> exe.
>> define !out () !quote(!concat(!unquote(!eval(!job_outputdatadir)), "/",
>> !unquote(!eval(!job_datafileroot)), ".xls"))
>> !enddefine.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>>
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: tr: SPSSINC Process Files translate SAV files into xls files

David Marso
Administrator
Measures have been taken John,
----
Dear user,
I see your email is [hidden email]
Your posts are showing up as SUBSCRIBE SPSSX-JohnF.
Another user has brought it to our attention that he did not post your
message (he is apparently registered as SUBSCRIBE SPSSX-JohnF).  PLEASE
subscribe under a different name (preferably your real one).  Further
messages using this misappropriated alias will be deleted and your email
account banned.
The Management.



-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"