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.
No Answer is Posted For this Question
Be the First to Post Answer
Explain the use of proc print and proc contents?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
How to get part of string form the source string without using sub string function in SAS?
What is instream data in SAS?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is the difference between Proc tabulate and Proc print
what the use of proc glm
what is operational data and operational system? : Sas-di
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
How to limit decimal places for the variable using proc means?
how many types of MERGE?