/* 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 4274Post New Emerio Interview Questions
what command would you use to move the physical log?
What was your most rewarding accomplishment of your career and why
How many bytes will a s9(8) comp field occupy ?
How is the splitting of file invoked in Hadoop ?
Explain the my client center (mcc) account functions?
Why jsp is used instead of html?
What are bootstrap panels?
Explain why are oltp database designs not generally a good idea for a data warehouse?
When you use @@error and try-catch?
What is the use of background keyword in cucumber?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the engine efficiency range in two stroke engine?
How many primary keys can a table have?
What are the basic advantages of jms?
Do you know what is rubber fibers?