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)

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

Answer / sheetal

trim
mean
today
intck
scan

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.

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

8 Answers   GSK GlaxoSmithKline,

---

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

---

what are several options for creating reports in web report studio? : Sas-bi

0 Answers  

---

Explain the special input delimiters used in sas programming.

0 Answers  

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

---

In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,

---

what is data access? : Sas-di

0 Answers  

---

IS SAS COMPILER OR INTERPRETER? EXPLAIN?

3 Answers   Aon Hewitt, HSBC, SCL, TCS,

---

Identify statements whose placement in the DATA step is critical?

11 Answers  

---

Diff between proc sql merge and join?

1 Answers   HSBC, Sristek,

---

i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.

2 Answers   Cap Gemini,

---

Approximately what date is represented by the SAS date value of 730?

0 Answers  

---