Date:         Sun, 20 Sep 2009 20:35:34 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: How to create an dataset with 0 has value from Proc Freq
Comments: To: SAS_learner <proccontents@GMAIL.COM>
In-Reply-To:  <c2192a610909192346o7503591cx761c3814dafaed4@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

SL:
This request made more sense before I read it carefully ...

What values do XU_BIN and XL_BIN have when the condition holds? I'd say in general you can't know because the data that you have does not include observations from the prescribed Arm and Event.

SAS consistently returns missing values for undefined outcomes. Similarly, SAS doesn't return observations where none exists. If, for example, X?_BIN represent an upper or lower bound on a statistical estimate, an estimate based on observations that don't exist in data should have a missing value and missing bounds values.
S

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of SAS_learner
Sent: Sunday, September 20, 2009 2:47 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to create an dataset with 0 has value from Proc Freq

Hello all,

5691  Proc Freq Data = Val_adsl_ae1(Where = (Arm In ('375') and Event_Inc1 =
1 ))   Noprint  ;
5692   Table  Inc_n  /Binomial (Level= '1'  ) ;
5693   Output Out = est2_t1 (keep = XU_BIN XL_BIN)  Binomial ;
5694  Run;

NOTE: No observations were selected from data set WORK.VAL_ADSL_AE1.
NOTE: There were 0 observations read from the data set WORK.VAL_ADSL_AE1.
      WHERE (Arm='375') and (Event_Inc1=1);
NOTE: The data set WORK.EST2_T1 has 0 observations and 0 variables.
WARNING: Data set WORK.EST2_T1 was not replaced because new file is
incomplete.

I want the resulting dataset to be 0 for both CU_BIN and XL_BIN in the
values so that I can use it for my table ?? Any ides how to do it.

thanks
SL