Answer Posted / murray
To a certain extent I agree with #2. Sometimes time can be
wasted developing the most efficient and reusable code if
the task at hand can be completed with simple hardcoding,
and is unlikely to be needed in future.
It is, however always best to avoid hardcoding.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What would be the value of month at the end of data step execution and how many observations would be there?
What is connection profile? : sas-grid-administration
What system options would you use to help debug a macro? : sas-macro
How do you delete duplicate observations in sas?
What is your favorite all time computer book? Why?
explain about sas business intelligence? : Sas-bi
What does the trace option do?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
If money were no object, what would you like to do?
What do you know about symput and symget?
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.
what is hash files in sas and why we are using this one in sas?
What are the different versions of sas that you have used until now? : sas-grid-administration
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
explain what is data set in sas? : Sas-administrator
