Please see the distribution of type here. Type Frequency Percent Cumulative Frequency Cumulative Percent 40 174164 26.92 174164 26.92 39 95504 14.76 269668 41.68 37 38954 6.02 308622 47.70 38 29565 4.57 338187 52.27 25 27609 4.27 365796 56.53 7 23199 3.59 388995 60.12 8 22844 3.53 411839 63.65 36 21990 3.40 433829 67.05 44 20424 3.16 454253 70.20 42 19468 3.01 473721 73.21 24 18015 2.78 491736 76.00 999 17590 2.72 509326 78.71 9 16820 2.60 526146 81.31 32 13843 2.14 539989 83.45 5 13836 2.14 553825 85.59 35 12501 1.93 566326 87.52 33 9918 1.53 576244 89.06 15 7147 1.10 583391 90.16 3 6827 1.06 590218 91.22 43 6383 0.99 596601 92.20 41 5508 0.85 602109 93.05 30 4861 0.75 606970 93.81 34 4751 0.73 611721 94.54 27 4613 0.71 616334 95.25 21 4032 0.62 620366 95.88 22 3592 0.56 623958 96.43 6 3405 0.53 627363 96.96 20 3116 0.48 630479 97.44 18 2977 0.46 633456 97.90 28 2664 0.41 636120 98.31 26 2507 0.39 638627 98.70 12 2108 0.33 640735 99.02 29 2105 0.33 642840 99.35 31 1765 0.27 644605 99.62 19 1188 0.18 645793 99.81 4 901 0.14 646694 99.94 23 325 0.05 647019 99.99 14 35 0.01 647054 100.00 Can we decide on sparseness of data with just type distribution? ... View more

try adding the clause values before select clause ... View more

proc sort data=original; by col_1ID descending col_2date; run; data new (drop=prevdate); set original; by col_1ID descending col_2date; if (first.col_1ID=0) then prevdate=lag(col_2date); if (col_2date<today()) & ( today() < prevdate ) then col_4=col_3; run; May be you can sort it again in reverse order to get the dataset back in the original view. Please try and lets know! Thanks. ... View more

Exactly, just out of curiosity:) . ... View more

Guys; please note that the question was asked about 3 years back and probably he might have fixed it and who knows. Let's wait for his response to find what step he took. What do you say? ... View more

Try this: enddate1=intnx('month',date1,0,'end'); /*end date of date1 ? 30/31/28/29*/ enddate2=intnx('month',date2,0,'end'); format enddate1 enddate2 date9.; /*ddmmmyyyy*/ numdays1=day(enddate1); /*number of max days in that month*/ numdays2=day(enddate2); Months = (datdif (date1,enddate1, 'act/act')/numdays1 ) + intck('month',date1,date2)  +  (day(date2)/numdays2) -1; /* due to the limitation of intck function a -1 is adjusted*/ run; /*date1- date2*/ /*date1month+ date2month +and all months in between*/ Example: 5feb2014 - 17may2014 5feb-28feb/28  + 2+17may-1may/31 Cheers! ... View more