How can you put a "trace" in your program?
Answer Posted / shru
Use below command before coding where you require the log
to Trace:
ods trace on / label
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Mention what are the data types does SAS contain?
What is run-group processing?
What sas features do you use to check errors and data validation?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What does the RUN statement do?
What can be the size of largest dataset in SAS?
Name types of category in which SAS Informats are placed?
What is the difference between nodupkey and nodup options?
How can I remove header from output data set?
how does sas handle missing values in sort order? : Sas programming
What is the difference between %put and symbolgen? : sas-macro
What is the purpose of _character_ and _numeric_?
What is the difference between class statement and by statement in proc means?
what is sas olap server? : Sas-di
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.