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 versions of sas have you used (on which platforms)? : Sas programming
why is sas data integration studio important? : Sas-di
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What are the prime responsibilities of data integration administrator? : Sas-di
Describe 5 ways to do a “table lookup” in SAS?
why is sas considered self-documenting? : Sas programming
Which function is used to count the number of intervals between two sas dates?
What Proc glm does?
Why double trailing @@ is used in input statement?
If a variable contains letters or special characters, can it be numeric data type?
If you could design your ideal job, what would it look like?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How many data types are there in SAS?