On Mon, 6 Aug 2007 20:24:26 -0400, Scott Bass <sas_l_739@YAHOO.COM.AU> wrote:
>I would think I would have known how to do this by now, but alas I don't :-
>Say I have the following data step:
> length key 8 var $1;
> input key var;
> set one;
> by key;
> length newvar $200;
> retain newvar;
> if first.key then newvar = "";
> newvar = catx(" ",newvar,var);
> if last.key then output;
>Is there a way to create this dataset using PROC SQL only?
None that I can visualize. The results are sensitive to the original order
of the rows, and SQL does not recognize order.
>just use the data step, but the customer would prefer SQL if possible.