hello,   I am trying to do proc genmod. But I want only "Analysis Of Parameter Estimates" result, not other results such as Residues, Resraw, Reschi, Resdev, Stdreschi, Stdresdev,Reslik .  something like the following table. Anyone knows how to get it? thanks a lot.     Analysis Of GEE Parameter Estimates Empirical Standard Error EstimatesParameter   Estimate StandardError 95% Confidence Limits Z Pr > |Z|  Intercept 3.6125 3.6825 -3.6052 10.8301 0.98 0.3266 data ingots; input Heat Soak Notready Total @@; lnTotal= log(Total); datalines; 7 1.0 0 10 14 1.0 0 31 27 1.0 1 56 51 1.0 3 13 7 1.7 0 17 14 1.7 0 43 27 1.7 4 44 51 1.7 0 1 7 2.2 0 7 14 2.2 2 33 27 2.2 0 21 51 2.2 0 1 7 2.8 0 12 14 2.8 0 31 27 2.8 1 22 51 4.0 0 1 7 4.0 0 9 14 4.0 0 19 27 4.0 1 16 ; proc genmod data=ingots; class Heat Soak / param=ref; model Notready=Heat Soak / offset=lnTotal dist=Poisson link=log; exact Heat Soak / joint estimate; exactoptions statustime=10; run;     ... View more

Hello,    I tried a code with "if a>&missp then b=.; " it works. But when I tried  "if a>&missp/100 then b=.; " It did not work.  Why? What is the right way to condition with Macro calculation? Thanks ... View more

data eq; input ID y dm z w; cards; 1 1 . 40 8 1 0 . 29 37 1 1 30 . 25 1 1 38 38 23 2 1 30 45 19 2 0 30 20 . 2 1 67 . . 2 1 . 27 . 3 0 33 23 46 3 1 . 12 56 3 0 . . 34 3 1 . 45 . 4 1 56 45 23 4 0 67 13 67 4 0 . 35 13 4 1 48 35 56 ; run; data eq1; input ID y dm z w; cards; 1 1 30 . 25 3 1 . 45 . 4 1 48 25 56 ; run; data c; set eq; if dm=. then missindex=0; else missindex=1; if first.id then sumindex = missindex; else sumindex+missindex; by id; run; data d; set c; by id; if first.id and missindex=0 then output; if last.id and sumindex=1 then output; run; proc sql; create table want as select * from eq where id not in (select distinct id from d) ; quit; proc sql; create table eq4 as select * from want where id in (select distinct id from eq1) quit; proc sql; create table eq5 as select * from eq1 where id in (select distinct id from eq4) quit; data eq6; set eq5 eq4; run; What I want to do is delete the ID with first DM missing and delete the ID with all the rest DM missing except first DM in eq. Then, select the common ID to merge with eq1. So the result will be only ID 4 with 5 observations.   My code works. But it seems redundant. Could anyone help me to simplify it into one or two steps by sql and data step? Thanks ... View more

Hello, I want to remove some ID because the first DM is missing or all other DM is missing besides first DM (such as ID1 and ID3). However, my code did not work. anyone can help me to figure it out?  Thanks data eq; input ID y dm z w; cards; 1 1 . 40 8 1 0 . 29 37 1 1 30 . 25 1 1 38 38 23 2 1 23 45 19 2 0 32 20 . 2 1 67 . . 2 1 . 27 . 3 0 33 23 46 3 1 . 12 56 3 0 . . 34 3 1 . 45 . 4 1 56 45 23 4 0 67 13 67 4 0 . 35 13 4 1 48 35 56 ; run; proc sql; create table a as select * when first.dm ^= . when nmiss(of _numeric_) ^= count(of _numeric_)-1 from eq; group by id; quit; PROC SORT data=eq; by id; RUN; data b; set eq; by id ; if first.dm=. then delete; if nmiss(of _numeric_) ^= count(of _numeric_)-1 then delete; by id; run; ... View more