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
- 5529 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
: and & modifiers.
what are the component of range? : Sas-bi
Are you involved in writing the inferential analysis plan? Tables specfications?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How many ways to overcome a missing values???
What is the basic syntax of a sas program?
How will you generate test data with no input data?
What is SAS informats?
what is the function of catx syntax? : Sas-administrator
what is the difference between floor and ceil functions in sas? : Sas-administrator
what r the job openings SAS for fresher graduates !
What are the implications?
what has been your most common programming mistake? : Sas programming
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What are the differences between proc means and proc summary?
