Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 11266 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Enlist the syntax rules followed in sas statements.
what is business intelligence? : Sas-bi
Mention what is PROC in SAS?
What is the role of administrative users? : sas-grid-administration
How to convert a numeric variable to a character variable?
For what purposes have you used sas macros? : sas-macro
explain the function of substr in sas? : Sas-administrator
how are numeric and character missing values represented internally? : Sas programming
What system options would you use to help debug a macro? : sas-macro
what is sas olap server? : Sas-di
How many data types are there in SAS?
Explain how merging helps to combine data sets.
What are the data types does SAS contain?
What is the difference between where and if statement?
explain the use of % includes a statement in sas? : Sas-administrator
