Do you prefer Proc Report or Proc Tabulate? Why?
Answer Posted / nishant
I depends on the situation where we use it.
I use proc tabulate when we need to produce matrix-style
reports which is preferred. with proc report we can produce
columnar-style report.
Is This Answer Correct ? | 12 Yes | 1 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.
why a stop statement is needed for the point= option on a set statement?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what versions of sas have you used (on which platforms)? : Sas programming
how the sas basic syntax style described? : Sas-administrator
What is slibref?
How to test the debugging in sas?
Explain proc sort?
What does the RUN statement do?
What is program data vector (pdv) and what are its functions?
how many display types available in sas bi dashboard? : Sas-bi
what are all the reports you generated in your recent project?
Explain bmdp procedure?
what is transformation in sas data integration? : Sas-di
How would you identify a macro variable? : sas-macro