topic Re: How do I output headers for categories with missing data? in SAS Procedures

How do I output headers for categories with missing data?

Benbo123321 — Tue, 16 Jun 2015 14:20:27 GMT

I'm trying to use PROC TABULATE to calculate counts and amounts for a set of months for a set of data. Some commands may not appear in all months. The problem is that SAS EG 5.1 by default does not print out headers for missing data and I need all the Commands printed out that occurred in that year, regardless of whether they occurred in that month. I tried to use the PRINTMISS command after the TABLE statement, to no avail.

PROC TABULATE

DATA = BENDATA;

VAR AMOUNT;

CLASS MONTH / ORDER= UNFORMATTED MISSING;

CLASS COMMAND / ORDER = UNFORMATTED MISSING;

TABLE MONTH * COMMAND,

AMOUNT * N PRINTMISS ;

;

RUN;

QUIT;

I get an error that says: "That type of name (PRINTMISS) is unknown."

What is the workaround for this in SAS EG 5.1?

Thanks,
Ben

Re: How do I output headers for categories with missing data?

Steelers_In_DC — Tue, 16 Jun 2015 14:27:49 GMT

I would add a dummy id before this step, populate 'A' or 1 for each variable. Then after this step you can run another step that deletes your dummy id.:

Re: How do I output headers for categories with missing data?

Benbo123321 — Tue, 16 Jun 2015 14:31:15 GMT

how would i go about doing that? The code above is system generated using the UI.

Re: How do I output headers for categories with missing data?

Steelers_In_DC — Tue, 16 Jun 2015 14:41:57 GMT

how many columns does BENDATA have? If you provide a list of the columns and if they are character or numeric I'll show you the code.

Re: How do I output headers for categories with missing data?

Benbo123321 — Tue, 16 Jun 2015 14:44:34 GMT

It has 3: Month, Command, and Amount. The first two are character, the last, numeric (?). It is the summary count.

Ben

Re: How do I output headers for categories with missing data?

Benbo123321 — Tue, 16 Jun 2015 14:56:24 GMT

To be clear; BENDATA has many columns. The only ones I care about are the two above and the summary count on the AMOUNT variable.

Re: How do I output headers for categories with missing data?

ballardw — Tue, 16 Jun 2015 15:44:47 GMT

The PRINTMISS error is occurring because you are missing a / to indicate non- page/row/column options.

One way IF you know there is a limited and not constantly changing list of commands is to create a custom format that is not very exciting:

proc format;

value $command /* assuming it is character*/

"Command1" = "Command1"

"Command2" = "Command2"

;

run;

Then in proc tabulate add PRELOADFMT to the options for the command variable and

format command $command. ; to use the Command format.

Re: How do I output headers for categories with missing data?

Benbo123321 — Tue, 16 Jun 2015 16:33:15 GMT

thank you so much. you solved my problem.