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 / 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 |
Post New Answer View All Answers
What are the special input delimiters used in SAS?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what is the difference between unique key and primary key? : Sas-di
Define run-group processing?
How to create a permanent sas data set?
What is a macro routine?
describe about physical data integration? : Sas-di
What do you know about sas data set?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How do you use the do loop if you don’t know how many times you should execute the do loop?
Explain data_null_?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What are the functions used for character handling?
What commands are used in the case of including or excluding any specific variables in the data set?
where to use sas business intelligence? : Sas-bi