what is data governance? : Sas-di
No Answer is Posted For this Question
Be the First to Post Answer
how the sas basic syntax style described? : Sas-administrator
How do you read in the variables that you need?
To what type of programms have you used scratch macros?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Describe 5 ways to do a “table lookup” in SAS?
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 its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
What is slibref?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
Do you need to know if there are any missing values?
What has been your most common programming mistake?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
/* 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;