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
- 19973 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 |
How to Rename Library?
For what purposes have you used sas macros? : sas-macro
what is Business Intelligence?
if we dont want to print output what we have to do..???give syntax..???
8 Answers Accenture, GSK GlaxoSmithKline,
Are you involved in writing the inferential analysis plan? Tables specfications?
Did you used proc test? when?
0 Answers Accenture, Quintiles,
What is the purpose of using the N=PS option?
how do you read binary data in sas?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
What is criteria for adverse events and treatment-emergent adverse events?
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
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.
Teradata 
