topic Re: Proc Report define "across" problem in SAS Procedures

Proc Report define "across" problem

deleted_user — Mon, 30 Jun 2008 18:03:08 GMT

Hello experts-
In my dataset, I have a simple variable with 4 values of 1,2,3,4. While there will never be missing data, often not all values will appear in the actual data. However, I would like all values to appear in the report column, with a 0 freq count showing in the cell.

How can I force all this? Here is the define statement I am using:

define eval / across order=freq descending format=evaltyp.
center width=30 spacing=4 left "Evaluation Result";

Thanks !
Francine
College of American Pathologists

Re: Proc Report define "across" problem

Cynthia_sas — Mon, 30 Jun 2008 20:20:00 GMT

Hi:
Assuming that your user-defined format has all the values, then you probably just need to add the PRELOADFMT option to your DEFINE statement:

[pre]
define eval / across order=freq descending format=evaltyp. preloadfmt
center width=30 spacing=4 left "Evaluation Result";
[/pre]

You'd also need to have [pre]
OPTIONS MISSING=0;
PROC REPORT ....;
RUN;
[/pre]

or else you'll get a . for the missing.

cynthia

Re: Proc Report define "across" problem

deleted_user — Tue, 01 Jul 2008 16:58:28 GMT

Cynthia,
thank you very much. This is a perfect fix for my problem.