DATA Step, Macro, Functions and more

vertical concatenation based on 3 grouping variables

Reply
Occasional Contributor
Posts: 11

vertical concatenation based on 3 grouping variables

Hi Friends,

please resolve my issue

 

data have;
input sno seqnum codenum dnum  b$;
datalines;
1 1  100 2 a
1 2  100 3 b
1 5  100 3 c
1 6  100 3 d
1 4  200 2 e
1 5  200 2 f
1 6  200 3 g
1 7  200 3 h
2 3  150 2 i
2 5  150 3 j
2 6  150 4 k
2 1  250 2 l
2 2  250 3 m
2 1  300 2 n
3 11 200 2 o
3 12 200 3 p
3 13 200 3 q
3 15 200 4 r
3 10 250 2 s

;
run;

output like this:

1 100 3 a,b
1 100 3 a,c
1 100 3 a,d
1 200 2 e
1 200 3 f,g
1 200 3 f,h
2 150 4 i,j,k
2 250 3 l,m
2 300 2 n
3 200 4 o,p,r
3 200 4 o,q,r
3 250 2 s


here i gave already sorted data based on first 4 variables i need vertical concatenation

4th variable sequence is based on 2nd variable

please see input data i have added all patterns ..i have huge records like this 

and in original data 4th variable values are from 2 to20max.

 

based on 1st 3rd variable  grouping

dnum variable seq :

1) 2-3-4-5 seq give 1 line

2) 2-3-3 seq give 2lines   2,3 and 2,3

3) 2-3-4-4-5 seq gives 2lines  2,3,first4,5 and 2,3,second4,5

4) only 2  gives only 1 line 

 

Esteemed Advisor
Posts: 5,529

Re: vertical concatenation based on 3 grouping variables

Posted in reply to kyath_sas

Why isn't

 

1 200 3 e,g

1 200 3 e,h

 

part of the output table?

PG
Occasional Contributor
Posts: 11

Re: vertical concatenation based on 3 grouping variables

 

 in 1 4  200 2 e  line have only primary line

 

 

            2    primary

    3           3 secondary

            4       4 tertiary

                 5      5

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 2 in conversation