https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6579#M659 Richard:<BR /> To code the equivalent of the PRE tags, do not use the LT and GT symbols, instead use square brackets.<BR /> '[' pre ']' <BR /> '[' /pre ']' without the spaces and quotes<BR /> <BR /> [pre]<BR /> some code<BR /> some more code<BR /> [/pre]<BR /> <BR /> cynthia Mon, 28 Jan 2008 16:38:22 GMT Cynthia_sas 2008-01-28T16:38:22Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6576#M656 I have data in field date1 = 200702 and date= 200608<BR /> <BR /> I need the result of date1-date2 = 6 months. How can i get it ? Mon, 28 Jan 2008 13:17:38 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6576#M656 deleted_user 2008-01-28T13:17:38Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6577#M657 the function you're looking for is <A href="http://support.sas.com/91doc/getDoc/lrdict.hlp/a000212868.htm">intck</A>. when given two date values, it returns the number of specified boundaries between the two values.<BR /> <BR /> if you've got actual date values, you'll probably want to use those. i assumed you didn't so there is some conversion from 200702 to '01FEB2007'd.<BR /> <BR /> [pre]<BR /> data temp;<BR /> date1 = 200608;<BR /> date2 = 200702;<BR /> d1 = input(put(date1, 6.), yymmn6.);<BR /> d2 = input(put(date2,6.), yymmn6.);<BR /> format d1 d2 date9.;<BR /> months = intck('month',d1, d2);<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Message was edited by: RichardK<BR /> added link to sas documentation<BR /> trying cynthia's tip Mon, 28 Jan 2008 14:27:13 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6577#M657 deleted_user 2008-01-28T14:27:13Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6578#M658 sorry about the format of the data step above...these forums don't seem to like html tags<BR /> <BR /> data temp;<BR /> date1 = 200608;<BR /> date2 = 200702;<BR /> d1 = input(put(date1, 6.), yymmn6.);<BR /> d2 = input(put(date2,6.), yymmn6.);<BR /> format d1 d2 date9.;<BR /> months = intck('month',d1, d2);<BR /> run; Mon, 28 Jan 2008 16:13:17 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6578#M658 deleted_user 2008-01-28T16:13:17Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6579#M659 Richard:<BR /> To code the equivalent of the PRE tags, do not use the LT and GT symbols, instead use square brackets.<BR /> '[' pre ']' <BR /> '[' /pre ']' without the spaces and quotes<BR /> <BR /> [pre]<BR /> some code<BR /> some more code<BR /> [/pre]<BR /> <BR /> cynthia Mon, 28 Jan 2008 16:38:22 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/how-to-get-number-of-months/m-p/6579#M659 Cynthia_sas 2008-01-28T16:38:22Z