topic Re: Proc tabulate, adding across variable to the table and maintain the row percentage in SAS Programming

Proc tabulate, adding across variable to the table and maintain the row percentage

Cruise — Sat, 11 Jan 2020 01:36:48 GMT

Hi folks:

I'm trying to show the proportion of patients with missing stage by other covariates, for example, by age group in the image shown below.

My output is changed from WANTED to WRONG which you can see in the image below that the numbers for Breast cancer are changed before vs after adding the 'CANCER_SITE' category into the proc tabulate to produce the statistics for four different cancer sites.

How to add CANCER_SITE correctly in the proc tabulate code without changing the statistics that I'm showing in the WANTED part?

Please see my code snippet and mock data if needed.

PROC TABULATE DATA=BREAST_TABLE;
class MISS1 AGEGRP SEX RACETH STAGE1 SURGERY MEDICAID type_of_reporting_source
      marital_status_at_dx CANCER_SITE/ASCENDING;
table ALL (AGEGRP SEX RACETH marital_status_at_dx SURGERY STAGE1 MEDICAID
type_of_reporting_source),CANCER_SITE=''*MISS1=''*ROWpctn ALL;
RUN;DATA HAVE;
INPUT GENDER MISS_STATUS;

/*IF MOCK DATA NEEDED*/
DATA HAVE;
INPUT AGEGRP MISS_STATUS CANCER_SITE;
DATALINES;
1 1 1
1 1 1
1 1 1
1 0 1
1 0 1
1 0 1
1 0 1
1 0 1
0 1 1
0 1 1
0 1 1
0 0 1
0 0 1
0 0 1
0 0 1
1 1 2
1 1 2
1 1 2
1 1 2
1 1 2
1 0 2
1 0 2
1 0 2
0 1 2
0 1 2
0 1 2
0 1 2
0 1 2
0 0 2
0 0 2
;

I greatly appreciate your time!

Re: Proc tabulate, adding across variable to the table and maintain the row percentage

mkeintz — Sat, 11 Jan 2020 04:47:27 GMT

Change the table column specification from

,CANCER_SITE=''*MISS1=''*ROWpctn ALL

,CANCER_SITE=' ' * MISS1=' ' * (PCTN<MISS1>*f=6.2 N*f=comma9.0) ALL*F=comma9.0

I think PCTN is better than ROWPCTN at honoring your desired denominator for percent calculations.

Re: Proc tabulate, adding across variable to the table and maintain the row percentage

Cruise — Sat, 11 Jan 2020 12:53:47 GMT

The suggested change solved the problem. I would not have thought of this modification unless you pointed out. I greatly appreciate your help. Thanks a lot!