Date:         Sat, 15 Nov 2008 13:13:52 +0200
Reply-To:     Peter <pete@SAKE.JP>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter <pete@SAKE.JP>
Organization: A noiseless patient Spider
Subject:      Re: can this code run as Proc SQL instead of data step?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; format=flowed; charset="Windows-1252";
              reply-type=response

I meant the Data Need part, pull all the variables from Data a, similar to
..

proc sql; create table need2 as
 select var1, var2_mode, var3, var5_flag,
  catx(',',,var4_type),
  catx(',',,scan(var7_color,2,':'))
   from a group by var1, var2_mode;
quit;


of course that does not work as intended