vertical concatenation based on 3 grouping variables

kyath_sas — Wed, 04 Jul 2018 20:15:29 GMT

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

Re: vertical concatenation based on 3 grouping variables

PGStats — Wed, 04 Jul 2018 20:58:07 GMT

Why isn't

1 200 3 e,g

1 200 3 e,h

part of the output table?

Re: vertical concatenation based on 3 grouping variables

kyath_sas — Wed, 04 Jul 2018 21:21:11 GMT

in 1 4 200 2 e line have only primary line

2 primary

3 3 secondary

4 4 tertiary

5 5

topic Re: vertical concatenation based on 3 grouping variables in SAS Programming

vertical concatenation based on 3 grouping variables

Re: vertical concatenation based on 3 grouping variables

Re: vertical concatenation based on 3 grouping variables