Grouping Observations

[GreggB]

Name                    city                         county                 

Ann                        A                             1                             

Betty                      B                             2                             

Carol                      A                             1                             

Dave                      B                             2                             

Ethel                      A                             2                             

I want to output a file that groups by county and then city and write those obs on one line with the names listed that are associated with that city and county, like so:

Name                    city                         county

Ann, Carol           A                             1

Betty, Dave         B                             2

Ethel                    A                             2

[Linlin]

data have;
input Name :$                   city :$                  county;
cards;
Ann                        A                             1                             
Betty                      B                             2                             
Carol                      A                             1                             
Dave                      B                             2                             
Ethel                      A                             2
;
proc sort;
by county city name;

data want;
retain new;
length new  $50;
set have;
by county city;
new=catx(',',new,name);
if last.city then do;
output;
call missing (new);
end;
proc print;run;

[Haikuo]

Or using DOW:

data have;

infile cards;

input (Name                    city                         county) (:$);

cards;

Ann                        A                             1                            

Betty                      B                             2                            

Carol                      A                             1                            

Dave                      B                             2                            

Ethel                      A                             2    

;

proc sort data=have;

by county city;

run;

data want;

length group $40;

do until (last.city);

set have;

by county city;

group=catx(',',group,name);

end;

run;

proc print;run;

Haikuo