Here is the sample data data WORK.TEST; infile datalines dsd truncover; input LBTESTCD:$8. LBSTRESN:32. SUBJID:$9. WEEKS:32.; datalines4; SHDC,333032.03,102,0.1428571429 SHDC,290878.55,102,0.4285714286 SHDC,319447.4,102,1 SHDC,486860.71,102,2 SHDC,134068.56,102,3 SHDC,90190.05,102,4 SHDC,12000,102,6.1428571429 SHDC,12000,102,8 SHDC,12000,102,9 SHDC,,102,11.142857143 SHDC,,021,0.1428571429 SHDC,,021,0.4285714286 SHDC,,021,1.1428571429 SHDC,4395487.68,021,2 SHDC,7791809.28,021,3 SHDC,312460.46,021,4.1428571429 SHDC,52215.81,021,5 SHDC,12000,021,6 SHDC,12000,021,7 SHDC,12000,021,8 SHDC,12000,021,9 SHDC,12000,021,10 SHDC,34323.01,021,11 SHDC,12000,021,12 SHDC,12000,021,13 SHDC,12000,021,14.142857143 SHDC,12000,021,16 SHDC,1,022,-2.714285714 SHDC,75846.22,022,0.1428571429 SHDC,594414.43,022,0.5714285714 SHDC,350789.16,022,1 SHDC,434236.45,022,2 SHDC,220518.29,022,3 SHDC,37704.41,022,4.1428571429 SHDC,12000,022,5.1428571429 SHDC,12000,022,6 SHDC,12000,022,7 SHDC,12000,022,8 SHDC,1,022,9 SHDC,1,001,-1 SHDC,12000,001,0.1428571429 SHDC,74771.36,001,0.4285714286 SHDC,60308.3,001,1 SHDC,40144.87,001,2 SHDC,12000,001,4 SHDC,12000,001,5 SHDC,12000,001,6 SHDC,12000,001,7 SHDC,12000,001,8 SHDC,1,001,9 SHDC,1,001,10 SHDC,1,001,11 SHDC,1,001,12 SHDC,,001,13.142857143 SHDC,,001,14 SHDC,,001,15 SHDC,,001,28.285714286 SHDC,1,002,-1 SHDC,12000,002,0.1428571429 SHDC,12000,002,0.4285714286 SHDC,12000,002,1.2857142857 SHDC,12000,002,2.4285714286 SHDC,12000,002,3 SHDC,12000,002,4 SHDC,12000,002,5 SHDC,,002,6.1428571429 SHDC,,002,7 SHDC,1,002,8 SHDC,1,002,9 SHDC,12000,002,10 SHDC,1,002,11 SHDC,1,002,12 SHDC,1,002,13 SHDC,1,002,14 SHDC,1,002,15 SHDC,,002,16 SHDC,,002,20 SHDC,1,003,-1.142857143 SHDC,238238.52,003,0.1428571429 SHDC,426241.73,003,0.4285714286 SHDC,973322.23,003,1.2857142857 SHDC,268264.28,003,1.8571428571 SHDC,175213.31,003,2.8571428571 SHDC,29571.7,003,4 SHDC,12000,003,4.8571428571 SHDC,12000,003,5.8571428571 SHDC,12000,003,6.8571428571 SHDC,12000,003,7.8571428571 SHDC,1,123,-1 SHDC,7052629.92,123,0.1428571429 SHDC,50180642.4,123,0.4285714286 SHDC,16152353.28,123,1 SHDC,6006247.44,123,2 SHDC,4360246.56,123,3.1428571429 SHDC,431407.26,123,4 SHDC,57950.34,123,5 SHDC,30263.48,123,6 SHDC,12000,123,7 SHDC,1,124,-2 SHDC,2951737.13,124,1 SHDC,2206464.96,124,2 SHDC,280740.86,082,0.1428571429 SHDC,5193730.08,082,1 SHDC,17723615.04,082,2 SHDC,651633.96,082,4 SHDC,12000,082,6 SHDC,12000,082,7 SHDC,12000,082,8 ;;;;
... View more