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 the use of proc contents and proc print in sas? : Sas-administrator
how to debug and test the sas program? : Sas-administrator
Describe what are the different levels of administrative users in sas? : sas-grid-administration
List out some key concept of SAS
What is a pdv and what are its functions?
What do the put and input function do?
Explain the purpose of substr functions in sas programming.
What is the basic structure of a sas program?
Do you need to know if there are any missing values?
Name and describe few sas character functions that are used for data cleaning in brief.
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what is ae onset date n what is RDS
where to use sas business intelligence? : Sas-bi
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what are the categories that sas informats are used to the place the data? : Sas-administrator