From: QiJun Fung on
Hi all,
I encountered a problem in my project. I use proc means to
generate the frequency talbe like below. As you notice, when count is
zero, the output statement in proc means will not produce the record.
That is why there is no record for "Atlanta 2004M02 with Y" and
"Dallas 2004M01 with N". And I have more than 100 records with 0 count
not showing in this table. Now I want to run possion model, I have to
make up thoes records. I have no idea how to make up thoes records.
Can you give me some help? Thanks very much.

The proc means syntax I used is:
proc meas data=one;
class city date disease;
var a;
output two N(a)=ncount;
run;

frequency table:
city date disease count
Atlanta 2004M01 N 23
Atlanta 2004M01 Y 2
Atlanta 2004M02 N 12
Atlanta 2004M03 N 34
Atlanta 2004M03 Y 3
........... ............ . .

Dallas 2004M01 Y 23
Dallas 2004M02 N 2
.......... ............. . .
From: Patrick on
Have a look at the classdata= option for Proc Means (http://
support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000146729.htm).
From: QiJun Fung on
On May 12, 5:49 am, Patrick <patrick.mat...(a)gmx.ch> wrote:
> Have a look at the classdata= option for Proc Means (http://
> support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000146729.htm).

Thanks, I got it.