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 are the table names in oracle database...?
Explain translate function?
Explain why double trailing @@ is used in input statement?
describe how to adjust the performance of data integrator? : Sas-di
explain the concepts and capabilities of business object? : Sas-bi
Explain the purpose of retain statement.
What are the special input delimiters used in SAS?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What do you understand by the term Normal Distribution?
What is the function of output statement in a SAS Program?
What are types of transport files?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What is proc sort?
What do the PUT and INPUT functions do?
what are some differences between proc summary and proc means? : Sas programming