|
I need to calculate a figure which equates to the 'nearest' number of months between two dates. However the standard SAS function (INTCK) is not geared to consider the DAY of its date parameters (eg code below resolves to 0 when I need it to round to ...
Started by Bazil on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Z 8.; x="01APR08"d; y="28APR08"d; z=intck('MONTH',x,y); * wl is x + z months; wl=intnx('MONTH',x,z); * wu by the following:
data _null_; format x....
Data _null_; format x y date9.
You could use INTNX to see whether to round up or down, e.g.
|
|
Calculating age from birth date!
Hi all
I am stuck!! I want to calculate age of a person based on birth date, taking leap year into consideration.
For eg. if birth date is 01/03/1988 then what will be the age on 01/03/2006?
Thanks in advance!!
Started by praj on
, 7 posts
by 3 people.
Answer Snippets (Read the full thread at talkstats):
Is a good format) or you will end up with a SAS .
Make sure you use a format statement (DATE9.
Re: calculating age from birth date! This should work
(floor ((intck('month',
DOB,
DATE()) - (day later.
|
|
On Mon, 31 Aug 2009 08:39:58 -0700 (PDT), drraju123 <drraju123@gmail.com
hi i want to calculate no of months between 2 dates as follows
ex: from date1 to date2
date 1 = 18jan2008
date 2 = 05mar2009
it will be 13 months + ((31-18)+5)/31;
that ...
Started by drraju123 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Ref:
SAS Date, Time, and Datetime/lrdict/61724/HTML/default/a000245860....
*/
data
dte;fdosedt=13897;ldosedt=14233;
months=floor((intck('month',fdosedt,ldosedt)- (day can use the INTNX and DATDIF functions - and divide that by
31.
|
Ask your Facebook Friends
|
On Thu, 10 Sep 2009 23:29:39 -0700 (PDT), Michael <michaelnx@gmail.com
Hi,
Is there a way to write a function for the last friday of each month?
Thanks.
Mike
Started by Michael on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
%macro LastFridayOfMonth(Year=);
data LastFridayOfAllMonths&Year.(keep = Date Month = intnx("MONTH","01JAN&Year."d, i, 'E');
interval = intck("WEEK.6", beg, end);
Date = intnx.
And
intck functions.
|
|
On Mon, 7 Sep 2009 00:14:44 -0700 (PDT), naga <nagabiochem@gmail.com
hi sas experts
im having two varibale one is DOB and startdate
i want to find age from this two variable
i did like this but
age=(DOB-startdate)+1;
i got no of days difference ...
Started by naga on
, 6 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Services <sfbay0001@aol.com
There are two ways you might approach this problem:
1) Use the INTCK.
|
