for whom is sas data integration studio designed? : Sas-di
No Answer is Posted For this Question
Be the First to Post Answer
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
How do you read in the variables that you need?
/* 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;
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
What is the pound sign used for the DATA _NULL_?
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
Which command is used to perform sorting in sas program?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
what are the benefits of data integration? : Sas-di
Enlist the syntax rules followed in sas statements.
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
what is the usage for assigning error=1 in a dataset ?