Interested to Buy Any Domain ? << Click Here >> for more details...
/* This is example of age caluculate wihtout to display
perfect days and years in output window */
data age;
retain dob "12jun2003"d now "24may2011"d;
age1=now-dob;
age=(now-dob)/365.25;
years=int(age);
days1=round((age-years)*365.25);
months=month(now)-1;
if days1 gt 30 and months in(12,10,8,6,4,2)then do;
month1=days1/30.4375;
month=int(days1/30.4375);
if day(now)=1 then days=1;
else days=round((month1-month)*30.4375)+1;
drop days1 month1 month;
end;
else if days1 gt 30 and months in
(1,3,5,7,9,11)then do;
month1=days1/30.4375;
month=int(days1/30.4375);
if day(now)=1 then days=1;
else days=round((month1-month)
*30.4375);
drop days1 month1 month;
end;
drop age age1;
proc print data=age;
format dob now date.;
run;
- 1 Answers
- 5464 Views
- Emerio, I also Faced
- E-Mail Answers
Answer Posted / muralavenu
Year and Day is fine. but Month is calculating from
current month onwords(i.e. ending to starting instead of
starting to ending). How to get rid of this problem. Plz
find out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is information maps?
which date function advances a date, time or datetime value by a given interval? : Sas programming
Differentiate input and infile.
How would you identify a macro variable? : sas-macro
what are the scrubbing procedures in sas? : Sas programming
how are numeric and character missing values represented internally? : Sas programming
What is by-group processing?
what is slowly changing dimension? : Sas-di
describe the interaction table in sas di? : Sas-di
What sas features do you use to check errors and data validation?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Briefly explain input and put function?
Describe the ways in which you can create a macro variable?
What is PROC in SAS?
