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 |
What is the function of output statement in a SAS Program?
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
Name and describe three SAS functions that you have used, if any?
what is the difference between the SAS v8 and SAS v9?
How experienced are you with customized reporting and use of Data _Null_ features?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
What is the purpose of _error_?
how do u test a pros sql(works or not) without executing it?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
What statement do you code to write the record to the file?
How to create list output for cross-tabulations in proc freq?
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com