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 |
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
what does .. meant in sas macros
Name some categories in sas 9? : sas-grid-administration
Approximately what date is represented by the SAS date value of 730?
how many types prompting framework can be broken down to? : Sas-bi
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?
What is PDV?
What is the order of evaluation of the comparison operators: + - * /** ()?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
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 fact table and factless table?