Interested to Buy Any Domain ? << Click Here >> for more details...
Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 16499 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 |
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
Do you need to know if there are any missing values?
For what purposes have you used sas macros? : sas-macro
What is the use of divide function?
What is the role of unrestrictive users? : sas-grid-administration
Why is SAS considered self-documenting?
Briefly explain input and put function?
Explain the purpose of substr functions in sas programming.
explain the main difference between the nodup and nodupkey options? : Sas-administrator
How to get part of string form the source string without using sub string function in SAS?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
Teradata 
