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...
Answer Posted / 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 |
Post New Answer View All Answers
What Proc glm does?
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is the difference between unique key and primary key? : Sas-di
What do the put and input function do?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
Did you used proc test? when?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What are the difference between ceil and floor functions in sas?
Explain translate function?
Differentiate between ceil and floor functions.
How to include or exclude specific variables in a data set?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What are the difficulties u faced while doing vital signs table or dataset?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?