Hi,
I need help. I'm trying to output the following:
|
| Female | |
Total N | N | % | |
Class A | 1695 | 895 | (52.8%) |
Class B | 2125 | 1334 | (62.8%) |
Total | 3820 | 2229 | (58.4%) |
But I got below instead. The percentages aren't showing up correctly:
|
| Female | |
Total N | Sum | Mean | |
Class A | 1695 | 895 | (0.5%) |
Class B | 2125 | 1334 | (0.6%) |
Total | 3820 | 2229 | (0.6%) |
Thanks so much!
My code:
proc format;
picture paren (round)
low-high = '(009.9%)'
( prefix = '(' );
run;
proc tabulate data=data FORMAT=9.0 order=formatted;
var FEMALE;
table class_grp ='' ALL = 'Total' * {style={bordertopcolor=black bordertopwidth=1 bordertopstyle=double font_weight=bold}},
ALL = 'Total N' * n
(FEMALE) * (sum mean * f=paren.)
/ ROW=FLOAT RTS=22 MISSTEXT='-' ;
KEYWORD all / style=[bordertopcolor=black bordertopwidth=1 bordertopstyle=double font_weight=bold fontstyle=italic];
title1;
run;
Thanks so much!
If you are taking the mean of 1/0 coded variable to create percentages then the values are likely to be between 0 and 1. Which will likey require to use a multiplier in the format to get the range into the range of the picture
Try
picture paren (round)
low-high = '(009.9%)'
( prefix = '(' mult=1000);
Since you haven't provided any actual data the value for mult is guess.
Hi,
Please try this:
proc format;
picture paren
low-high='009.00%';
picture paren low-high=99.99 (prefix='(' mult=1);
run;
If you are taking the mean of 1/0 coded variable to create percentages then the values are likely to be between 0 and 1. Which will likey require to use a multiplier in the format to get the range into the range of the picture
Try
picture paren (round)
low-high = '(009.9%)'
( prefix = '(' mult=1000);
Since you haven't provided any actual data the value for mult is guess.
This worked perfectly for me. Thanks so much!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.