topic Re: Proc tabulate in SAS Procedures

Proc tabulate

gstover — Tue, 28 Sep 2021 16:17:55 GMT

Is there a way to add a column variable in proc tabulate that is not on the raw data?

I have a gender categories of Female, Male and Unknown. I would like to display the Unknown column and it is not on my raw data.

Is there a way to do this?

Re: Proc tabulate

Reeza — Tue, 28 Sep 2021 16:22:51 GMT

See page 4 / Example 3 here
https://www.lexjansen.com/nesug/nesug11/cc/cc29.pdf

PRELOADFMT or COMPLETETYPES are the terms that you can google with PROC TABULATE.

Re: Proc tabulate

ballardw — Tue, 28 Sep 2021 16:46:53 GMT

If your "unknown" means that the variable that holds gender has the value missing then one way is to do three things assuming this is used as a Class variable:

1) on the Class statement add the MISSING option so missing is included in the report. This would look like:

Class gender / missing;

2) create a format that displays missing values as "Unknown"

3) associate the format with the variable with a format statement.

Example

proc format;
value $missgender
' ' = 'Unknown'
;
run;

data example;
   input gender $ varx;
datalines;
Female  123
Male    456
.       111
;

proc tabulate data=example;
   class gender/missing;
   format gender $missgender.;
   var varx;
   table gender,
         varx*mean
   ;
run;