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 / 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
What will calendar procedure do?
What are the difference between sas functions and procedures?
what is factor analysis? : Sas-administrator
What can be the size of largest dataset in SAS?
What are the default statistics that proc means produce?
How can sas program be validated?
explain about data integrator metadata reports? : Sas-di
Differentiate between format and informat? : sas-grid-administration
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Explain data_null_?
Given an unsorted data set, how to read the last observation to a new data set?
What are the 3 components in sas programming?
What is the role of unrestrictive users? : sas-grid-administration
Explain substr function?
What are the features of base sas system?