topic Grouping Observations in SAS Procedures

Grouping Observations

GreggB — Tue, 31 Jul 2012 20:38:47 GMT

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

Re: Grouping Observations

Linlin — Tue, 31 Jul 2012 20:48:14 GMT

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;

Re: Grouping Observations

Haikuo — Tue, 31 Jul 2012 20:53:06 GMT

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