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
- 19666 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 |
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
how to import HTML files into SAS datasets?
How to save the log information in a file for future use
Hot to suppress characters from a given string?
What is proc sql pass through facility?
what is the difference between proc means and proc summary?
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
what is the use of proc sql?
Mention what is PROC in SAS?
Teradata 
