/* 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 / 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 is the difference between SAS Data step and SAS PROC SQL, and which is better?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
i want to upload titles and footnotes to excel file?how it is possible?
how we can create optional or required parameters in SAS macro...
What versions of SAS have you used (on which platforms)?
What are _numeric_ and _character_ and what do they do?
explain the concepts and capabilities of business object? : Sas-bi
what are the three main credit bureau names
1 Answers Synchrony Financial,
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?
what is the use of sas management console? : Sas-di
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.