Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 14899 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 | 18 No |
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
how to delete the duplicate columns permanently in SQL
what is proc Index? and what is proc document?
What statement do you code to tell SAS that it is to write to an external file?
what is intially documentation in sas?
explain the key concept of sas? : Sas-administrator
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
What do the put and input function do?
Differentiate between sas functions and sas procedures.
What is the basic syntax of a sas program?
What are the automatic variables for macro? : sas-macro
what is Difference between PROC SQL JOINS and MERGE?
Teradata 
