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 is the basic syntax style in SAS?
How do you control the number of observations and/or variables read or written?
I need level 2 to 5 sas using companies in india
what is treatment emergent events and treatment emregent adverse event
How would you determine the number of missing or nonmissing values in computations?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain bmdp procedure?
how to remove duplicates using proc sql?
What do you know about symput and symget?
Have you ever used the SAS Debugger?
What would you change about your job?
what is the difference between infile and input? : Sas-administrator
Are you involved in writing the inferential analysis plan? Tables specfications?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
why is a stop statement needed for the point=option on a set statement? : Sas programming