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
- 19712 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 |
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what are the differences between proc report and proc tabulate?
Name statements that function at both compile and execution time.
What can be the size of largest dataset in SAS?
for whom is sas data integration studio designed? : Sas-di
In sas, what are the areas that you are most interested in? : sas-grid-administration
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
One way of creating a new variable in Macros is by % Let....What is the other way..?
Where do the database management systems store data and how do u import them.
Code a PROC MEANS that shows both summed and averaged output of the data.
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
Teradata 
