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 |
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
What is the difference between using drop = data set option in data statement and set statement?
explain about various caches available in data integrator? : Sas-di
Explain the message 'Merge has one or more datasets with repeats of by variables'.
what are different analysis datasets you created and what are the new variables created
Explain the difference between informat and format with an example.
what are the sites did u refer for enquiries and doubts for SAS
for report generation which one you used proc report or data_null_?
3 Answers Accenture, Quintiles,
how to handle in stream data containing semicolon in it?
what are informats in sas? : Sas-administrator
tell me about intnx, intcx functions?