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
- 5539 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 |
how can you improve the performance of a query, If it is excuting very slowly?
How do dates work in SAS data?
What report output formats can you generate using SAS?
Hot to suppress characters from a given string?
how do you pull data from equifax?tell me the process?
0 Answers Synchrony Financial,
What is the order of evaluation of the comparison operators: + - * /** ()?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
what are methods to identify duplicate observations?
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
define table lookup and how may ways it can be done...explian
What are the applications primarily used by business analyst? : Sas-bi
What statement do you code to tell SAS that it is to write to an external file?
Teradata 
