Interested to Buy Any Domain ? << Click Here >> for more details...
Under what circumstances would you code a SELECT construct
instead of IF statements?
- 4 Answers
- 15647 Views
- I also Faced
- E-Mail Answers
Answer Posted / alan
--when you have a long series of mutually exclusive
conditions and comparison is numeric
--CPU time is reduced when using SELECT statements
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How would you identify a macro variable?
How will you generate test data with no input data?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what is proc Index? and what is proc document?
what is sas olap server? : Sas-di
What is the difference between order and group variable in proc report?
Which command is used to perform sorting in sas program?
What are the features of base sas system?
what is metadata? : Sas-bi
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
How to create list output for cross-tabulations in proc freq?
explain the proc in sas? : Sas-administrator
How to read an input file in sas?
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 areas of SAS are you most interested in?
