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
- 5535 Views
- Emerio, I also Faced
- E-Mail Answers
Answer / 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 |
What are the differences between proc means and proc summary?
When merging 2 datasets with a common variable (not merge key), how to keep both?
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
How is character variable converted into numeric variable and vice versa?
What is the difference between input and infile statement?
How to Rename Library?
How would you define the end of a macro? : sas-macro
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
which stats created by proc means that are not created by proc summary or vice versa?
what is SAS OPTIMIZATION?
Teradata 
