Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 15254 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chiranjeevi
SAS functions can be used to convert data and manipulate
character variable values.
different types of functions:1)TRIM
2)SUBSTR
3)ABS
4)SCAN
TRIM:Removing the trailing blanks from character expressions.
syntax=trim(argument)
substr:extracts the substring from an argument
syntax=substr(argument,position<,n>)
abs=returns the absolute of the argument
syntax=abs(argument)
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / ravi
The most common functions that would be used are-
Conversion functions - Input / Put / int / ceil / floor
Character functions - Scan / substr / index / Left / trim / compress / cat / catx / upcase,lowcase
Arithmetic functions - Sum / abs /
Attribute info functions – Attrn / length
Dataset – open / close / exist
Directory - dexist / dopen / dclose / dcreate / dinfo
File functions – fexist / fopen/ filename / fileref
SQL functions – coalesce / count / sum/ mean
Date functions – date / today / datdif / datepart / datetime / intck / mdy
Array functions – dim
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / ashok kore
1.Compress is one of the sas function which is used to
remove spaces in string value and concatenate two values
with out spaces.
2.Input is another function of sas, it is one of conversion
function in sas. It converts numeric into char.
3.Put is another conversion function in sas. It converts
char to numeric.
| Is This Answer Correct ? | 7 Yes | 19 No |
What do the mod and int function do? : Sas programming
what is study design in while working with SAS? what are screening variables in SAS?
I need level 2 to 5 sas using companies in india
How do you put a giraffe into the refrigerator?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
Mention some common errors that are usually committed in sas programming.
what is Business Intelligence?
How to create list output for cross-tabulations in proc freq?
Code a PROC MEANS that shows both summed and averaged output of the data.
what is the difference between proc means and proc tabulate?
Explain substr function?
Difference between informat and format?
Teradata 
