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...
Answers were Sorted based on User's Feedback
Answer / kalyan
we can use index function to find any specific string.
test=index('123 456',' ') it will give 4, the position of blank. is this helpful?
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mahesh babu
data test;
a="123 456";
b=anyspace(a);
run;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amaranuswathi
Please suggest if any function is there to find to find the
particular field...
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How do you test for missing values?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
define table lookup and how may ways it can be done...explian
how will you location sas platform applications available from web browser? : Sas-bi
Which command is used to perform sorting in sas program?
what is the diff. b/w proc means and proc summary?
How do dates work in SAS data?
proc means? proc sort? proc append? proc freq? proc print? proc content?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
Where do you use proc means over proc freq?
How do you add a prefix to some or all variables in a dataset using a SAS macro?
how could you generate test data with no input data? : Sas programming