Answer Posted / thirumalesh.e
when you write your sas programme include debugging and macro debugging statements at each step boundary and check for errors and messages at log by including put statement along with macro expressions. use all macro debugging statements efficiently. if you get right programme with less or no errors after debugging its validated and file the validated programme according to regulations.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you delete duplicate observations in sas?
Compare sas with other data analytics tools.
Which date function advances a date, time or datetime value by a given interval?
Which command is used to perform sorting in sas program?
explain the function of substr in sas? : Sas-administrator
What is the general format of function in sas? : sas-grid-administration
Give an example where SAS fails to convert character value to numeric value automatically?
What are common programming errors committed in sas
what has been your most common programming mistake? : Sas programming
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.
describe about metadata object? : Sas-di
name some data transformation used in sas di? : Sas-di
name the scheduler for scheduling job and explain the scheduler? : Sas-di
how do you debug and test your sas programs? : Sas programming
Mention what are the data types does SAS contain?
