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...
Answer Posted / akhil126
data test;
input c $ 20.;
cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;
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
What is a macro routine?
how would you create multiple observations from a single observation? : Sas programming
What is slibref?
explain about sas business intelligence? : Sas-bi
What is the command used to find missing values?
what is slowly changing dimension? : Sas-di
What does the trace option do?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What is the basic structure of the SAS base program?
What is the difference between match merge and one to one merge?
How do dates work in sas?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
How does the internal authentication work in sas? : sas-grid-administration
Compare sas with other data analytics tools.
what are 5 ways to perform a table lookup in sas? : Sas-administrator