LIBNAME example '...............'; DATA example.EXAMPLE; INPUT ID Use_Date Use_Demand; FORMAT Use_Date DATE9.; DATALINES; 1 21931 3 2 21932 4 3 21933 4 4 21934 4 5 21935 5 ; RUN; DATA example.DUR_PRFILE; INPUT ID Use_Date Length_of_Use Percentage; FORMAT Use_Date DATE9.; DATALINES; 3 21931 1 0.333 4 21931 2 0.334 5 21931 3 0.333 6 21932 1 0.5 7 21932 4 0.5 8 21933 2 0.5 9 21933 3 0.5 10 21934 2 1 11 21935 1 1 ; RUN;