what are the benefits of data integration? : Sas-di
No Answer is Posted For this Question
Be the First to Post Answer
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what are input dataset and output dataset options?
how to assign a macro value to a variable?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
/* 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;
How do you read in the variables that you need?
if we dont want to print output what we have to do..???give syntax..???
8 Answers Accenture, GSK GlaxoSmithKline,
how to intersect the tables by using PROC MIXED?
Which date function advances a date, time or datetime value by a given interval?
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
What Proc glm does?
Under what circumstances would you code a SELECT construct instead of IF statements?