/**********************************************************************/ /* Example 1 - Creating a SAS date from a month and year */ data one; input id mon yr; cards; 1 01 95 2 06 94 3 11 95 4 12 90 ; proc sort; by mon yr; run; ________________________________________________________________________ OUTPUT OBS ID MON YR 1 1 1 95 2 2 6 94 3 3 11 95 4 4 12 90 /**********************************************************************/ data two; set one; newdt=mdy(mon,1,yr); format mmyys5.; run; proc sort; by newdt; run; ________________________________________________________________________ OUTPUT OBS ID MON YR NEWDT 1 4 12 90 12/90 2 2 6 94 06/94 3 1 1 95 01/95 4 3 11 95 11/95 /**********************************************************************/ data one; input id monyr $; cards; 1 JAN95 2 JUN94 3 NOV95 4 DEC90 ; data two; set one; tempdt='01'||monyr; newdt=input(tempdt,date7.); format newdt monyy5. run; ________________________________________________________________________ OUTPUT OBS ID MONYR TEMPDT NEWDT 1 1 JAN95 01JAN95 JAN95 2 2 JUN94 01JUN94 JUN94 3 3 NOV95 01NOV95 NOV95 4 4 DEC90 01DEC90 DEC90 /**********************************************************************/ /* Example 2 - Creating a SAS date based on another SAS date */ data one; x='10apr95'd; new1=intnx('month',x,3); new2=intnx('month',x,-1); run; proc print; format x new1-new2 date9.; run; ________________________________________________________________________ OUTPUT OBS X NEW1 NEW2 1 10APR1995 01JUL1995 01MAR1995 /**********************************************************************/ /* Example 3 - Determining the number of intervals between */ /* SAS dates */ data one; start='01jan96'd; end='31mar96'd; wkvar1=intck('week',start,end); wkvar2=intck('week2',start,end); wkvar3=intck('week.2',start,end);i wkvar4=intck('week2.2',start,end); run; proc print; format start end mmddyy8.; run; ________________________________________________________________________ OUTPUT OBS START END WKVAR1 WKVAR2 WKVAR3 WKVAR4 1 01/01/96 03/31/96 13 7 12 6 /**********************************************************************/