what is the basis for selection of arrays or pointers as data structure in a program
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.
Hi am New to Automation Testing , any one can you help me what are the basic questiion are asked an interview?
what is a pulse transformer? how rise time of pulse changes when ever the voltage changes?
Being a HRM how will you formulate an effective HRP process.
Hi friends ineed finacial analyst interview question Pls share it
What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?
what is the minimum compressive strength of clay brick
what are the balancing segments in AR?
Whis is not false in primary key?
In GC calibration,what is the procedure to calibrate the TCD (thermal counductivity detector)suggest ?
The number of spring loaded balls provided circumferentially in a synchromesh gear box is a) 3 b) 4 c) 5 d) 6
What are some of the limitations of state machines? When is the use of state machines appropriate, and when are they insufficient to generate the kinds of behaviors you need in a game?
What are do's and dont's of Interface?
Dear sir, my knowledge about cable size determination is limited. Though I read examples I could not calculate the Cable size required for electric driven pump 40 KW, 380 Volt, 50 HZ, 50 meter from transformer and it is three phase star delta starting. Please help as there is no one in my surroundings to help.
