Answer Posted / balanarasimhudu

By using TABULATE procedure, we can get quick descriptive statistics on data, but it does not meet the typical needs of generating clinical trial tables, some reasons.
 It does not provide p-values beyond a simple t-test.
 It does not present “n (%)” in a desired format.
 Variable labels are not clearly differentiated from the summary statistics labels.
 “Page X of N” pagination is not available.
 Missing values are handled in an “all or nothing” way, so if you exclude missing
values for one variable, you end up excluding all data for that record for the other
variables in the summary.
 It does not place population counts in the column heading.

The REPORT procedure was designed as a flexible report writing tool that combines features of the PRINT, MEANS, and TABULATE procedures along with “PUT” capabilities commonly used in the DATA step. so, I prefer to use proc report until I have cross tabulation tables, because, it gives me so many options to modify the look up of my table,(Ex: width option, by this we can change the width of each column in table like this so many options, statements we can use in proc report).

what techniques and/or procs do you use for tables? : Sas programming

991

---

What is the difference between the proc sql and data step?

1103

---

How would you invoke a macro? : sas-macro

1035

---

how can you put a "trace" in your program? : Sas programming

1001

---

How to specify variables to be processed by the freq procedure?

1022

---

Tell e how how dealt with..

2167

---

how many display types available in sas bi dashboard? : Sas-bi

1029

---

What sas features do you use to check errors and data validation?

1158

---

what is operational data and operational system? : Sas-di

1053

---

How substr function works in sas?

1149

---

What is the role of sas grid administrator? : sas-grid-administration

1229

---

What Proc glm does?

1020

---

Have you used macros? For what purpose you have used? : sas-macro

989

---

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.

2219

---

Do you need to rearrange the order of the data for the report?

2246

---