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 |
wat is sas? is a package or programming language?
How do you download a flat file from Mainframe to your local PC using SAS?
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
What SAS statements would you code to read an external raw data file to a DATA step?
How do you put a giraffe into the refrigerator?
What is SAS?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the applications primarily used by business analyst? : Sas-bi
Explain what is data step?
how can get the first and last observations in a dataset using Proc SQl?
Do you need to know if there are any missing values?