Name and describe few sas character functions that are used for data cleaning in brief.
No Answer is Posted For this Question
Be the First to Post Answer
Hot to suppress characters from a given string?
how does sas handle missing values in an update? : Sas programming
Describe the ways in which you can create a macro variable?
What system options would you use to help debug a macro? : sas-macro
What is SAS?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
/* 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;
Describe the function and utility of the most difficult SAS macro that you have written?
how do you test for missing values? : Sas programming
What are the limitations for memory allocation for SAS variables
Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.
what do the mod and int function do? What do the pad and dim functions do? : Sas programming