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

Post New Answer

More SAS Interview Questions

Hot to suppress characters from a given string?

4 Answers   CTS,


how does sas handle missing values in an update? : Sas programming

1 Answers  


Describe the ways in which you can create a macro variable?

0 Answers  


What system options would you use to help debug a macro? : sas-macro

0 Answers  


What is SAS?

0 Answers  






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...

5 Answers   TCS,


/* 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 Answers   Emerio,


Describe the function and utility of the most difficult SAS macro that you have written?

0 Answers   Oracle,


how do you test for missing values? : Sas programming

0 Answers  


What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,


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.

2 Answers  


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

0 Answers  


Categories