Interested to Buy Any Domain ? << Click Here >> for more details...
please can you tell me that in companies sas work are doing
by through sas coding or sas wizard ??
- 0 Answers
- 2056 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How we can create SAS USER DEFINED CODE?
What is difference between rename and lable in sas?
What is the difference between input and infile statement?
what is the difference between proc means and proc tabulate?
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
How do you add a number to a macro variable?
Name types of category in which SAS Informats are placed?
What is substr function?
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
Give some examples where proc report’s defaults are same as proc print’s defaults?
How could you generate test data with no input data?
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.
Teradata 
