topic combining sets of observations by name in SAS Programming

combining sets of observations by name

lillymaginta — Wed, 06 Apr 2016 14:23:47 GMT

Hi All, I have the following dataset; What I am trying to doe is to combine the total frequency by name. Some of the names are composed of two words with a space in the middle.

med_code freq  name 
0001 50   ar
222  3     ar 
444 3     ar 
555  2   al as
666 1   al as 



Here is the output I am looking to get

ar      56
al as  3

Re: combining sets of observations by name

Kurt_Bremser — Wed, 06 Apr 2016 14:27:44 GMT

proc sql;
create table want as
select name,sum(freq)
from have
group by name;
quit;

Re: combining sets of observations by name

LinusH — Wed, 06 Apr 2016 14:28:04 GMT

Simple SQL w sum() and group by.

Re: combining sets of observations by name

lillymaginta — Wed, 06 Apr 2016 14:33:44 GMT

Thank you!

Re: combining sets of observations by name

lillymaginta — Wed, 06 Apr 2016 14:34:29 GMT

Thank you!