Hi,
I have five variables for which I have made a MDGROUP and run a table and the following result has come. If I take the frequency the result is different. Is it possible in custom tables to get the same result as of frequency. What custom table does it if it does not find value given in MDGROUP in any of the case, it drops that case.
Please help.
Regards
Custom Tables
Notes |
Contents | Output Created | 09-Jul-2014 16:54:54 |
Comments | |
Input | Data | |
Active Dataset | DataSet4 |
Filter | <none> |
Weight | <none> |
Split File | <none> |
N of Rows in Working Data File | 335 |
Syntax | CTABLES /VLABELS VARIABLES=$q3 ct DISPLAY=LABEL /TABLE $q3 [COUNT F40.0, COLPCT.COUNT PCT40.1, TABLEPCT.COUNT PCT40.1, COLPCT.TOTALN PCT40.1, COLPCT.VALIDN PCT40.1] BY ct [C] /SLABELS POSITION=ROW /CATEGORIES VARIABLES=$q3 EMPTY=INCLUDE /CATEGORIES VARIABLES=ct ORDER=A KEY=VALUE EMPTY=INCLUDE. |
Resources | Processor Time | 0:00:00.000 |
Elapsed Time | 0:00:00.000 |
[DataSet4] C:\projects\csmm\171106753\Data\171106753~fnl.sav
| | | | |
| | | 1.00 Total | Right %age |
Q 3 | nq3_1 | Count | 245 | |
Column N % | 84.5% | |
Table N % | 84.5% | |
Column Total N % | 73.1% | 74.0% |
Column Valid N % | 84.5% | |
nq3_2 | Count | 189 | |
Column N % | 65.2% | |
Table N % | 65.2% | |
Column Total N % | 56.4% | 57.4% |
Column Valid N % | 65.2% | |
nq3_3 | Count | 212 | |
Column N % | 73.1% | |
Table N % | 73.1% | |
Column Total N % | 63.3% | 63.5% |
Column Valid N % | 73.1% | |
nq3_4 | Count | 221 | |
Column N % | 76.2% | |
Table N % | 76.2% | |
Column Total N % | 66.0% | 66.2% |
Column Valid N % | 76.2% | |
nq3_5 | Count | 197 | |
Column N % | 67.9% | |
Table N % | 67.9% | |
Column Total N % | 58.8% | 58.8% |
Column Valid N % | 67.9% | |
Frequencies
Notes |
Contents | Output Created | 09-Jul-2014 16:55:04 |
Comments | |
Input | Data | |
Active Dataset | DataSet4 |
Filter | <none> |
Weight | <none> |
Split File | <none> |
N of Rows in Working Data File | 335 |
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 | FREQUENCIES VARIABLES=nq3_1 nq3_2 nq3_3 nq3_4 nq3_5 /ORDER=ANALYSIS. |
Resources | Processor Time | 0:00:00.000 |
Elapsed Time | 0:00:00.000 |
[DataSet4] C:\projects\csmm\171106753\Data\171106753~fnl.sav
Statistics |
| | nq3_1 | nq3_2 | nq3_3 | nq3_4 | nq3_5 |
N | Valid | 331 | 329 | 334 | 334 | 335 |
Missing | 4 | 6 | 1 | 1 | 0 |
Frequency Table
nq3_1 |
| | Frequency | Percent | Valid Percent | Cumulative Percent |
Valid | 1.00 Top-2 | 245 | 73.1 | 74.0 | 74.0 |
2.00 Bot-3 | 86 | 25.7 | 26.0 | 100.0 |
Total | 331 | 98.8 | 100.0 | |
Missing | 3.00 | 4 | 1.2 | | |
Total | 335 | 100.0 | | |
nq3_2 |
| | Frequency | Percent | Valid Percent | Cumulative Percent |
Valid | 1.00 Top-2 | 189 | 56.4 | 57.4 | 57.4 |
2.00 Bot-3 | 140 | 41.8 | 42.6 | 100.0 |
Total | 329 | 98.2 | 100.0 | |
Missing | 3.00 | 6 | 1.8 | | |
Total | 335 | 100.0 | | |
nq3_3 |
| | Frequency | Percent | Valid Percent | Cumulative Percent |
Valid | 1.00 Top-2 | 212 | 63.3 | 63.5 | 63.5 |
2.00 Bot-3 | 122 | 36.4 | 36.5 | 100.0 |
Total | 334 | 99.7 | 100.0 | |
Missing | 3.00 | 1 | .3 | | |
Total | 335 | 100.0 | | |
nq3_4 |
| | Frequency | Percent | Valid Percent | Cumulative Percent |
Valid | 1.00 Top-2 | 221 | 66.0 | 66.2 | 66.2 |
2.00 Bot-3 | 113 | 33.7 | 33.8 | 100.0 |
Total | 334 | 99.7 | 100.0 | |
Missing | 3.00 | 1 | .3 | | |
Total | 335 | 100.0 | | |
nq3_5 |
| | Frequency | Percent | Valid Percent | Cumulative Percent |
Valid | 1.00 Top-2 | 197 | 58.8 | 58.8 | 58.8 |
2.00 Bot-3 | 138 | 41.2 | 41.2 | 100.0 |
Total | 335 | 100.0 | 100.0 | |
http://www.imrbint.com/disclaimer.html
=====================
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
Locked
