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 |
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?
At compile time when a SAS data set is read, what items are created?
How to convert .xls file into CSV format?
Why is a STOP statement needed for the point=option on a SET statement?
how does sas handle missing values in formats? : Sas programming
What does proc print, and proc contents are used for?
What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???
Diff between proc sql merge and join?
proc means? proc sort? proc append? proc freq? proc print? proc content?
how the sas basic syntax style described? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
Explain append procedure?