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
Mention what is SAS data set?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
describe how to adjust the performance of data integrator? : Sas-di
how do the in= variables improve the capability of a merge? : Sas programming
What is the difference between order and group variable in proc report?
what do the pad and dim functions do? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specfications?
What do the mod and int function do? : Sas programming
What are the implications?
What system options would you use to help debug a macro? : sas-macro
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What is the use of function Proc summary?
What is the use of the %include statement?