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
- 11015 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
Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.
What is the use of the %include statement?
What do you know about sas data set?
How can you create a macro variable with in data step? : sas-macro
Give some ways by which you can define the variables to produce the summary report (using proc report)?
how many types prompting framework can be broken down to? : Sas-bi
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Explain what Proc glm does?
how to generate the test data in sas without input data? : Sas-administrator
Mention what is SAS data set?
What do you know about symput and symget?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Give some examples where proc report’s defaults are same as proc print’s defaults?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is star schema? : Sas-di
