TABLES ?
Locked
 
|
I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example.
Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
|
|
I, too, have syntax for 'Old' Tables. As well, I'm used to 'Old' Tables
and don't want to switch. When I spoke with SPSS about this, I found out that 'Old' Tables was still available as of v14 and is actually installed as part of the basic installation (I don't know about v15, I'm still waiting for approval to upgrade). However, you need a separate(free)authorization code for it. You can get it from SPSS and then you'll need to re-run the Authorization Wizard. SPSS told me that they wanted to 'wean' users off 'Old' tables, so I guess at some point, they'll quit including 'Old' tables. I will miss it. Pat -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: February 8, 2007 10:45 AM To: [hidden email] Subject: TABLES ? I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example. Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
|
|
TABLES is still around in 15.
-----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cleland, Patricia (EDU) Sent: Thursday, February 08, 2007 10:19 AM To: [hidden email] Subject: Re: TABLES ? I, too, have syntax for 'Old' Tables. As well, I'm used to 'Old' Tables and don't want to switch. When I spoke with SPSS about this, I found out that 'Old' Tables was still available as of v14 and is actually installed as part of the basic installation (I don't know about v15, I'm still waiting for approval to upgrade). However, you need a separate(free)authorization code for it. You can get it from SPSS and then you'll need to re-run the Authorization Wizard. SPSS told me that they wanted to 'wean' users off 'Old' tables, so I guess at some point, they'll quit including 'Old' tables. I will miss it. Pat -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: February 8, 2007 10:45 AM To: [hidden email] Subject: TABLES ? I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example. Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
|
|
In reply to this post by Cleland, Patricia (EDU)
Whatever the merits of Tables vs Ctables - my opinion is that Ctables is way better - Tables is still available with 15 as long as you have the license code.
But every since the creation of Ctables, we have shipped a conversion utility that transforms Tables syntax into Ctables syntax. It is a standalone executable that processes entire syntax files. We also provide a script (Utilities/Run Script/SyntaxConverter) that provides a simple gui interface to this executable. The converter passes through any non-Tables syntax unchanged, comments out your Tables commands, and generates corresponding Ctables commands. Most Tables syntax converts pretty well, but there are two situations that the converter cannot handle. If you have macros in the Tables syntax, the converter does not understand them. And, with old Tables you sometimes had to do temporary transformation tricks to get what you wanted, but the converter does not try to figure out your transformation code. Regards, Jon Peck -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cleland, Patricia (EDU) Sent: Thursday, February 08, 2007 10:19 AM To: [hidden email] Subject: Re: [SPSSX-L] TABLES ? I, too, have syntax for 'Old' Tables. As well, I'm used to 'Old' Tables and don't want to switch. When I spoke with SPSS about this, I found out that 'Old' Tables was still available as of v14 and is actually installed as part of the basic installation (I don't know about v15, I'm still waiting for approval to upgrade). However, you need a separate(free)authorization code for it. You can get it from SPSS and then you'll need to re-run the Authorization Wizard. SPSS told me that they wanted to 'wean' users off 'Old' tables, so I guess at some point, they'll quit including 'Old' tables. I will miss it. Pat -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: February 8, 2007 10:45 AM To: [hidden email] Subject: TABLES ? I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example. Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
|
|
Thanks for the response, but don't you have to have the tables module to have ctables? The problem is I have spss14 with the tables module. The others have only SPSS 14 base. The system this is connecting to only works with spss14. (15 is not a option). The tables module for spss14 is no longer available. (WHY?), Anyway is there a way to produce similar output with some conversion process?
Thanks again, L.A. Romsa >>> "Peck, Jon" <[hidden email]> 2/8/2007 9:49 AM >>> Whatever the merits of Tables vs Ctables - my opinion is that Ctables is way better - Tables is still available with 15 as long as you have the license code. But every since the creation of Ctables, we have shipped a conversion utility that transforms Tables syntax into Ctables syntax. It is a standalone executable that processes entire syntax files. We also provide a script (Utilities/Run Script/SyntaxConverter) that provides a simple gui interface to this executable. The converter passes through any non-Tables syntax unchanged, comments out your Tables commands, and generates corresponding Ctables commands. Most Tables syntax converts pretty well, but there are two situations that the converter cannot handle. If you have macros in the Tables syntax, the converter does not understand them. And, with old Tables you sometimes had to do temporary transformation tricks to get what you wanted, but the converter does not try to figure out your transformation code. Regards, Jon Peck -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cleland, Patricia (EDU) Sent: Thursday, February 08, 2007 10:19 AM To: [hidden email] Subject: Re: [SPSSX-L] TABLES ? I, too, have syntax for 'Old' Tables. As well, I'm used to 'Old' Tables and don't want to switch. When I spoke with SPSS about this, I found out that 'Old' Tables was still available as of v14 and is actually installed as part of the basic installation (I don't know about v15, I'm still waiting for approval to upgrade). However, you need a separate(free)authorization code for it. You can get it from SPSS and then you'll need to re-run the Authorization Wizard. SPSS told me that they wanted to 'wean' users off 'Old' tables, so I guess at some point, they'll quit including 'Old' tables. I will miss it. Pat -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: February 8, 2007 10:45 AM To: [hidden email] Subject: TABLES ? I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example. Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
|
|
Sorry. I thought you were talking about the transition from Tables to Ctables. Since Tables and Ctables are both part of the Custom Tables option, but your users would have to have that option. The Custom Tables options is certainly still available with 14 or 15. In some cases you can produce similar output from SPSS Base, but Custom Tables goes far beyond what you can do with just the base.
-Jon Peck -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: Thursday, February 08, 2007 2:13 PM To: [hidden email] Subject: Re: [SPSSX-L] TABLES ? Thanks for the response, but don't you have to have the tables module to have ctables? The problem is I have spss14 with the tables module. The others have only SPSS 14 base. The system this is connecting to only works with spss14. (15 is not a option). The tables module for spss14 is no longer available. (WHY?), Anyway is there a way to produce similar output with some conversion process? Thanks again, L.A. Romsa >>> "Peck, Jon" <[hidden email]> 2/8/2007 9:49 AM >>> Whatever the merits of Tables vs Ctables - my opinion is that Ctables is way better - Tables is still available with 15 as long as you have the license code. But every since the creation of Ctables, we have shipped a conversion utility that transforms Tables syntax into Ctables syntax. It is a standalone executable that processes entire syntax files. We also provide a script (Utilities/Run Script/SyntaxConverter) that provides a simple gui interface to this executable. The converter passes through any non-Tables syntax unchanged, comments out your Tables commands, and generates corresponding Ctables commands. Most Tables syntax converts pretty well, but there are two situations that the converter cannot handle. If you have macros in the Tables syntax, the converter does not understand them. And, with old Tables you sometimes had to do temporary transformation tricks to get what you wanted, but the converter does not try to figure out your transformation code. Regards, Jon Peck -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Cleland, Patricia (EDU) Sent: Thursday, February 08, 2007 10:19 AM To: [hidden email] Subject: Re: [SPSSX-L] TABLES ? I, too, have syntax for 'Old' Tables. As well, I'm used to 'Old' Tables and don't want to switch. When I spoke with SPSS about this, I found out that 'Old' Tables was still available as of v14 and is actually installed as part of the basic installation (I don't know about v15, I'm still waiting for approval to upgrade). However, you need a separate(free)authorization code for it. You can get it from SPSS and then you'll need to re-run the Authorization Wizard. SPSS told me that they wanted to 'wean' users off 'Old' tables, so I guess at some point, they'll quit including 'Old' tables. I will miss it. Pat -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of L. A. Romsa Sent: February 8, 2007 10:45 AM To: [hidden email] Subject: TABLES ? I have always had tables with SPSS and have several syntax using it. I have some people who want to run theses syntax programs, but do not have Tables and is nor any longer available for SPSS 14. Is there any simple way to convert these to run? Here is an example. Thanks L.A. * Basic Tables. TEMPORARY. VARIABLE LABELS type '' . TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ADJACTVAL_sum /TABLES type > ADJACTVAL_sum BY (STATISTICS) /STATISTICS ptile 01('1%') ptile 05( '5%') ptile 25( '25%') median( 'Median') ptile 75( '75%') ptile 95( '95%') ptile 99( '99%') count( ( F5.0 ) 'Count') /TITLE 'VALUE RANGE'. |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |