Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 11217 Views
- TCS, I also Faced
- E-Mail Answers
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
Describe the function and untility of the most difficult SAS macro that you have written.
what is sas application server? : Sas-di
How are numeric and character missing values represented internally?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What do you understand by the term Normal Distribution?
Explain the use of proc gplot? : sas-grid-administration
How many ways to overcome a missing values???
what is the use of sas management console? : Sas-di
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)?
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 are the five ways to do a table lookup in sas? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Mention sas system options to debug sas macros.
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
How can you create a macro variable with in data step? : sas-macro
