Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 19742 Views
- I also Faced
- E-Mail Answers
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 |
In the flow of DATA step processing, what is the first action in a typical DATA Step?
how to delete the duplicates by using proc sql?
Explain translate function?
what are the three main credit bureau names
1 Answers Synchrony Financial,
Explain by-group processing?
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
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.
where to use sas business intelligence? : Sas-bi
what are several options for creating reports in web report studio? : Sas-bi
What are the automatic variables for macro? : sas-macro
What is slibref?
: and & modifiers.
Teradata 
