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
Content-Type: text/plain; charset="us-ascii"
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.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of SAS_learner
Sent: Sunday, September 20, 2009 2:47 AM
Subject: How to create an dataset with 0 has value from Proc Freq
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 ;
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
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.