Difference Between Scan and Substr
Answers were Sorted based on User's Feedback
Answer / yachna
There is only one difference between Scan & Substr..Just look at below example
eg. String = rajesh chauhan
If we want first four letter of the string then we can use Substr function here not scan..Scan function can pick first word.
SubName=Substr(String,1,4);
ScanName=Scan(String,1,' ');
Subname = raje
ScanName=rajesh
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / sudhir kumar
Both are function scan function Extracts nth position word
from string separated key dlm if n is -ve then starts at
end. and substr function extracts char string from start
position and with length .
| Is This Answer Correct ? | 9 Yes | 0 No |
Differentiate between ceil and floor functions.
Do you know the features of sas?
What is the length assigned to the target variable by the scan function?
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
what is AE onset date and what is RDS?
Give e an example of..
What is difference between sas rename and lable?
What are TEAEs
2 Answers Accenture, Quintiles,
how can u extract,transform and loading?