topic column percentage within class variable in New SAS User

column percentage within class variable

TobbeNord — Thu, 25 Oct 2018 07:31:55 GMT

My code looks as following

proc tabulate data=invand(where=(fodelselandgrupp^='Sverige')) order=formatted missing;
title 'GFB och ålder inkl missing';
class gfb alderinv kon ;
table (kon='' all='Totalt')*(alderinv='' all='Alla'),(gfb='GFB' all='Alla')*(N='' rowpctn='Row %' pctn<kon all>='Col %')/box= 'Ålder vid invandringsår';
format alderinv aldkat. gfb gfbgrupp. kon $kon.;
run;
title;

With output attached

I want the column percentage to sum up into 100% witihin the variable "kon", (witihin "Kvinnor" and "Män").

How can I do that?

Re: column percentage within class variable

FreelanceReinh — Thu, 25 Oct 2018 09:21:22 GMT

Hello @TobbeNord,

Please replace

pctn<kon all>

with

pctn<alderinv all>

and check if the new results meet your expectations.

Re: column percentage within class variable

TobbeNord — Thu, 25 Oct 2018 09:59:08 GMT

Great!! Of course! Stupid of me.