OUTPUT MODIFY & OMS
Locked
 
|
Hi SPSS experts,
Maybe one of you has an idea?. OUTPUT MODIFY works perfect. Titles of dozens of PLUM & GENLIN tables in the viewer are relabeled depending on each design. But the OMS/OMSEND command ignores those modifications when writing the selected results to an externel spv file. Thanks in advance, Hermann OMS /SELECT ALL /IF COMMANDS=['PLUM' 'Generalized Linear Models'] /DESTINATION FORMAT=SPV OUTFILE='daten902' VIEWER=YES. * Predictors: all aggregated "scope=ALL" error types. GENLIN Rat_c3 (REFERENCE=LAST ORDER=ASCENDING) WITH n10AWr n20APr n30ACr n40ASr n50ATr n90AUr /MODEL n10AWr n20APr n30ACr n40ASr n50ATr n90AUr DISTRIBUTION=MULTINOMIAL LINK=CUMLOGIT INTERCEPT=YES /CRITERIA METHOD=FISHER SCALE=1 COVB=MODEL MAXITERATIONS=100 MAXSTEPHALVING=5 SINGULAR=1E-008 PCONVERGE=1E-006(ABSOLUTE) ANALYSISTYPE=3(WALD) CILEVEL=95 CITYPE=WALD LIKELIHOOD=FULL /MISSING CLASSMISSING=EXCLUDE /PRINT CPS DESCRIPTIVES MODELINFO FIT SUMMARY SOLUTION (EXPONENTIATED) HISTORY(1) /SAVE MEANPRED(:25) CIMEANPREDL(:25) CIMEANPREDU(:25) PREDVAL XBPRED(:25) XBSTDERROR(:25). OUTPUT MODIFY NAME=* /SELECT HEADINGS /IF COMMANDS=['Generalized Linear Models(LAST)'] LABELS=[EXACT('Title')] /INDEXING INDEXTYPE=LETTERCAP INDEXSTART='A' /OBJECTPROPERTIES VISIBLE=ASIS OUTLINELABEL='GLM: Ratios, 6 SCOPE=ALL ErrorTypes ()INDEX)'. OMSEND FILE='daten902'. -- 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 |
|
|
Unfortunately, OMS operates only on backend output upstream from the Viewer, while OUTPUT MODIFY works only on the Viewer contents, so OMS does not see those changes. You would need to use OUTPUT EXPORT to pick up the modified Viewer contents. On Thu, Aug 8, 2019 at 4:22 PM Hermann <[hidden email]> wrote: Hi SPSS experts, |
|
|
Thanks a lot Jon,
Hermann Jon Peck wrote > Unfortunately, OMS operates only on backend output upstream from the > Viewer, while OUTPUT MODIFY works only on the Viewer contents, so OMS does > not see those changes. You would need to use OUTPUT EXPORT to pick up the > modified Viewer contents. > > On Thu, Aug 8, 2019 at 4:22 PM Hermann < > hermann.cesnik@.ac > > wrote: > >> Hi SPSS experts, >> >> Maybe one of you has an idea?. >> >> OUTPUT MODIFY works perfect. Titles of dozens of PLUM & GENLIN tables in >> the >> viewer are relabeled depending on each design. But the OMS/OMSEND command >> ignores those modifications when writing the selected results to an >> externel >> spv file. >> >> Thanks in advance, Hermann >> >> >> OMS >> /SELECT ALL >> /IF COMMANDS=['PLUM' 'Generalized Linear Models'] >> /DESTINATION FORMAT=SPV OUTFILE='daten902' VIEWER=YES. >> >> * Predictors: all aggregated "scope=ALL" error types. >> GENLIN Rat_c3 (REFERENCE=LAST ORDER=ASCENDING) WITH n10AWr n20APr n30ACr >> n40ASr n50ATr n90AUr >> /MODEL n10AWr n20APr n30ACr n40ASr n50ATr n90AUr >> DISTRIBUTION=MULTINOMIAL >> LINK=CUMLOGIT INTERCEPT=YES >> /CRITERIA METHOD=FISHER SCALE=1 COVB=MODEL MAXITERATIONS=100 >> MAXSTEPHALVING=5 SINGULAR=1E-008 >> PCONVERGE=1E-006(ABSOLUTE) ANALYSISTYPE=3(WALD) CILEVEL=95 >> CITYPE=WALD LIKELIHOOD=FULL >> /MISSING CLASSMISSING=EXCLUDE >> /PRINT CPS DESCRIPTIVES MODELINFO FIT SUMMARY SOLUTION (EXPONENTIATED) >> HISTORY(1) >> /SAVE MEANPRED(:25) CIMEANPREDL(:25) CIMEANPREDU(:25) PREDVAL >> XBPRED(:25) >> XBSTDERROR(:25). >> >> OUTPUT MODIFY NAME=* >> /SELECT HEADINGS >> /IF COMMANDS=['Generalized Linear Models(LAST)'] >> LABELS=[EXACT('Title')] >> /INDEXING INDEXTYPE=LETTERCAP INDEXSTART='A' >> /OBJECTPROPERTIES VISIBLE=ASIS OUTLINELABEL='GLM: Ratios, 6 SCOPE=ALL >> ErrorTypes ()INDEX)'. >> >> OMSEND FILE='daten902'. >> >> >> >> >> >> -- >> Sent from: http://spssx-discussion.1045642.n5.nabble.com/ >> >> ===================== >> 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 >> > > > -- > Jon K Peck > jkpeck@ > > ===================== > 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 ----- Mag. Dr. Hermann Stefan Cesnik Zentraler Informatikdienst (Empirische Forschungsmethoden) Language Testing Centre (LTC) Alpen-Adria Universität Klagenfurt phone: +43 (0)463 2700-2533 mail: hermann.cesnik [at] uni-klu.ac.at web: https://campus.aau.at/visitenkarte?username=hcesnik https://www.aau.at/en/language-testing-centre/team/ https://www.researchgate.net/profile/Hermann_Cesnik -- 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 |
|
|
In reply to this post by Jon Peck
Hi Jon,
currently I can see two missing options with OUTPUT EXPORT. - OE does not export to spv format - OE does not allow selecting objects automatically by syntax What I need are two output (spv) files. One for users in the academic field of language testing with selected and relabeled results of the ordinal logistic regression models (PLUM & GENLIN) only and the other one including the entire procedures for the statistician itself. So the first one is a part of the second one. Both of them should be generated automatically by syntax because of multiple repeating with a lot of different data sets. Thanks in advance, Hermann Jon Peck wrote > Unfortunately, OMS operates only on backend output upstream from the > Viewer, while OUTPUT MODIFY works only on the Viewer contents, so OMS does > not see those changes. You would need to use OUTPUT EXPORT to pick up the > modified Viewer contents. > > On Thu, Aug 8, 2019 at 4:22 PM Hermann < > hermann.cesnik@.ac > > wrote: > >> Hi SPSS experts, >> >> Maybe one of you has an idea?. >> >> OUTPUT MODIFY works perfect. Titles of dozens of PLUM & GENLIN tables in >> the >> viewer are relabeled depending on each design. But the OMS/OMSEND command >> ignores those modifications when writing the selected results to an >> externel >> spv file. >> >> Thanks in advance, Hermann >> >> >> OMS >> /SELECT ALL >> /IF COMMANDS=['PLUM' 'Generalized Linear Models'] >> /DESTINATION FORMAT=SPV OUTFILE='daten902' VIEWER=YES. >> >> * Predictors: all aggregated "scope=ALL" error types. >> GENLIN Rat_c3 (REFERENCE=LAST ORDER=ASCENDING) WITH n10AWr n20APr n30ACr >> n40ASr n50ATr n90AUr >> /MODEL n10AWr n20APr n30ACr n40ASr n50ATr n90AUr >> DISTRIBUTION=MULTINOMIAL >> LINK=CUMLOGIT INTERCEPT=YES >> /CRITERIA METHOD=FISHER SCALE=1 COVB=MODEL MAXITERATIONS=100 >> MAXSTEPHALVING=5 SINGULAR=1E-008 >> PCONVERGE=1E-006(ABSOLUTE) ANALYSISTYPE=3(WALD) CILEVEL=95 >> CITYPE=WALD LIKELIHOOD=FULL >> /MISSING CLASSMISSING=EXCLUDE >> /PRINT CPS DESCRIPTIVES MODELINFO FIT SUMMARY SOLUTION (EXPONENTIATED) >> HISTORY(1) >> /SAVE MEANPRED(:25) CIMEANPREDL(:25) CIMEANPREDU(:25) PREDVAL >> XBPRED(:25) >> XBSTDERROR(:25). >> >> OUTPUT MODIFY NAME=* >> /SELECT HEADINGS >> /IF COMMANDS=['Generalized Linear Models(LAST)'] >> LABELS=[EXACT('Title')] >> /INDEXING INDEXTYPE=LETTERCAP INDEXSTART='A' >> /OBJECTPROPERTIES VISIBLE=ASIS OUTLINELABEL='GLM: Ratios, 6 SCOPE=ALL >> ErrorTypes ()INDEX)'. >> >> OMSEND FILE='daten902'. >> >> >> >> >> >> -- >> Sent from: http://spssx-discussion.1045642.n5.nabble.com/ >> >> ===================== >> 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 >> > > > -- > Jon K Peck > jkpeck@ > > ===================== > 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 ----- Mag. Dr. Hermann Stefan Cesnik Zentraler Informatikdienst (Empirische Forschungsmethoden) Language Testing Centre (LTC) Alpen-Adria Universität Klagenfurt phone: +43 (0)463 2700-2533 mail: hermann.cesnik [at] uni-klu.ac.at web: https://campus.aau.at/visitenkarte?username=hcesnik https://www.aau.at/en/language-testing-centre/team/ https://www.researchgate.net/profile/Hermann_Cesnik -- 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 |
|
|
In reply to this post by Jon Peck
Sometimes it is preferable to export your results to Excel. In this case - after OUTPUT MODIFY - you can use this kind of syntax: OUTPUT EXPORT /CONTENTS EXPORT = VISIBLE /XLSX DOCUMENTFILE = 'yourPath\yourFile.xlsx' OPERATION = CREATESHEET SHEET = 'myResults'. Mario Giesel Munich, Germany
Am Freitag, 9. August 2019, 00:26:40 MESZ hat Jon Peck <[hidden email]> Folgendes geschrieben:
Unfortunately, OMS operates only on backend output upstream from the Viewer, while OUTPUT MODIFY works only on the Viewer contents, so OMS does not see those changes. You would need to use OUTPUT EXPORT to pick up the modified Viewer contents. On Thu, Aug 8, 2019 at 4:22 PM Hermann <[hidden email]> wrote: Hi SPSS experts, |
|
|
In reply to this post by Hermann
OUTPUT EXPORT does not support spv as a target type, because it was designed to convert to other types. What you want is a copy/paste option that targets a new spv file. Alternatively, maybe a doc or html format would suffice. The other part of the problem is how to select the desired objects whether for copy/paste or a true export. OUTPUT EXPORT does not offer that option. The SPSSINC MODIFY OUTPUT extension command provides a basis for both of these things, but it would require some custom code unless Excel would do as a target. It has a custom function, customoutputfunctions.excelexport, that is installed with the extension that allows exporting tables selected using the OMS command and subcommand criteria to an Excel file. I wrote that because it was a common use case. In order to get what you need, it would be very easy to create another custom function that does the selection part according to the OMS criteria using SPSSINC MODIFY OUTPUT. At that point, another small function would be needed to copy/paste the selected items to a new Viewer window and save that to a file in spv or other format. I can help you with this if you want to go this route. If you do, send me an spv file and the selection criteria for testing purposes. On Sat, Aug 10, 2019 at 11:59 AM Hermann <[hidden email]> wrote: Hi Jon, |
|
|
Hi Jon and Mario,
thanks a lot for all your advices. Subsequent you will find the last section of my syntax as a combination of OUTPUT MODIFY and OUTPUT SAVE I realised obtaining the result I wanted. Two different output versions are saved. … * Predictors: all 20 unaggregated error types. GENLIN Rat_c3 (REFERENCE=LAST ORDER=ASCENDING) WITH n25TPr n35TCr n45TSr n55TTr n95TUr n15TWr n24SPr n34SCr n44SSr n94SUr n14SWr n23CPr n33CCr n93CUr n13CWr n22PPr n92PUr n12PWr n91WUr n11WWr /MODEL n25TPr n35TCr n45TSr n55TTr n95TUr n15TWr n24SPr n34SCr n44SSr n94SUr n14SWr n23CPr n33CCr n93CUr n13CWr n22PPr n92PUr n12PWr n91WUr n11WWr DISTRIBUTION=MULTINOMIAL LINK=CUMLOGIT INTERCEPT=YES /CRITERIA METHOD=FISHER SCALE=1 COVB=MODEL MAXITERATIONS=100 MAXSTEPHALVING=5 SINGULAR=1E-008 PCONVERGE=1E-006(ABSOLUTE) ANALYSISTYPE=3(WALD) CILEVEL=95 CITYPE=WALD LIKELIHOOD=FULL /MISSING CLASSMISSING=EXCLUDE /PRINT CPS DESCRIPTIVES MODELINFO FIT SUMMARY SOLUTION (EXPONENTIATED) HISTORY(1) /SAVE MEANPRED(:25) CIMEANPREDL(:25) CIMEANPREDU(:25) PREDVAL XBPRED(:25) XBSTDERROR(:25). OUTPUT MODIFY NAME=* /SELECT HEADINGS /IF COMMANDS=['Generalized Linear Models(LAST)'] LABELS=[EXACT('Title')] /INDEXING INDEXTYPE=LETTERCAP INDEXSTART='A' /OBJECTPROPERTIES VISIBLE=ASIS OUTLINELABEL='GLM: Ratios, all 20 Error Types ()INDEX)'. ******************************************************************************** * Saving entire output file as it is. ******************************************************************************** OUTPUT SAVE NAME=FULL_OUTPUT OUTFILE='data901' TYPE=SPV LOCK=NO. ******************************************************************************** * Modifying output by including Model results only and excluding all additional informations; this is directed to a seperate file for Niks usage explicitely. ******************************************************************************** OUTPUT MODIFY /REPORT PRINTREPORT=YES /SELECT ALL /IF COMMANDS=['Generalized Linear Models'] /DELETEOBJECT DELETE=NO /OBJECTPROPERTIES VISIBLE=ASIS /SELECT ALL /IF COMMANDS=['PLUM'] /DELETEOBJECT DELETE=NO /OBJECTPROPERTIES VISIBLE=ASIS /SELECT ALL /IF COMMANDS=['Frequencies'] /DELETEOBJECT DELETE=YES /SELECT ALL /IF COMMANDS=['Descriptives'] /DELETEOBJECT DELETE=YES /SELECT ALL /IF COMMANDS=['Logistic Regression'] /DELETEOBJECT DELETE=YES /SELECT ALL /IF COMMANDS=['Logistic Regression'] /DELETEOBJECT DELETE=YES /SELECT ALL /IF COMMANDS=['File Information'] /DELETEOBJECT DELETE=YES /SELECT ALL /IF LABELS=[EXACT('Log')] /DELETEOBJECT DELETE=YES /SELECT ALL /IF LABELS=[EXACT('Page Title')] /DELETEOBJECT DELETE=YES /SELECT ALL /IF COMMANDS=['Output Modify'] /DELETEOBJECT DELETE=YES. OUTPUT SAVE NAME=FULL_OUTPUT OUTFILE='data902' TYPE=SPV LOCK=NO. … ATB, Hermann ----- Mag. Dr. Hermann Stefan Cesnik Zentraler Informatikdienst (Empirische Forschungsmethoden) Language Testing Centre (LTC) Alpen-Adria Universität Klagenfurt phone: +43 (0)463 2700-2533 mail: hermann.cesnik [at] uni-klu.ac.at web: https://campus.aau.at/visitenkarte?username=hcesnik https://www.aau.at/en/language-testing-centre/team/ https://www.researchgate.net/profile/Hermann_Cesnik -- 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 |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |