Thanks. this works. here is the code I used:
PROC SORT DATA=out2.Client_VL_Euci44_f
OUT=test1;
BY euci44 year;
RUN ;
data test;
set test1;
by euci44;
if first.euci then pattern = '3456';
if year = 2013 then substr(pattern, 1, 1) = '3';
else if year = 2014 then substr(pattern, 2, 1) = '4';
else if year = 2015 then substr(pattern, 3, 1) = '5';
else if year = 2016 then substr(pattern, 4, 1) = '6';
if last.euci44;
run;
proc freq data=test ;
table pattern;
run;
pattern
Frequency
Percent
Cumulative Frequency
Cumulative Percent
6
310244
67.23
310244
67.23
5
71554
15.51
381798
82.73
4
46492
10.07
428290
92.81
3
33186
7.19
461476
100.00
... View more