Date:         Tue, 13 Jan 2009 19:47:43 -0800
Reply-To:     Lilian <lilian.chee@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lilian <lilian.chee@GMAIL.COM>
Organization: http://groups.google.com
Subject:      How to use summary statistics, help!
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi all,
for the life of me i could not find anything/documentation on how to
use Summary Statistics transform in ETL (Data Intergration studio). I
keep getting the error when I manually enter the statistics i want
such as P95 and Mean.

NOTE: Appending data ...
ERROR: The following columns were not found in the contributing
tables: clientTime, connectTime, grossTime, Month, netTime,
       networkTime, numOfComponents, retransmissionTime, serverTime,
serverTimeToFirstBuffer, Session_Start_Date, sslTime,
       transactionSize, Year, _STAT_.
ERROR: SQL View WORK.MAPPED could not be processed.

If i leave the statistic option blank, it run's ok and gives me the
default stats of N, Mean, Min, Max and Std Dev. anyone?!

L.