LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Subject:      Compress function in a proc sql
Comments: To:
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


Back to: Top of message | Previous page | Main SAS-L page