Want to get only frequency Tables
Locked
 
|
Hi,
I want to get only frequency tables in SPSS and not only the Notes,Active Dataset and any other thing in Excel. For eg- When I run frequency we get data as fre mn. Frequencies Notes Output Created 26-Nov-2013 16:22:10 Comments Input Data C:\Users\AppData\Local\Temp\data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data File 1308 Missing Value Handling Definition of Missing User-defined missing values are treated as missing. Cases Used Statistics are based on all cases with valid data. Syntax fre mn. Resources Processor Time 0:00:00.203 Elapsed Time 0:00:00.246 [DataSet1] Statistics mn Month: N Valid 1308 Missing 0 mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 I want only the tables as mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 |
Re: Want to get only frequency Tables
|
Why not just copy them from the viewer file?
Right click on table, click on Copy, go to Word, then CTRL+V to paste. John F Hall (Mr) [Retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com SPSS start page: www.surveyresearch.weebly.com/spss-without-tears.html -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Kunal Sent: 26 November 2013 12:08 To: [hidden email] Subject: Want to get only frequency Tables Hi, I want to get only frequency tables in SPSS and not only the Notes,Active Dataset and any other thing in Excel. For eg- When I run frequency we get data as fre mn. Frequencies Notes Output Created 26-Nov-2013 16:22:10 Comments Input Data C:\Users\AppData\Local\Temp\data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data File 1308 Missing Value Handling Definition of Missing User-defined missing values are treated as missing. Cases Used Statistics are based on all cases with valid data. Syntax fre mn. Resources Processor Time 0:00:00.203 Elapsed Time 0:00:00.246 [DataSet1] Statistics mn Month: N Valid 1308 Missing 0 mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 I want only the tables as mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Want-to-get-only-frequency-Tab les-tp5723311.html Sent from the SPSSX Discussion mailing list archive at 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 ===================== 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 |
Re: Want to get only frequency Tables
|
|
In reply to this post by Kunal
You can use OMS to suppress targeted outputs. /* untested*/. OMS /SELECT CHARTS HEADINGS LOGS MODELS TEXTS TREES WARNINGS /DESTINATION VIEWER=NO. freq blah. omsend. On 26 November 2013 11:08, Kunal <[hidden email]> wrote: Hi, |
Re: Want to get only frequency Tables
|
|
More than one way to skin a cat, eh? From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of J Sutar You can use OMS to suppress targeted outputs. /* untested*/. OMS /SELECT CHARTS HEADINGS LOGS MODELS TEXTS TREES WARNINGS /DESTINATION VIEWER=NO. freq blah. omsend. On 26 November 2013 11:08, Kunal <[hidden email]> wrote: Hi, |
|
|
In reply to this post by Kunal
Thanks but is there any macro for this, so that I can represent this in a good format or any other setting
|
|
|
In reply to this post by Kunal
Go to
Edit > Options > Viewer In the "Initial Output State" section, look up the item you don't want to see (shown) and select Hidden from the "Contents are initially:" section. Press ok/Apply. I hope it helps. mils
mils
|
Re: Want to get only frequency Tables
Administrator
|
In reply to this post by Kunal
Please define your terms! Use case? Why would a macro help?
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?" |
|
|
Hi All,
Thanks for your help on this. David, I need a macro because when I run the frequency command in SPSS I need to get the Frequency Table only in SPSS for Single Response Sets and Multiple Response Sets with Case Summary so that I don't need to do them manually. Can you please suggest is there any way for this. |
Re: Want to get only frequency Tables
|
|
In reply to this post by Kunal
There are at least two ways to do this
without having to resort to using the clipboard.
1) Use OMS to capture exactly the table types you want and write an Excel file. The OMS type for the frequency table is 'Frequencies' 2) Set all the output objects you don't want to see to be hidden by default (Edit > Options > Viewer) or just hide the ones you don't want and then use the OUTPUT EXPORT command with EXPORT=VISIBLE. Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] phone: 720-342-5621 From: Kunal <[hidden email]> To: [hidden email], Date: 11/26/2013 04:09 AM Subject: [SPSSX-L] Want to get only frequency Tables Sent by: "SPSSX(r) Discussion" <[hidden email]> Hi, I want to get only frequency tables in SPSS and not only the Notes,Active Dataset and any other thing in Excel. For eg- When I run frequency we get data as fre mn. Frequencies Notes Output Created 26-Nov-2013 16:22:10 Comments Input Data C:\Users\AppData\Local\Temp\data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data File 1308 Missing Value Handling Definition of Missing User-defined missing values are treated as missing. Cases Used Statistics are based on all cases with valid data. Syntax fre mn. Resources Processor Time 0:00:00.203 Elapsed Time 0:00:00.246 [DataSet1] Statistics mn Month: N Valid 1308 Missing 0 mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 I want only the tables as mn Month: Frequency Percent Valid Percent Cumulative Percent Valid 11 November 1308 100.0 100.0 100.0 -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Want-to-get-only-frequency-Tables-tp5723311.html Sent from the SPSSX Discussion mailing list archive at 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 |