Need Total count but only percentages for the values

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

catiscot
Posts: 3
Joined: Thu Jan 04, 2018 7:35 pm

Need Total count but only percentages for the values

Postby catiscot » Thu Jan 04, 2018 8:27 pm

Hi, Could someone help me save my job. Could they advise on how to change the syntax below so that it will generate a table with Total in the form of Count only and values in the form of percentage only.

CTABLES/FORMAT EMPTY=BLANK MISSING='.' /SMISSING VARIABLE
/VLABELS VARIABLES=s1a online DISPLAY=DEFAULT
/TABLE s1a [C][COLPCT.COUNT '%' PCT40.0, COUNT F40.0] BY online [C]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=s1a EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE
/CATEGORIES VARIABLES=online ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE.

If you can help, thanks very much!

Gary

Who is online

Users browsing this forum: No registered users and 4 guests

cron