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.

2257

How do you create a text file in linux terminal?

1007

Who is the founder of niacl? What do you know about niacl?

995

Tell us what is fashion color?

1

Elaborate the situation where automation testing can’t be used for agile methods?

945

What is self-service business intelligence?

1

What is difference between fluid layout and responsive layout?

3

How pm module is integrated with ps module?

959

Is sql different from sql server?

1058

What would you do if a customer refuses to fix a meeting with you?

1114

How is machine learning used in the movement?

161

pls provide me a placement paper for HPCL exam for Elecronics & communication exam. this is a request pls do the needful as early as possible.

1996

Is age an interval or ratio?

946

what is Acute Lower Respiratory Tract Infection?

2078

How can an index be declared in mysql?

926