Date:         Fri, 21 Aug 2009 16:22:52 -0700
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      How to assign Length inside Proc Sql ??
Content-Type: text/plain; charset=ISO-8859-1

I tried something but this is not working any other way other than creating
a dataset before or after

Proc Sql Noprint ;
Create table F_First_line as
  Select
      Count (Distinct Usubjid ) as Col_1 ,
     (Calculated Col_1 / &Main_Count.)*100 as per ,
     Put( Calculated Col_1, Best. ) !!' ( '!!Strip(Put(Calculated Per, 3.)
)!!')'  as Col1, 0.5 as Sec,
     "Number of subjects with an event" as R_text Char(200)
From  Col_1
Where Incidence ^= '' ;
Quit;

Thanks For your time and help

SL