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 |
how many types prompting framework can be broken down to? : Sas-bi
In sas admin differentiate between roles and capabilities? : sas-grid-administration
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
Give some examples where proc report’s defaults are different than proc print’s defaults?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
Explain data_null_?
what is information maps?
What is SAS? What are the functions does it performs?
Write a SAS macro to calculate number of numbers in an email address
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
what are sas/access and sas/connect? : Sas programming