topic Re: Summarizing character variables in SAS Programming

Summarizing character variables

SASACC — Wed, 20 Jan 2010 07:46:31 GMT

Pls help me summarising Character Variables.

I have a table as below :

CON RANK
INS1 1
INS2 1
INS3 2
INS5 2
ALC 2
RET 3

I want new table group by Rank.

i.e.

CON Rank
INS1/INS2 1
INS3/INS5/ALC 2
RET 3

I used First. And last. In that case I am missing the middle Value.

Re: Summarizing character variables

DanielSantos — Wed, 20 Jan 2010 08:59:53 GMT

Hi.

You must be using FIRST/LAST the wrong way.
[pre]
data OUTDATA;
length CON $200; * allocate new var;
set INDATA (rename=(CON=_CON)); * rename old var;
by RANK;
retain CON;
drop _:;
if first.RANK then CON=_CON; * reset at the beginning of the group;
else CON=catx('/',CON,_CON); * concatenate;
if last.RANK; * output at the end;
run;
[/pre]
Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Summarizing character variables

SASACC — Wed, 20 Jan 2010 10:30:30 GMT

Thanks it worked.