Interested to Buy Any Domain ? << Click Here >> for more details...
Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 16718 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 |
is there any difference between proc summary and proc means?
what techniques and/or procs do you use for tables? : Sas programming
What is the difference between SAS functions and procedures?
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
What is the basic syntax of a sas program?
What is the difference between using drop = data set option in data statement and set statement?
Identify statements whose placement in the DATA step is critical.
How can you limit the variables written to output dataset in data step?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
How to create list output for cross-tabulations in proc freq?
If money were no object, what would you like to do?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
Teradata 
