Name and describe three SAS functions that you have used, if
any?
- 4 Answers
- 14870 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 is sas application server? : Sas-di
How to get part of string form the source string without using sub string function in SAS?
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
how do we get duplicate observations in a separate dataset?
Write a SAS macro to calculate number of numbers in an email address
What is the basic structure of a sas program?
How do you download a flat file from Mainframe to your local PC using SAS?
What are the uses of sas?
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
How would you remove a format that has been permanently associated with a variables?
Teradata 
