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 / akhil126
data test;
input c $ 20.;
cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;
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 is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What is slibref?
Describe the function and untility of the most difficult SAS macro that you have written.
what do you mean by data staging area? : Sas-di
What would you change about your job?
Describe the ways in which you can create macro variables? : sas-macro
How can I remove header from output data set?
How would you determine the number of missing or nonmissing values in computations?
what are sas/access and sas/connect? : Sas programming
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is sas business intelligence? : Sas-bi
Did you used proc test? when?
Differentiate between proc means and proc summary.
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
What are the different versions of sas that you have used until now? : sas-grid-administration