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

What's the difference between VAR A1 - A4 and VAR A1 - A4?

1 Answers   Quintiles,

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  

for whom is sas data integration studio designed? : Sas-di

0 Answers  

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

how the sas basic syntax style described? : Sas-administrator

0 Answers  




what is chi-square test? have you used that?

1 Answers   Accenture, Quintiles,

What does PROC print, and PROC contents do?

0 Answers  

What is the difference between an informat and a format? Name three informats or formats.

13 Answers   Accenture, IBM,

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?

8 Answers   Accenture,

Difference between SAS STATA & SPSS?

0 Answers  

what is factor analysis? : Sas-administrator

0 Answers  

what is fact table and factless table?

1 Answers  

For more SAS Interview Questions Click Here
Categories