Date:         Sun, 20 Sep 2009 04:26:30 -0700
Reply-To:     RolandRB <rolandberry@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RolandRB <rolandberry@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How to create an dataset with 0 has value from Proc Freq
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Sep 20, 8:46 am, procconte...@GMAIL.COM (SAS_learner) wrote:
> 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

What you could do is to create a dummy dataset with zero values in it
and merge whatever comes out of proc freq on top of it and then use
the resulting dataset for your table.