Oops, forgot to include the obligatory "Thanks in advance!" Scott

________________________________

From: White, Scott Sent: Friday, July 21, 2006 10:16 AM To: 'SAS(r) Discussion' Subject: Proc Freq Question Hi Folks, Let's say I have a data set with just three variables: observation id (oid), binary predicted value (pred) and dollar amount of transaction which we are making a prediction for (amt). Is there a way with just one proc statement to output a table that shows for both types of predictions both how many orders and what the total dollar amount was for each type? Basically the format of the desired output looks like this: Target|# Orders|$ Amount Yes|35|$1000 No|240|$10,000 The way I do it right now is to use two proc freqs one that uses the statement "weight amt;" and one that doesn't and then I merge the two to get the desired result.