Interested to Buy Any Domain ? << Click Here >> for more details...
Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 16507 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 |
Given an unsorted data set, how to read the last observation to a new data set?
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
What statement do you code to write the record to the file?
Can you excute a macro within a macro? Describe.
what is data integration? : Sas-di
how many types prompting framework can be broken down to? : Sas-bi
What is the use of the %include statement?
how does sas handle missing values in sort order? : Sas programming
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is the difference between proc means and proc summary?
what is the use of catalog?
in ods is there any lib's
Teradata 
