I need to find the numeric field which contains blank in
between..Ex:123 456...there is blank in between the 123
456..I need to know if there is any SAS function to find a
field..
Please suggest...
Answers were Sorted based on User's Feedback
Answer / kalyan
we can use index function to find any specific string.
test=index('123 456',' ') it will give 4, the position of blank. is this helpful?
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mahesh babu
data test;
a="123 456";
b=anyspace(a);
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amaranuswathi
Please suggest if any function is there to find to find the
particular field...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akhil
If I am having a data set c
data test;
input c $ 20.;
cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;
Now I am going to fetch observation having space in between,
data e(drop=e t);
set test;
e=length(c);
t=find(c,'');
if e>t;
run;
proc print data=e;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
how to perform paired t-test using Base/SAS & SAS/Stat?
What are exact SAS Base contents..?N what r SAS Tools..?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
in which companies SAS openings are there? List of companies using SAS technology.
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
What is the role of administrative users? : sas-grid-administration
what is hash files in sas and why we are using this one in sas?
Give e an example of..
explain the proc in sas? : Sas-administrator
Can you explain the process of calendar?
is data integration and etl programming is same? : Sas-di
In sas admin differentiate between roles and capabilities? : sas-grid-administration