Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 11014 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What is the difference between class statement and by statement in proc means?
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
What is the difference between reading data from an external file and reading data from an existing data set?
explain about sas business intelligence? : Sas-bi
what has been your most common programming mistake? : Sas programming
what is the difference between floor and ceil functions in sas? : Sas-administrator
what do the pad and dim functions do? : Sas programming
Do you know the features of sas?
What is the function of Stop statement in a SAS Program?
How would you include common or reuse to be processed along with your statements?
what is Enterprise Guide?what is the use of it?
what are the categories that sas informats are used to the place the data? : Sas-administrator
Teradata 
