DATA Step, Macro, Functions and more

Summarizing character variables

Reply
Occasional Contributor
Posts: 15

Summarizing character variables

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.
Super Contributor
Posts: 474

Re: Summarizing character variables

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
Occasional Contributor
Posts: 15

Re: Summarizing character variables

Thanks it worked.
Ask a Question
Discussion stats
  • 2 replies
  • 100 views
  • 0 likes
  • 2 in conversation