请教GENMOD的问题

shiyiming

程序如下：
data stat.insure;/*第二十七章1*/
        input n c car$ age @@;
        ln=log(n);
        cards;
500 42 small 1 1200 47 medium 1
100 1 large 1 400 101 small 2
500 73 medium 2 300 14 large 2
;
run;
proc genmod data=stat.insure;/*第二十七章4*/
        class car age;
        a=_name_;  b=_resp_;
        d=2*(y*log(y/a)-(y-a));
        variance var=a;
        deviance dev=d;
        model c=car age/link=log offset=ln;
run;
报错为：
ERROR:  A variable representing the mean must be specified.
请高手指点。
随便问一下导入EXCEL的问题，如果一个book里有很多sheet，怎么导入特定的一张？需要PROC IMPORT中哪个位置加什么参数？

shiyiming

导入excel的方法

PROC IMPORT OUT= dataset
            DATAFILE= "fileaddress\filename.xls"
            DBMS=EXCEL REPLACE;
     SHEET="sheetname$";
     GETNAMES=YES;
     MIXED=yes;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

shiyiming

多谢楼上，继续请教GENMOD的问题

shiyiming

Again, it's just a typo!For the Poisson distribution, variance=_mean_ instead of _name_.
[code:1kyyg6id]
proc genmod data=stat.insure;
class car age;
a=_mean_; y=_resp_;
d=2*(y*log(y/a)-(y-a));
variance var=a;
deviance dev=d;
model c=car age/link=log offset=ln;
run;
[/code:1kyyg6id]

shiyiming

Think you,I find another wrong place, I should use ln sbustitute y, for there is no y in the data set.