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
- 5543 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 are the difference between the sas data step and sas procs?
Give e an example of..
what techniques and/or procs do you use for tables? : Sas programming
Describe 5 ways to do a “table lookup” in SAS?
what can you learn from the sas log when debugging? : Sas programming
Explain the use of proc gplot? : sas-grid-administration
Explain what is data step?
what are some good sas programming practices for processing very large data sets? : Sas programming
Differentiate between ceil and floor functions.
Explain the difference between using drop = data set option in set and data statement?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What are the automatic variables for macro? : sas-macro
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
Explain what is SAS informats?
what is slowly changing dimension? : Sas-di
