1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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?

Question Posted / sasguru

Answers were Sorted based on User's Feedback



When looking for data contained in a character string of 150 bytes, which function is the best to l..

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

When looking for data contained in a character string of 150 bytes, which function is the best to l..

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

When looking for data contained in a character string of 150 bytes, which function is the best to l..

Answer / mohan reddy

INDEX IS TEH BEST FUNCTION

Is This Answer Correct ?    6 Yes 4 No

When looking for data contained in a character string of 150 bytes, which function is the best to l..

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

When looking for data contained in a character string of 150 bytes, which function is the best to l..

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

When looking for data contained in a character string of 150 bytes, which function is the best to l..

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

When looking for data contained in a character string of 150 bytes, which function is the best to l..

Answer / surendra

INDEX is the best function

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More SAS Interview Questions

how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

0 Answers  

What do you feel about hardcoding?

1 Answers  

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  

Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  




How do you generate random samples?

5 Answers  

At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,

what has been your most common programming mistake? : Sas programming

0 Answers  

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

0 Answers   Quintiles,

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 Answers  

Have you ever used the SAS Debugger?

0 Answers   Quintiles,

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers   Accenture, Sciformix,

For more SAS Interview Questions Click Here
Categories