Why do we need linked lists?

527

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.

1782

Which books are helpful for practising accounting's most tricky sums?

1156

How do I find my server for outlook?

1

What are different cursor types in dbms?

537

Transmission through a short line depends on

1684

When I try to open the cloud connector ui, google chrome opens a save as dialog, firefox displays some cryptic signs, and internet explorer shows a blank page, how do I fix this?

5

How to do login in mysql with unix shell.

548

Tell us which data visualization libraries do you use?

123

Explain what is log shipping?

583

Explain the difference between function and method in scala?

1

Where are local variables stored in c?

574

Explain how can one quickly estimate the additional pressure drop to be introduced with more tube passes?

593

Can you write a class without specifying namespace?

591

What is inline function in c#?

513