Date:         Thu, 3 Jul 2008 08:02:03 -0700
Reply-To:     Pietro_L <liege_come@YAHOO.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Pietro_L <liege_come@YAHOO.FR>
Organization: http://groups.google.com
Subject:      Compress function in a proc sql
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hello everybody,

I would like to use the compress function in proc sql:

proc sql;
select count(*) into:nb_tot from bea_ss_rc_m1_7;
create table toto as
        select  decile,
                compress("["||min(score)||";"||max(score)||"]")
length=10 as inter,
        count(*) as nb
from tata
group by decile;
quit;

But It doesn't work, I have this error message :
ERROR: Concatenation (||) requires character operands.

Anybody have advices.

Thank you for your help

PCL