When looking for data contained in a character string of 150
bytes, which function is the best to locate that data: scan,
index, or indexc?
Answers were Sorted based on User's Feedback
Answer / ganesh
Scan function the best for locating the particular word
specified in a argument,scan function default length is
200bytes.
data k;
r='ganesh kumar';
u=scan(r,2);
proc print;
run;
result: kumar
| Is This Answer Correct ? | 10 Yes | 7 No |
Answer / prr
Hi Friends,
actually I can't able to understand the question.
please repeat again in a understandable way.
scan: it returns Nth word from character observation.
index: it return starting position of the character from
character observation.
index C: it returns starting position of any character from
character observation.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rinky
The questions is to locate and not to extract any
particular word from a string of 150 bytes. SO, according
to me INDEX is the best.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / jothi sankar
INDEX is best one. Is for getting location of mentioned
data.
Eg:
str1 = 'Hi i am fine here. how are u there ? .....';
str2 = index(str1,'how'); --> str2 = 20
SCAN is to get a substring upto mentioned character
INDEXC to locate only for mentioned one or more single
character
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / yaga
I think Index is the best option to locate the word
beacause SCAN is SAS function to extract the particular
word positioned in nth place. for ex: 2 word from the string
| Is This Answer Correct ? | 1 Yes | 1 No |
how do u test a pros sql(works or not) without executing it?
What are the parameters of scan function?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
what is study design in while working with SAS? what are screening variables in SAS?
Name statements that are execution only?
How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
Explain proc sort?
List down the reasons for choosing sas over other data analytics tools.
What versions of SAS have you used (on which platforms)?
for what purpose would you use the retain statement? : Sas programming
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?