Answer / kiran

Return statement is used to return to a called module some
thing similar to a GOTO statement,

GOTO Label1:

Label1:

Statement 1;
Statement 2;
RETURN;

Here the RETURN statement helps in branching back to GOTO
label1 statement after performing statements in Label1

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.

0 Answers  

---

How do you download a flat file from Mainframe to your local PC using SAS?

3 Answers  

---

What is the difference between INPUT and INFILE ?

0 Answers  

---

What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers   CitiGroup,

---

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,

---

Name the option to produce a frequency line items rather that a table.

2 Answers  

---

How would you include common or reuse code to be processed along with your statements?

5 Answers   PSCI,

---

Name statements that are execution only?

7 Answers  

---

Approximately what date is represented by SAS date value of 730

9 Answers  

---

Which date function advances a date, time or datetime value by a given interval?

0 Answers  

---

what is sas and what are the functions? : Sas-administrator

0 Answers  

---

How to limit decimal places for variable using proc means?

0 Answers  

---