Date:         Fri, 14 Apr 2006 19:44:03 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: a WARNING on PROC TRANSPOSE
Comments: To: mehedisas@YAHOO.COM
In-Reply-To:  <200604141933.k3EH28Tv014025@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

I dont think there is a statement or option for that:

If you use an ID variable that contains a missing value, then PROC TRANSPOSE
writes an error message to the log. The procedure does not transpose
observations that have a missing value for the ID variable.







Toby Dunn





From: Rathindronath <mehedisas@YAHOO.COM>
Reply-To: Rathindronath <mehedisas@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: a WARNING on PROC TRANSPOSE
Date: Fri, 14 Apr 2006 15:33:31 -0400

I have a following Proc transpose program:


proc transpose data = db_GRRR
                 out = db_GRR1;
       by protocol TRT siteid subjid trtgrpn invname sexn;
    id dstermn;
    var sexn;
  run;


I am getting the following warning while I am running the program:

WARNING: 210 observations omitted due to missing ID values.

I know the program is correct and giving me the result I expected. But
reason it is giving the error is the Given Dataset I am working with has
value for the ID variable DSTERMN for few rows the rest of the row don’t
have value (for DSTERMN). In real world they are not missing they just
should not be there for all the rows as the way it is in the below dataset
( part of the dataset is shown below):

Obs    SITEID    SUBJID    SEXN    TRTGRPN    DSTERMN    trt    protocol
  87      02      50105      2         3          1        3     0003-11
  88      02      50107      2         3                   3     0003-11
  89      02      50111      1         3                   3     0003-11
  90      02      50113      2         3                   3     0003-11
  91      06      50122      1         3          3        3     0003-11
  92      06      50125      1         3                   3     0003-11
  93      06      50128      2         3                   3     0003-11
  94      06      50132      2         3          5        3     0003-11


I know there is a way to avoid this kind of warning by writing a small
statement about missing ID variable ( such as: DSTERMN ne .  / or
something like that), But can not remember it. Would you please be kind
enough to give me an idea how can I avoid this warning with having any
effect in the result.

THANKS A LOT IN ADVANCE