additionally CTABLES should handle MRSETS like in this command CTABLES /VLABELS VARIABLES=$UmK display=none /TABLE $UmK [COLPCT.COUNT PCT40.0] by welle /titles TITLE='Ungestützte Markenbekanntheit' /CATEGORIES VARIABLES=$UmK EMPTY=EXCLUDE Order=a Key=count($umk) /COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=yes CATEGORIES=ALLVISIBLE MEANSVARIANCE=ALLCATS .
where $Umk in this case is a previously defined MRSET Regards Matthias 2015-02-17 18:37 GMT+01:00 <robe...@consumerscan.ca>: > CTABLES is essentially a command that allows custom 'Pivot' tables to be > generated. An good example of its most common 'in the trenches' uses is > below: > > CTABLES > /FORMAT EMPTY=BLANK MISSING='.' MINCOLWIDTH=60 MAXCOLWIDTH=60 > UNITS=POINTS > /SMISSING VARIABLE > /VLABELS VARIABLES=mon_noncurr q10tnc mon_curr q10tc DISPLAY=NONE > /VLABELS VARIABLES=region1 DISPLAY=NONE > /TABLE mon_noncurr [C] > q10tnc [S][MEAN PCT40.0] + mon_curr [C] > q10tc > [S][MEAN PCT40.0] BY region1 [C] > /SLABELS VISIBLE=NO > /CATEGORIES VARIABLES=mon_noncurr ORDER=A KEY=VALUE EMPTY=EXCLUDE > /CATEGORIES VARIABLES=mon_curr ORDER=A KEY=VALUE EMPTY=EXCLUDE > /CATEGORIES VARIABLES=region1 ORDER=A KEY=MEAN (q10tc) EMPTY=EXCLUDE > TOTAL=YES LABEL='National' POSITION=AFTER > /TITLES > TITLE='Slide 3' 'Overall Donor Experience Satisfaction'. > > CTABLES should be able to ignore missing values, set column widths to > prevent overflow for printing purposes,, be passed multiple variables, be > able to accept temporary labels for variables, be able to accept flags for > percentage or count totals, be able to present Mean values across > variables, have the ability to subset subcategories of variables based on > their labels, and accept Labels for the tables. > > While this may be basic when compared to some more advanced uses of the > command, this shows the most typical use of it in survey reporting. > > Best, > > robert > > > ----- Original Message ----- > From: "John Darrington" <j...@darrington.wattle.id.au> > To: robe...@consumerscan.ca > Cc: "Matthias Faeth" <m.fa...@gmx.de>, pspp-users@gnu.org, "F. Thomas" < > frank_tho...@orange.fr> > Sent: Tuesday, February 17, 2015 9:28:08 AM > Subject: Re: CTABLES Command > > So it seems there are an number of people who want CTABLES are prepared to > pay for it. > > Not ever having actually used CTABLES, I don't know exactly what it is, > and what people > are expecting for their money. From the spss docs I see it is a big > command with lots > of options, but perhaps people aren't expecting all of them. > > Would you like to draw up a minimum specification, and discuss it with > other potential > donors? Then it might be possible for an experienced programmer to > estimate the time > involved. There are various "bounty" services for FLOSS improvements > which possibly > one could use to raise the money, and find a programmer to do it. But > first the scope > of work has to be defined. > > > J' > > > On Tue, Feb 17, 2015 at 11:10:59AM -0600, robe...@consumerscan.ca wrote: > I myself would be willing to throw $100 down to motivate someone to > do CTABLES. It is a very important feature and I think it would be a great > coup for PSPP in terms of penetration. For students and researchers alike > it is invaluable, especially when it comes to survey banner reports. Just > my 2 cents (Well, 1000 cents, but there you go) > > Best, > > robert > > ----- Original Message ----- > From: "Matthias Faeth" <m.fa...@gmx.de> > To: "Ronald Crichton" <ronald.crich...@cit.edu.au> > Cc: pspp-users@gnu.org, "F. Thomas" <frank_tho...@orange.fr> > Sent: Tuesday, February 17, 2015 12:20:41 AM > Subject: Re: CTABLES Command > > > > > So maybe we can motivate Ben a little. I would think about a > kickstarter campaign. I'd put in 500USD for a full CTABLES to get that off > the ground. I think that would also clear the way for using MRSETS in an > easy way. > > @Ben: would money help to motivate you? > > > > > > Matthias F??th > > > > 2015-02-16 22:42 GMT+01:00 Crichton, Ronald < > ronald.crich...@cit.edu.au > : > > > SPSS Tables was the prime reason I purchased SPSS. To run reports > that Tables can do so nicely. > > > > > -----Original Message----- > From: pspp-users-bounces+ronald.crichton= cit.edu...@gnu.org [mailto: > pspp-users-bounces+ronald.crichton = cit.edu...@gnu.org ] On Behalf Of F. > Thomas > Sent: Tuesday, 17 February 2015 8:41 AM > To: pspp-users@gnu.org > Subject: Re: CTABLES Command > > A representative of SPSS said on the SPSS list some time ago that the > CTables module is the most sold module , besides the basic one. > > As other free or open source stats programmes don't offer this > opportunity it would really increase the attractivity of PSPP. > > - ftr > > > On 16/02/2015 19:38, Ben Pfaff wrote: > > On Mon, Feb 16, 2015 at 12:08:53PM -0600, robe...@consumerscan.ca > wrote: > >> Has there been any progress on CTABLES in PSPP. I have seen some of > >> the back and forth in the archives. It is a very valuable function > >> of SPSS and a very powerful tool for people in my field (market > >> research) for creating banner reports. Any idea on when this might > >> be implemented? > > It's unlikely to be implemented soon. > > > > _______________________________________________ > > Pspp-users mailing list > > Pspp-users@gnu.org > > https://lists.gnu.org/mailman/listinfo/pspp-users > > > > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users > > CIT is the ACT Large Training Provider of the Year. > Subscribe to CIT Industry Connection - CIT's free, bi monthly > publication: > http://cit.edu.au/industry_business/industry_connection/ > > ----------------------------------------------------------------------- > This email, and any attachments, may be confidential and also > privileged. If you are not the intended recipient, please notify the sender > and delete all copies of this transmission along with any attachments > immediately. You should not copy or use it for any purpose, nor disclose > its contents to any other person. > > ----------------------------------------------------------------------- > > > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users > > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users > > -- > PGP Public key ID: 1024D/2DE827B3 > fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3 > See http://sks-keyservers.net or any PGP keyserver for public key. > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users >
_______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users
