/* 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;
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
Name some categories in sas 9? : sas-grid-administration
What is the difference between class statement and by statement in proc means?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
what are all the reports you generated in your recent project?
What are the difference between ceil and floor functions in sas?
What is data _null_?
What would you change about your job?
What do the PUT and INPUT functions do?
Give e an example of..
what is function of retain statment
What are the data types that sas contain?
What is the difference between the proc sql and data step?
Explain how you can debug and test your SAS program?
What is program data vector (pdv)?
Describe what are the different levels of administrative users in sas? : sas-grid-administration